> 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
>
> can anyone please help with some idea.
Not a solution -- just an idea.
Enable extended SQL trace (10046 event) for exp session, analyze trace
file and see what statement generated ORA-1472.
--
Egor
http://www.oracledba.ru/orasrp/
Free Oracle Session Resource Profiler
Received on Thu Aug 18 2005 - 00:51:39 CDT
