| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re: export problem ???
oraora - I doubt that Import did insert that record. The message says it
skipped that record. Check the table to see whether it was inserted. What
did you set for the parameter IGNORE?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Wednesday, December 18, 2002 4:19 AM
To: Multiple recipients of list ORACLE-L
Thanx guys for all your guidance.
Thanx Adar.
i found that an index on table 17 caused all the delay and took a long time to be created.
when i said
IMP FILE=ABC.DAT INDEXES=N ROWS=Y
i was able to get all the tables.
but still,while importing i get the error
IMP-00019: row rejected due to ORACLE error 1401 IMP-00003: ORACLE error 1401 encountered ORA-01401: inserted value too large for columnColumn 1 1110384
Column 4 ++++++++++++++++++++++++++
this causes a few rows to be skipped in some table.
if this is true , it should not have allowed that particular row to be inserted while doing INSERT ?
why does this occur while importing ?
can someone explain me ?
TIA.
Jp.
On Tue, 17 Dec 2002 Yechiel Adar wrote :
>Hello
>
>After building a table the import builds constraint and
>indexes.
>If you got a big table that can take awhile.
>Check with task/performance monitor if the instance is idle or
>working.
>
>Yechiel Adar
>Mehish
>----- Original Message -----
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Sent: Tuesday, December 17, 2002 4:28 AM
>
>
> > guys,
> >
> > i am exporting a DB of size 10G.
> > it totally has 33 tables.
> > everything completes succesfully and even the log file
> > says "EXPORT COMPLETED SUCCESSFULLY WITHOUT ANY WARNING".
> >
> > But while importing it,only 17 tables are imported.
> > after that the cursor stands still and the import does
> > not process further.the remaining 16 tables are not imported
> > at all.
> >
> > why is it so ? have any of you come across such situation ?
> >
> > will datafiles of size greater than 2G cause such problem ?
> >
> > the DB is on oracle 8.1.6/Win2k.
> >
> > kindly let me know guys.
> >
> > TIA.
> > Jp.
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: oraora oraora
> > INET: oraoraora_at_rediffmail.com
> >
> > Fat City Network Services -- 858-538-5051
>http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting
>services
> >
>---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail
>message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
>and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).
>You may
> > also send the HELP command for other information (like
>subscribing).
> >
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Yechiel Adar
> INET: adar76_at_inter.net.il
>
>Fat City Network Services -- 858-538-5051
>http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting
>services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail
>message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and
>in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You
>may
>also send the HELP command for other information (like
>subscribing).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: oraoraora_at_rediffmail.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Dec 18 2002 - 06:27:59 CST
 |
 |