How to exclude a Table during Import
Date: Wed, 7 Jan 2009 06:46:21 -0800 (PST)
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 : 18.104.22.168
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....
Shweta. Received on Wed Jan 07 2009 - 08:46:21 CST