Re: how to exclude a table when export?

In article <90s5ma$kmg$1_at_nnrp1.deja.com>,   susana73_at_hotmail.com wrote:
> Hi,
>
> I am going to export an entire user(tables, indexes, constraints,
> grants...). There is a single large table that I don't want to
 export.
> Is there anyway to get around on the exp command line? I am using exp
> user mode and don't want to specify all my 100 tables on the command
> line.
>
> Thanks,
> Susan
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

The keyword 'file' allows you to select a table. For 100 tables, the command line could be really long. However, you can build a script file with all the commands plus the 100 files and execute that.

Alternatively, you could make a shell script with the big line in it and execute that.

--
Michael Krolewski
Rosetta Inpharmatics
mkrolewski_at_rosetta.org
              Ususual disclaimers


Sent via Deja.com http://www.deja.com/
Before you buy.