Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Q: Want to Migrate 8i from WindowsNT to Linux
Yes, you can EDIT the export file even it is binary. Their have several binary Editors on Internet available and they work file.
In article <3ac1ac2c_at_news.iprimus.com.au>, "Howard says...
>
>
>"Todd Gillespie" <toddg_at_linux127.ma.utexas.edu> wrote in message
>news:99rchr$gl9$1_at_geraldo.cc.utexas.edu...
>> Carl <c_joh_at_hotmail.com> wrote:
>> : Recreate the tablespaces (so that names are matching what was in the
>> : NT). Recreate your users (with the same quota on the various
>> : tablespaces and the same roles) and import your exported system. And
>> : there you are.
>>
>> Alteratively, perform a full export as SYS from your old Oracle, then edit
>> the path names for the datafiles (so tablespaces can be created). (If
>> it's a big dump file, probably only Emacs can handle it. Or perl. Just
>> make sure the editor doesn't think it's smarter than you, eg,
>> auto-linewrap, formatting, MSanything.) If you're working with oracle
>> TYPEs, you might want to delete the IDs in the TYPE creation statements as
>> well.
>>
>> Then do a full import. You're done.
>
>Stuffed, more like.
>
>Anytime I see anyone recommend editing an export dump file in a text editor,
>I get intrigued... has the person doing the recommending ever pulled this
>trick off themselves reliably and repeatedly? 'Cos the dump file is a
>binary file, not a text file, and you can confidently expect editing it to
>result in total garbage.
>
>You might get lucky. I've seen it done, and they got away with it. I
>certainly wouldn't recommend it as a regular pastime, however.
>
>Regards
>HJR
>
>
>
Received on Wed Mar 28 2001 - 07:42:19 CST
![]() |
![]() |