Re: Moving Database from NT -> AIX

You should also experiment with spooling the contents out to a flat file and then using SQL Loader to populate the new database. You can find a script that unloads at
http://govt.us.oracle.com/~tkyte

Another possibility is to create a database link and then just do a series of:

CREATE TABLE <table_name> AS SELECT * FROM <table_name>@<db_link_name>;

I have found both of these approaches to be much faster than export/import.

hth
jerry gitomer

sherwin_at_my-deja.com wrote in message
<822vtb$4ho$1_at_nnrp1.deja.com>...
|Thanks for the prompt replies guys, you confirmed what I already
|suspected. I'll be off now to do some hefty exporting ;)
|
|Sherwin
|
|
|Sent via Deja.com http://www.deja.com/
|Before you buy.
Received on Thu Dec 02 1999 - 00:19:12 CST