Re: Oracle export/import

Misha wrote:
>
> Hello,
>
> The problem is:
> I exported data (export utility) from table t1, but want to use result
> dmp file to import data (import utility) from this file to a new empty
> table t2 (different table with the same structure as t1). Is it
> possible?
>
> I don't have any problem importing data to empty t1 (setting ignore=y)
> or creating new t1.
>
> Thank you!
> Misha-

You could put an INSTEAD OF trigger on the T1 to send the results to T2

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."