Re: Import Errors

From: Jared Still <jkstill_at_gmail.com>
Date: Sun, 3 Jul 2005 11:17:13 -0700
Message-ID: <bf463805070311176623b484@mail.gmail.com>

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_at_hotmail.com> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Jul 03 2005 - 13:19:10 CDT