Re: view including contraint info

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Mon, 25 Jan 1999 10:53:05 +0800
Message-ID: <36ABDC91.7586@bhp.com.au>

dingfei_at_163.net wrote:
>
> Hi, all.
>
> I encounter a problem when i do imp operation.
> The imp log file said that 'row rejected due to ORACLE error 1
> IMP-00003: ORACLE error 1 encountered
> ORA-00001: unique constraint (DEMO.SYS_C00473) violated'.
> I know that a constaint must exist, but from which view could i get info about
> obj like constraint and the content of such constaints?
>
> Any help will be appreciated.
>
> with regards
> Mike Ding
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

USER_CONSTRAINTS contains list of constraints USER_CONS_COLUMNS contains columns affected by each constraint

Cheers
--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad"

• Salvador Dali

Received on Sun Jan 24 1999 - 20:53:05 CST