Re: Transferring a Database using Toad

When you do the full export using "exp", does this also export the users (connectivity such as passwords and roles granted to those who connect) in the database or just the schemas?

dan

"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 - 22:05:17 CST