Import Errors 2005-07-03 - By J. Dex
I am trying to do a full import into a 9.2.0.6 database from an 8.1.7.4
export. The tablespaces have already been precreated. I am getting two
errors and I can't figure out why because I am trying to do the import as
SYSDBA. Any ideas on why this is happening?
Error #1:
Warning: the objects were exported by ORACLE, not by you
AND
Error #2
ORA-01950 (See ORA-01950.ora-code.com): no privileges on tablespace 'RIBADATA'
However, I am trying to do the export as SYSDBA:
nohup imp \?sys/passwd AS SYSDBA\? parfile=riba9imp.par
IMP-00017: following statement failed with ORACLE error 1950:
"CREATE TABLE "ACCOUNTS" ("ROOTID" VARCHAR2(40) NOT NULL ENABLE, "LV"
"ID" VARCHAR2(40), "LVINDEX" NUMBER(*,0), "VAL" VARCHAR2(255)) PCTFREE 10
P"
"CTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 24576 FREELISTS
1"
" FREELIST GROUPS 1) "
IMP-00003: ORACLE error 1950 encountered
ORA-01950 (See ORA-01950.ora-code.com): no privileges on tablespace 'RIBADATA'
The import is working fine on other tablespaces that were created.
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ __
Is your PC infected? Get a FREE online computer virus scan from McAfee?
Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
--
http://www.freelists.org/webpage/oracle-l
|
|
