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

Home -> Community -> Usenet -> c.d.o.server -> Re: Export Only Tables

Re: Export Only Tables

From: Jeff Hunter <jeffh_at_btitelecom.net>
Date: Wed, 1 Sep 1999 13:05:32 -0400
Message-ID: <37cd5d10@defiant.btitelecom.net>

exp user/password_at_service file=outfile.dmp tables=table1, table2, etc... log=outfile.log

Tapan Trivedi wrote in message <37CC429E.60426213_at_abbnm.com>...
>Hi all,
> I have a strange requirement where I need to export a users tables (and
>only tables and nothing else like views,synonyms etc). The users tables
>can be changing all the time and the export has to be non-interactive.
>Does anybody know of a parfile setting or do I need a shell script ?
>Does anyone know where such a script or an example of the same exists.
>We are on 7.3.4 on Digital UNIX. Any comments ,experiences,suggestions
>welcome.
>
> Tapan H Trivedi
Received on Wed Sep 01 1999 - 12:05:32 CDT

Original text of this message

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