Re: Partially Import from a dump file

Presumptavely, the db is in place.

Get a list of the table names spooled from dba_tables ("select owner||'.'||tablename from dba_tables order by owner||'.'||tablename ") with a where clause for your owners.

Edit the spool file into a par file for import, delete the unwanted table, start the import and go to lunch.

Thomas Kyte <tkyte_at_us.oracle.com> wrote in message news:<9il8i7046t_at_drn.newsguy.com>...
> In article <ztm37.113$H%4.4487_at_nreader1.kpnqwest.net>, "Gaby" says...
> >
> >Hi,
> >I want to import all tables from a dump file, but i want to exclude one.
> >I know the option from import 'tables=xxx'. I have, I don't know really, but
> >ap 150 tables.
> >So I want to import 149 and the last table seperate (it's the greatest table
> >with many indexes).
> >Can anyone help me?
> >DB-Version = 8.1.7.0.0
> >
> >--
> >Gaby
> >gspiessl_at_gmx.at
> >
> >
>
> quick idea:
>
> put a trigger on the table that is simply:
>
> create or replace trigger T
> before insert on that_table
> begin
> raise_application_error( -20001, 'go away' );
> end;
>
>
> imp will import the 149 tables successfully, hit this one and skip it and
> "terminate with warnings" (or errors but who cares, it commits after each table)
>
>
> drop trigger after importing.
Received on Sat Jul 21 2001 - 16:37:16 CDT