Interesting... You could use imp ... Indexfile=xxx.sql to get the sql statements out into a file you can edit..
Then precreate the tables using sqlplus and that file...

Terry

-----Original Message-----
From: Jim Thomas [mailto:oracledba-ezmlmshield-x25812014.[Email address protected]
Sent: Wednesday, April 30, 2008 9: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




Oracle LazyDBA home page