How to exclude a Table during Import

[shweta....@googlemail.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.

[Viktor Zacek]

<shweta....@googlemail.com> wrote:

> 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.

I know of no way in Oracle 9i.

You can do it with datapump which is in Oracle 10g.

Best regards,
Viktor Zacek

[Mark D Powell]

On Jan 7, 10:49 am, usenet2...@zacek.de (Viktor Zacek) wrote:

On 9.2.0.6 as Viktor said there is no native imp parameter to exclude
a single table from the import.

One way to simulate the feature might be if no objects exist for the
user so that you can run imp using the default ignore=n parameter
value then precreate the one undesired table with indexes. Being
empty it will take very little room and on import because the create
table will fall and ignore is set to no then the imp utility will not
insert the data. Now drop the table.

Be sure to use the log= parameter so you have a record of the import
and can verify the results are what you want.

HTH -- Mark D Powell --

[gazzag]

Create an empty table called T2. Run the import as normal. The
import will fail on T2 as the object already exists. The rest of the
tables will be imported as normal.

HTH

-g