Links
• Home
• Oracle DBA Forum
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,



As I said in my previous post, I am thinking that the system user is not
able to import statistics for the table to the CONSOL user.  Try
importing using the CONSOL user.  You may need to grant the
IMP_FULL_DATABASE role to the CONSOL user for this to work.



Tom



__ ____ ____ ____ ____ ____ ____

From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Bryan Wells
Sent: Friday, August 12, 2005 9:39 AM
To: Niall Litchfield
Cc: Oracle-L
Subject: Re: Import Help



First of all, thank you all for your comments and assistance.  I can
only hope that one day i have been pulled through the mud enough to
learn something and share on this or other forums.



here is the batch contents that calls the below listed attributes:



imp 'system/######@(protected) as sysdba' parfile=imp_consol_part_table.txt



After seeing Mladen's reply, I double checked the table structures.
After all, Im DBA in training.  I did need to add that attribute to the
table, however, this is one of many, many errors of the same nature,
where the table attributes exist.  I even recreated INVOICE_ITEM in the
test instance with the ddl from the production instance, less the
partitioning of course.  Still the same error.



grazie...

B


On 8/12/05, Niall Litchfield <niall.litchfield@(protected)> wrote:

On 8/11/05, Bryan Wells <bunjibry@(protected)> wrote:
> 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?

I'm with mladen here - I don't see why you are getting a DBMS_STATS
error if not choosing to import stats.

that said is the table definition the same in your target as it was in
the source? i.e does dw_sold_to_customer_id exist in the invoice table
for your target db?

--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com




--
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)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@(protected)
  {font-family:Tahoma;
  panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
  {margin:0in;
  margin-bottom:.0001pt;
  font-size:12.0pt;
  font-family:"Times New Roman";}
a:link, span.MsoHyperlink
  {color:blue;
  text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
  {color:blue;
  text-decoration:underline;}
span.EmailStyle18
  {mso-style-type:personal-reply;
  font-family:Arial;
  color:navy;}
@(protected) Section1
  {size:8.5in 11.0in;
  margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
  {page:Section1;}
-->
</style>

</head>

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

<div class=Section1>

<p class=MsoNormal><st1:City w:st="on"><st1:place w:st="on"><font size=2
 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
 color:navy'>Bryan</span></font></st1:place></st1:City><font size=2
color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>,<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>As I said in my previous post, I am
thinking that the system user is not able to import statistics for the table to
the CONSOL user. &nbsp;Try importing using the CONSOL user.&nbsp; You may need
to grant
the IMP_FULL_DATABASE role to the CONSOL user for this to work.<o:p></o:p><
/span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Tom<o:p></o:p></span></font></p>

<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<div>

<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>

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

</span></font></div>

<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Bryan Wells<br>
<b><span style='font-weight:bold'>Sent:</span></b> Friday, August 12, 2005 9:39
AM<br>
<b><span style='font-weight:bold'>To:</span></b> Niall Litchfield<br>
<b><span style='font-weight:bold'>Cc:</span></b> Oracle-L<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: Import Help</span><
/font><o:p></o:p></p>

</div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>First of all, thank you all for your comments and assistance.&nbsp; I
can only hope that one day i have been pulled through the mud enough to learn
something and share on this or other forums.<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>here is the batch contents that calls the below listed attributes:<o:p>
</o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>imp <a href="mailto:'system/######@(protected)">'system/######@(protected)</a>
as sysdba' parfile=imp_consol_part_table.txt<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>After seeing Mladen's reply, I double checked the table
structures.&nbsp; After all, Im DBA in training.&nbsp; I did need to add that
attribute to the table, however, this is one of many, many errors of the same
nature, where the table attributes exist.&nbsp; I even recreated INVOICE_ITEM
in the test instance with the ddl from the production instance, less the
partitioning
of course.&nbsp; Still the same error. <o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>grazie...<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>B<br>
&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=MsoNormal><span class=gmailquote><font size=3 face="Times New Roman">
<span
style='font-size:12.0pt'>On 8/12/05, <b><span style='font-weight:bold'>Niall
Litchfield</span></b> &lt;<a href="mailto:niall.litchfield@(protected)">niall
.litchfield@(protected)</a>&gt;
wrote:</span></font></span> <o:p></o:p></p>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>On 8/11/05, Bryan Wells &lt;<a href="mailto:bunjibry@(protected)"
>bunjibry@(protected)</a>&gt;
wrote:<br>
&gt; Can some one see what I am missing/doing wrong?&nbsp;&nbsp;I am attempting
to import <br>
&gt; data from a parfile to get data from a partitioned table to
non-partitioned<br>
&gt; table and am getting the following error.&nbsp;&nbsp;i have truncated the
tables and<br>
&gt; set ignore=y.&nbsp;&nbsp;is that not enough?<br>
<br>
I'm with mladen here - I don't see why you are getting a DBMS_STATS <br>
error if not choosing to import stats.<br>
<br>
that said is the table definition the same in your target as it was in<br>
the source? i.e does dw_sold_to_customer_id exist in the invoice table<br>
for your target db?<br>
<br>
--<br>
Niall Litchfield<br>
Oracle DBA<br>
<a href="http://www.niall.litchfield.dial.pipex.com">http://www.niall
.litchfield.dial.pipex.com</a><o:p></o:p></span></font></p>

</div>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
<br clear=all>
<br>
-- <br>
Bryan Wells<br>
<a href="mailto:bunjibry@(protected)">bunjibry@(protected)</a><br>
Oracle DBA hopeful <o:p></o:p></span></font></p>

</div>

</body>

</html>