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 column Column 1 1110384 Column 2 15798 Column 3 D Column 4 ++++++++++++++++++++++++++ Column 5 candy this causes a few rows to be skipped in some table. ----- ORA-01401: inserted value too large for column ----- 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 <[EMAIL PROTECTED]> >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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).