Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Export only tables

Re: Export only tables

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Mon, 2 Apr 2001 11:02:42 +0100
Message-ID: <986205777.14179.0.nnrp-09.c30bdde2@news.demon.co.uk>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US