Import Errors

From: J. Dex <cemail_219_at_hotmail.com>
Date: Sun, 03 Jul 2005 12:03:15 -0400
Message-ID: <BAY106-F32E49282EB5362F37313C7A5E40@phx.gbl>

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

Received on Sun Jul 03 2005 - 11:05:12 CDT