Re: oracle 9 export all without 1 table

From: pitufo <vandresv_at_gmail.com>
Date: Sun, 1 Mar 2009 04:10:44 -0800 (PST)
Message-ID: <e1939bfd-058c-4ddb-921f-2361d997b9ae_at_j8g2000yql.googlegroups.com>

On Feb 28, 5:54 pm, Michael Austin <maus..._at_firstdbasource.com> wrote:
> hehehe wrote:
> > Hello!
>
> >   I have user name : joe
> > He have 4000 tables. Id like to know if it is possible to export all tables
> > without only one table. Or export all and import all without only one or
> > delete from export dmp file certin table?
>
> > Need help
>
> > regard : MJ
>
> Or - create the new database and user, create a db link on the new
> pointing to the old server/user and create table as select * from dblink...

Or, open database restricted, move unwanted table to another scheme. Export, move back unwanted table to joe's scheme again. You got your export file. Received on Sun Mar 01 2009 - 06:10:44 CST