Import Help

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 Help

Import Help

2005-08-12 - By Mercadante, Thomas F (LABOR)

Reply: 1 2 3 4 5 6

Bryan,

What Oracle account are you using to run the import command? Is it the
CONSOL user? Does this user have IMP_FULL_DATABASE role? I think this
is a permissions problem where maybe you can create the tables but do
not have permissions to import the stats to the tables/columns. Does
the table get created correctly in the CONSOL account?

Tom

__ ____ ____ ____ ____ ____ ____

From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Bryan Wells
Sent: Thursday, August 11, 2005 4:40 PM
To: Oracle-L
Subject: Import Help

Can some one see what I am missing/doing wrong? I am attempting to
import data from a parfile to get data from a partitioned table to
non-partitioned table and am getting the following error. i have
truncated the tables and set ignore=y. is that not enough?

FILE=\\lon1-gdwt\f$\Oracle\GDWSTG\Backups\GDWSTG_CONSOL_EXP.DMP
LOG=\\lon1-gdwt\f$\Oracle\GDWSTGT\Backups\GDWSTG_CONSOL_IMP.log
STATISTICS=NONE
FROMUSER=CONSOL
TOUSER=CONSOL
TABLES=(
INVOICE,
INVOICE_ITEM,
JOURNAL_ENTRY,
JOURNAL_ENTRY_LINE,
ORDER_DETAIL,
ORDER_HEADER,
RMA_DETAIL,
RMA_HEADER,
RMA_NOTES)
CONSTRAINTS=N
INDEXES=N
IGNORE=Y

IMP-00017: following statement failed with ORACLE error 20000:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C105';
SREC.MAXVAL "
":= 'C32C065D'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS :=
DBMS_STA"
"TS.NUMARRAY(4,430592); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1);
SREC.EPC :="
" 2;
DBMS_STATS.SET_COLUMN_STATS(NULL,'"INVOICE"','"DW_SOLD_TO_CUSTOMER_ID"'"

",'"CONSOL_INVOICE_FY05"',NULL,NULL,3137,.000318775900541919,0,srec,4,0)
; EN"
"D;"
IMP-00003: ORACLE error 20000 encountered
ORA-20000 (See ORA-20000.ora-code.com): Unable to set values for column DW_SOLD_TO_CUSTOMER_ID: does
not exist or insufficient privileges
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_STATS", line 3365
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_STATS", line 3523
ORA-06512 (See ORA-06512.ora-code.com): at line 1

--
Bryan Wells
bunjibry@(protected)
Oracle DBA hopeful

<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft
-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1=
"urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC
-html40">

<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>

<style>

</style>

</head>

<body lang=EN-US link=blue vlink=blue>

<div class=Section1>

<st1:City w:st="on"><st1:place w:st="on">Bryan</st1:place></st1:City>,<o:p></o:p>

<o:p> </o:p>

What Oracle account are you using to run
the import command?  Is it the CONSOL user?  Does this user have IMP
_FULL_DATABASE
role?  I think this is a permissions problem where maybe you can create the
tables but do not have permissions to import the stats to the tables/columns.
  Does
the table get created correctly in the CONSOL account?<o:p></o:p>


<o:p> </o:p>

Tom<o:p></o:p>

<o:p> </o:p>

<div>

<div class=MsoNormal align=center style='text-align:center'>

<hr size=2 width="100%" align=center tabindex=-1>

</div>

From:
oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] On Behalf Of Bryan Wells 
Sent: Thursday, August 11, 2005
4:40 PM 
To: Oracle-L 
Subject: Import Help
<o:p></o:p>

</div>

<o:p> </o:p>

<div>

Can some one see what I am missing/doing wrong?  I am attempting
to import data from a parfile to get data from a partitioned table to
non-partitioned table and am getting the following error.  i have
truncated the tables and set ignore=y.  is that not enough? <o:p></o:p>

</div>

<div>

 <o:p></o:p>

</div>

<div>

FILE=\\lon1-gdwt\f$\Oracle\GDWSTG\Backups\GDWSTG_CONSOL_EXP.DMP 
LOG=\\lon1-gdwt\f$\Oracle\GDWSTGT\Backups\GDWSTG_CONSOL_IMP.log 
STATISTICS=NONE 
FROMUSER=CONSOL 
TOUSER=CONSOL 
TABLES=( 
 INVOICE, 
 INVOICE_ITEM, 
 JOURNAL_ENTRY, 
 JOURNAL_ENTRY_LINE, 
 ORDER_DETAIL, 
 ORDER_HEADER, 
 RMA_DETAIL, 
 RMA_HEADER, 
 RMA_NOTES) 
CONSTRAINTS=N 
INDEXES=N 
IGNORE=Y<o:p></o:p>

</div>

<div>

 <o:p></o:p>

</div>

<div>

IMP-00017: following statement failed with ORACLE error 20000: 
 "DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C105';
SREC.MAXVAL " 
 ":= 'C32C065D'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS :=
DBMS_STA" 
 "TS.NUMARRAY(4,430592); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1);
SREC.EPC :=" 
 " 2;
DBMS_STATS.SET_COLUMN_STATS(NULL,'"INVOICE"','"DW_SOLD_TO
_CUSTOMER_ID"'"
 
 ",'"CONSOL_INVOICE_FY05"',NULL,NULL,3137,
.000318775900541919,0,srec,4,0);
EN" 
 "D;" 
IMP-00003: ORACLE error 20000 encountered 
ORA-20000 (See ORA-20000.ora-code.com): Unable to set values for column DW_SOLD_TO_CUSTOMER_ID: does not
exist or insufficient privileges 
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_STATS", line 3365 
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_STATS", line 3523 
ORA-06512 (See ORA-06512.ora-code.com): at line 1 
 
-- 
Bryan Wells 
<a href="mailto:bunjibry@(protected)">bunjibry@(protected) </a> 
Oracle DBA hopeful <o:p></o:p>

</div>

</div>

</body>

</html>