|
[oracle-l]
||
[Date Prev]
[07-2005 Date Index]
[Date Next]
||
[Thread Prev]
[07-2005 Thread Index]
[Thread Next]
Import Errors
- From: "J. Dex" <cemail_219@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sun, 03 Jul 2005 12:03:15 -0400
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: 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: 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
|
