Re: Export only tables

Sybrand Bakker <postbus_at_sybrandb.demon.nl> a écrit dans le message : tcbruv4389uh5c_at_beta-news.demon.nl...
>
> "LeguMan" <leguman_at_hotmail.com> wrote in message
> news:3ac5e6c6$0$27802$456d72a3_at_news.skynet.be...
> > Hello,
> >
> >
> > How can i export only all tables (not the user) from a database in
 Oracle
 8i
> > entreprise NT4
> >
> > Ps: Oracle Management Server not running
> >
> >
> > I have find the exp command but i don't find the syntax.
> >
> >
> >
> > Thanks,
> > LeguMan
> >
> >
> >
> The syntax is in the Oracle Server Utilities Manual or by typing exp
 help=y
> In this particular case you need to export a single user, the create user
> statement is not exported. Views and the like can not be surpressed
 though.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>

Great it works, with exp command !

But how to export all tables in one shoot ?

Thanks
LeguMan Received on Sat Mar 31 2001 - 12:52:21 CST