This will depend a bit on what statements you want to alter at the
beginning of the file... If you want your files for tablespaces in
different locations, just create the tablespaces before running imp.
There are binary characters that windows/DOS assume mark the end of the
file which you might be encountering. I know of at least one person
that has edited a dump and successfully loaded it but he had to
slaughter three chickens to get it to work.
So... what kind of changes are you trying to implement through your
edits?
-----Original Message-----
From: Jim Thomas
[mailto:oracledba-ezmlmshield-x25812014.[Email address protected]
Sent: Wednesday, April 30, 2008 11:07 AM
To: LazyDBA Discussion
Subject: EDITING LARGE BINARY FILES
Dear Lazy DBA's
I have this large file 140megs that is an Oracle export file on UNIX.
We would like to import it into another table, that is a duplicate-
however the statements at the beginning of the file need to be
altered. If I am not mistaken this is a binary file/text-
vi editor will not open it because it states that the line is too long!
I have tried to FTP to my windoze box in both ASCII and Binary
so That I could use Ultra Edit , but for some reason only a portion of
the file
gets transffered.
Any advice would be greatly appreciated
Thank You
Jim T
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This e-mail is confidential. If you are not the intended recipient, you must not disclose or use the information contained in it. If you have received this e-mail in error, please tell us immediately by return e-mail to Email.[Email address protected] and delete the document.
E-mails containing unprofessional, discourteous or offensive remarks violate Sentry policy. You may report employee violations by forwarding the message to Email.[Email address protected]
No recipient may use the information in this e-mail in violation of any civil or criminal statute. Sentry disclaims all liability for any unauthorized uses of this e-mail or its contents.
This e-mail constitutes neither an offer nor an acceptance of any offer. No contract may be entered into by a Sentry employee without express approval from an authorized Sentry manager.
Warning: Computer viruses can be transmitted via e-mail. Sentry accepts no liability or responsibility for any damage caused by any virus transmitted with this e-mail.
Oracle LazyDBA home page