Re: Unix v7 to NT v8 Migration

In article <85vkpc$j2h$1_at_nnrp1.deja.com>,   S. Han <shan168_at_yahoo.com> wrote:
> Hi, all,
>
> We are migrating a very big and old database (Ora 7.2.3) from Unix to
> NT4 running 8.0.5. Exports are really too time consuming and too
painful
> - the entire database is more than 5 GB and some of our "tables" are
> even bigger than 2GB! I would like to know besides Export/Import, is
> there any other way I can use to do the migration? Any suggestions
will
> be deeply appreciated!
>
> Steph
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

You can set up database links in the 8.0.5 database to grab data from the 7.2.3 database. After you have all the data, you can delete the links. Assumes you have pre-created all the needed tablespace, tables, indexes, etc. Nice thing about import/export is it will create all that junk for you.
Have you investigated exporting to a named pipe, and compressing from the pipe? The reverse would be used to uncompress to a named pipe, and then importing from the named pipe. Good Luck!

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 18 2000 - 11:38:41 CST