Re: view including contraint info

From: <bulach_at_bestway.com.br>
Date: Tue, 26 Jan 1999 19:23:25 GMT
Message-ID: <78l4n3$9vo$1@nnrp1.dejanews.com>

You can find such informations on the following views:

user_constraints: general informations about the constraints owned by the user. user_cons_columns: information about the columns that it constrains.

Sincerely,
Marcus Voltis Bulach

In article <78e0e5$uf4$1_at_nnrp1.dejanews.com>, 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
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Jan 26 1999 - 13:23:25 CST