Re: ora-1472

From: Arto Viitanen <arto.viitanen_at_csc.fi>
Date: Thu, 18 Aug 2005 08:33:22 +0300
Message-ID: <43041da2$0$22410$ba624cd0@newsread.funet.fi>

sankarKK wrote:
> 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

http://ora-01472.ora-code.com/ says:

ORA-01472:	cannot use CONNECT BY on view with DISTINCT, GROUP BY, etc.
Cause:	CONNECT BY cannot be used on a view where there is not a 
correspondence between output rows and rows of the underlying table.
Action:	Remove the DISTINCT or GROUP BY from the view or move the 

CONNECT BY clause into the view.

That ora-code.com is quite find domain: ora-nnnnn.ora-code.com describes ora- error messages.

--
Arto Viitanen
CSC, Finland

Received on Thu Aug 18 2005 - 00:33:22 CDT