Re: ora-1472

"sankarKK" <xtapas_at_gmail.com> wrote in
news:1124285038.948360.22530_at_g49g2000cwa.googlegroups.com:

> Hi,
>
> while taking export I found an error
>
> . exporting synonyms
> . exporting views
> EXP-00056: ORACLE error 1472 encountered
> ORA-01472: cannot use CONNECT BY on view with DISTINCT, GROUP BY, etc.
> EXP-00000: Export terminated unsuccessfully
>
>
> it is not very clear from oracle doc what to do in this situation.
> while importing from the same export dmp file it imports data and gives
> warning
> but imports data only as it has exported
>
> can anyone please help with some idea.
> thanks for your time.
>
> tc
>
>

I suspect that an invalid VIEW exists in the DB Received on Wed Aug 17 2005 - 08:50:12 CDT