| 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:Big Dump file (12gb) from nt to
Hi hessu,
Your export might have been right one,Which unix r u using .can you give info..
There is a command strings in AIX which gives all the printable characters of any object-file or dumpfile.So try similar command in your unix.
and give the following at the command prompt
>strings "dumpfile"|grep table_name (the table you are worried) It may take
few minutes.because of the file-size....But it'll give some result.
Ignore any error line-length can't be more than 2048 chars. etc.Otherwise you can use AWK.
Otherwise narrow your import parameter file to that table only,,,And give show=y paramater...I am not sure this'll work b'cause imp not able to read
the table_name itself. ANYWAY try with strings command and let me know
Cheers
Ganti
Hi all,
I am facing some problems while trying to import the huge file (12gb) from nt db to unix db.
The error I'm receiving is like this:
IMP-00009: abnormal end of export file
IMP-00033: Warning: Table "XXX_XXXX" not found in export file...
I am using the pipe but still it fails. Here is the syntax for import
imp SYSTEM/XX FROMUSER=XXX TOUSER=XXX BUFFER=150000000 IGNORE=Y TABLES=XXX FILE=./XXX LOG=./imp.log
And the table is on that file...
Br and thanks,
Hessu
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Heikki Jantunen INET: hjantunen_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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). ------------------------------------------------------------------- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you We reserve the right to monitor all e-mail communications through our network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: GANTI.SIVA_at_ponl.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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 Mon Feb 26 2001 - 05:58:57 CST
 |
 |