Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Export only tables
Pass them in the "tables=()" parameter.
"LeguMan" <leguman_at_hotmail.com> wrote in message
news:3ac6267c$0$30799$456d72a3_at_news.skynet.be...
> 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 Mon Apr 02 2001 - 05:02:42 CDT
![]() |
![]() |