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

"«ó¤S°¾¤SÄF" <mcc95_at_hotmail.com> wrote in message news:99spnr01stn_at_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.
>

Telling someone to edit the file in a hex editor is rather different from just blandly telling them, as Todd originally did, to "then edit the path names for the datafiles (so tablespaces can be created)."

Todd has since claimed that there is no distinction in Unix between binary and text files (I quote: "You don't work on a Unix system! Sucks, don't it! I'm happy that I work on systems that don't draw a distinction between text & binary data"), so he and you seem to be pursuing entirely different tracks any way.

Unless Todd can enlighten us on how he's managed to routinely pull off this particular bit of magic, the statement stands: you cannot simply open up an export dump file in a normal text editor and tap away on the keyboard to your heart's content. You will corrupt the file, and a subsequent import will return a variety of errors, but most commonly will report an IMP-00038 "Could not convert to environment character set's handle". And it would appear that you agree with that statement.

Regards
HJR
>
>
> 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 Thu Mar 29 2001 - 06:35:36 CST