How to exclude a Table during Import
From: <shweta.kaparwan_at_googlemail.com>
Date: Wed, 7 Jan 2009 06:46:21 -0800 (PST)
Message-ID: <94df456a-785a-43af-8c2e-f4a263d8aad3_at_h41g2000yqn.googlegroups.com>
Hi All,
Date: Wed, 7 Jan 2009 06:46:21 -0800 (PST)
Message-ID: <94df456a-785a-43af-8c2e-f4a263d8aad3_at_h41g2000yqn.googlegroups.com>
Hi All,
I have taken backup of entire schema using
exp un/pass owner=TOM file=tom.dmp .....
Suppose TOM has 03 tables T1 , T2, T3 in his schema.
Now , while import the entire tom.dmp file to some other database , excluding T2 table.
How to do that in import statements.?
I mean is there any option in import which can be used to exclude few
tables.
Database ver : 9.2.0.6
OS : HP UX 11i
Other way is I can take export table-wise and exclude the same during export itself. But for I need to change my export script and other stuffs....
Regards
Shweta. Received on Wed Jan 07 2009 - 08:46:21 CST