Re: Transferring a Database using Toad

..but no use whatsoever when transferring between different operating systems.

Paul

"Andy" <enzoweb_at_hotmail.com> wrote in message news:8d4033cd.0201221712.288fcf4b_at_posting.google.com...
> 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 Wed Jan 23 2002 - 04:32:14 CST