Re: oracle 9 export all without 1 table
From: Maxim <mdemenko_at_gmail.com>
Date: Sun, 1 Mar 2009 04:35:57 -0800 (PST)
Message-ID: <d0781411-a20c-45af-8cac-553d09a82c03_at_e18g2000yqo.googlegroups.com>
On 1 Mrz., 13:10, pitufo <vandr..._at_gmail.com> wrote:
> 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.
Date: Sun, 1 Mar 2009 04:35:57 -0800 (PST)
Message-ID: <d0781411-a20c-45af-8cac-553d09a82c03_at_e18g2000yqo.googlegroups.com>
On 1 Mrz., 13:10, pitufo <vandr..._at_gmail.com> wrote:
> 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.
Isn't it much simplier then - drop table, export the rest,flashback to
before drop?
;-)
Best regards
Maxim Received on Sun Mar 01 2009 - 06:35:57 CST