Re: Transferring a Database using Toad

If it's a large database, I'd look at using Transportable Tablespaces. Much quicker (but there are some limitations).

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76956/tspaces.htm#5697

(you need to register for the OTN site, but it's free).

"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message news:<3c4c8b58_2_at_mk-nntp-1.news.uk.worldonline.com>...
> I suggest you just use Oracle export (exp) on the NT box, ftp the file
> (binary!) to the unix box, and run Oracle import (imp) on the latter.
> If you're looking at recent versions of TOAD, there are various flavours of
> 'export' - one uses Oracle export, others use text files. Useful sometimes,
> but not I think particularly so in this case.
>
> Hope this helps,
> Paul
>
> "Ed" <edward_at_unicity.net> wrote in message
> news:22905265.0201211058.4a6f31e1_at_posting.google.com...
> > Hello!
> >
> > A company I work for is going to be transferring a Oracle 8.1.7
> > database that is currently running on a NT box over to an Oracle 8.1.7
> > server running on a unix box. Could I just use the export utility of
> > Toad to export the entire database? Is this dump file it creates the
> > same dump file that PL/SQL or other Oracle utilities use to import?
> >
> > Any information would be much appreciated.
> >
> >
> > Ed
Received on Tue Jan 22 2002 - 19:12:05 CST