Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Q: Want to Migrate 8i from WindowsNT to Linux

Re: Q: Want to Migrate 8i from WindowsNT to Linux

From: «ó¤S°¾¤SÄF <mcc95_at_hotmail.com>
Date: 28 Mar 2001 05:42:19 -0800
Message-ID: <99spnr01stn@drn.newsguy.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US