Re: Full db Export but exclude some tables

Hi,

if you are running UNIX you can export the full database using a named pipe like this:

>mkfifo exp.pipe
>compress < exp.pipe > dump.dmp.Z &
>exp file=exp.pipe userid=...

I guess the compressed dump will be less than 2GB...

Patrick

"S. Han" wrote:

> Hi,
>
> I need to export the full database. But the problem is it's too big (>
> 3GB). I have to break the export into some smaller ones. How am I able
> to export the full database by excluding some HUGE tables? 90% of tables
> in this db belong to one user. So there is no way I can use "user"
> export. Any help will be appreciated!
>
> Steph
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Jan 12 2000 - 02:53:41 CST