Re: How to exclude a Table during Import

From: gazzag <gareth_at_jamms.org>
Date: Thu, 8 Jan 2009 06:00:27 -0800 (PST)
Message-ID: <9f6c440d-9183-4214-8051-80b7037784b3_at_p36g2000prp.googlegroups.com>

On 7 Jan, 14:46, shweta.kapar..._at_googlemail.com wrote:
> 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.

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 Received on Thu Jan 08 2009 - 08:00:27 CST