Re: Copy with PK problem in oracle 9i

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Fri, 28 Feb 2003 00:55:10 +0100
Message-ID: <n79t5vk5cuu4jnej890h2koqqt1qgvkpfc@4ax.com>

On 27 Feb 2003 12:20:37 -0800, nguyend4_at_hotmail.com (David Nguyen) wrote:

> Is there anyway that I can copy to another table when it see the
>duplicate PK it just skip that PK and move to the next one? (I disable
>the trigger because I want to reserve the same PK number)

Sure. create an exceptions table using the utlexcp script (IIRC, and that would be located in $ORACLE_HOME/rdbms/admin) and set up the primary key with
'exceptions into <your newly created exceptions table>' The doco has further details.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Feb 27 2003 - 17:55:10 CST