RQ: Re: view including contraint info

In article <36ABDC91.7586_at_bhp.com.au>,
  Connor McDonald <mcdonald.connor.cs_at_bhp.com.au> wrote:
> 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

Thanks, Connor.
I have another question:
i would like to do imp now, what should i do for a successful imp operation? just del such constraint? is it possible to del such constaints?

Any ideas will be appreciated.

Best regards
Mike Ding

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Jan 25 1999 - 07:34:52 CST