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

"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 - 03:17:14 CST