Re: how to exclude a table when export?

Mike Krolewski wrote:
>
> 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.

Incorrect. 'file' specifies the export dump file to be created (exp.dat is the default).
The keyword 'tables' allows you to specify which tables to export.

Cheers,
GC Received on Sat Dec 09 2000 - 12:09:30 CST