ora-1472

From: sankarKK <xtapas_at_gmail.com>
Date: 17 Aug 2005 06:23:59 -0700
Message-ID: <1124285038.948360.22530@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 Received on Wed Aug 17 2005 - 08:23:59 CDT