Import Errors

Links

Frequent Oracle Errors

•	TNS:could not resolve the connect identifier specified
•	Backtrace message unwound by exceptions
•	invalid identifier
•	PL/SQL compilation error
•	internal error
•	missing expression
•	table or view does not exist
•	end-of-file on communication channel
•	TNS:listener unknown in connect descriptor
•	insufficient privileges
•	PL/SQL: numeric or value error string
•	TNS:protocol adapter error
•	ORACLE not available
•	target host or object does not exist
•	invalid number
•	unable to allocate string bytes of shared memory
•	resource busy and acquire with NOWAIT specified
•	error occurred at recursive SQL level string
•	ORACLE initialization or shutdown in progress
•	archiver error. Connect internal only, until freed
•	snapshot too old
•	unable to extend temp segment by string in tablespace
•	Credential retrieval failed
•	missing or invalid option
•	invalid username/password; logon denied
•	unable to create INITIAL extent for segment
•	out of process memory when trying to allocate string bytes
•	shared memory realm does not exist
•	cannot insert NULL
•	TNS:unable to connect to destination
•	remote database not found'>ora-02019
•	exception encountered: core dump
•	inconsistent datatypes
•	no data found
•	TNS:operation timed out
•	PL/SQL: could not find program
•	existing state of packages has been discarded
•	maximum number of processes exceeded
•	error signaled in parallel query server
•	ORACLE instance terminated. Disconnection forced
•	TNS:packet writer failure
•	see ORA-12699
•	missing right parenthesis
•	name is already used by an existing object
•	cannot identify/lock data file
•	invalid file operation
•	quoted string not properly terminated

Import Errors

Import Errors

2005-07-03 - By Jared Still

Reply: 1 2

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@(protected)> 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 (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(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

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 
 <div>On 7/3/05, J
. Dex <<a href="mailto:cemail_219@(protected)">cemail_219@(protected)</a>
> wrote:<blockquote class="gmail_quote" style="border-left: 1px solid
rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I am trying to do a full import into a <a href="http://9.2.0.6">9.2.0.6</a>
database from an <a href="http://8.1.7.4">8.1.7.4</a> 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)            &nbsp
;             
" 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. <a href="http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid
=3963">http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963</a> 
 -- <a href="http://www.freelists.org/webpage/oracle-l">http://www
.freelists.org/webpage/oracle-l</a> </blockquote></div> -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist