Re: Export Only Tables

From: Thiru <tmgn_at_excite.com>
Date: Wed, 01 Sep 1999 15:47:13 -0400
Message-ID: <37CD82C1.FAB76A3E@excite.com>

Hi Tapan
Use TABLES= option of exp utility to export only the Tables. You can also add INDEXES=NO GRANTS=No to disable them..

-Thiru

Tapan Trivedi wrote:

> 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 - 14:47:13 CDT