Xref: alice comp.databases.oracle.misc:30600
Path: alice!news-feed.fnsi.net!dca1-hub1.news.digex.net!dca1-feed2.news.digex.net!intermedia!news.chaven.com!not-for-mail
From: amerar@unsu.com (Arthur Merar)
Newsgroups: comp.databases.oracle.misc
Subject: Table Question
Date: Thu, 06 May 1999 02:43:15 GMT
Organization: Celestial Haven, Illinois, USA.
Lines: 29
Message-ID: <373200b6.177399935@news.chaven.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: news.chaven.com 925957697 6519 207.238.162.69 (6 May 1999 02:28:17 GMT)
X-Complaints-To: abuse@chaven.com
NNTP-Posting-Date: 6 May 1999 02:28:17 GMT
X-Newsreader: Forte Agent 1.5/32.452



Hello,

I have a question about inserting data into tables.  We have two
tables.....one is production, and the other are transactions that need
to be inserted into production.

However, the production table has many constraints on it.  And, it has
a sequence on it.  

So, my question is:  When I insert the records, I get a unique
constraint error on the sequence number.  How can I insert these
records and have the sequence work correctly?  This transaction table
has sequence numbers that must conflict with the production table.

Also, when I export a table, have can I not export the constraints so
when I import it I do not get all the errors if the object exists?

Any help would be appreciated.

Please e-mail a copy of your response.

Thanks,

Arthur
amerar@unsu.com
amerar@ci.chi.il.us