Re: Partially Import from a dump file

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.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp