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

From: Todd Gillespie <toddg_at_linux127.ma.utexas.edu>
Date: 28 Mar 2001 00:51:07 GMT
Message-ID: <99rchr$gl9$1@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. Received on Tue Mar 27 2001 - 18:51:07 CST