Re: Import Errors

Perhaps the output from 'oerr ora 1950' will be helpful:

11:16-poirot:ts60:jkstill-10 > oerr ora 1950
01950, 00000, "no privileges on tablespace '%s'"
// *Cause: User does not have privileges to allocate an extent in the
// specified tablespace.
// *Action: Grant the user the appropriate system privileges or grant the 
user
// space resource on the tablespace.
[ /home/jkstill/oracle/dba/security/tcp_ip_range/proto2 ]

11:16-poirot:ts60:jkstill-10 >

Jared


On 7/3/05, J. Dex <cemail_219@xxxxxxxxxxx> wrote:
> 
> I am trying to do a full import into a 9.2.0.6 <http://9.2.0.6> database 
> from an 8.1.7.4 <http://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(r)
> Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
> 
> --
> http://www.freelists.org/webpage/oracle-l
> 



-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: