How to exclude a Table during Import

From: <>
Date: Wed, 7 Jan 2009 06:46:21 -0800 (PST)
Message-ID: <>

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 :

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

Original text of this message