Re: Table Question

You will have to change the transaction table sequence numbers.

There is a switch on import to "ignore errors on create"... will that help? If not, don't use export... use sqlldr, or even sqlplus, spooling your output to a file... (or if you export/import is just to move the rows from transaction to production... do it with distributed SQL). An additional potential solution would be to remove the constraints. You can build a script to remove them... and another to put them back... obviously, build the one to put them back while they are still present.

If you're not into "building" you can find these scripts on the internet.

Good luck.
David Russell

On Thu, 06 May 1999 11:19:05 GMT, amerar_at_unsu.com (Arthur Merar) wrote:

>
>
>Hello,
>
>I have two tables, our production table and a transaction table. I
>want to insert the records from the transaction table into the
>production table. The tables have the exact same layout.
>
>The problem is that the production has many constraints on it, and it
>has a sequence as one of the fields. When I insert these records, I
>get a unique constraint error on the sequence number.
>
>How can I insert these records have have the sequence work correctly?
>Do I need to do something to the transaction table first???
>
>Also, when I export tables, how can I export the data without the
>constraints, so when I import I do not get all the errors?
>
>Please send a copy to e-mail....
>
>Thanks,
>
>Arthur
>amerar_at_unsu.com
>amerar_at_ci.chi.il.us
Received on Tue May 18 1999 - 18:17:43 CDT