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
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Heikki Jantunen
INET: [EMAIL PROTECTED]
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: [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).
-------------------------------------------------------------------
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: [EMAIL PROTECTED]
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: [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).