ora-1788

From: Sweetser, Joe <Joe.Sweetser_at_infocrossing.com>
Date: Thu, 31 Aug 2006 09:20:29 -0700
Message-ID: <5CF4A34EE1FEA144B7474DC97E2F73A9F34FCF@MAPI.iconnection.com>

Can't find much on this yet and thought I would ask here. While trying to get values from sys.exppkgact$ to reinsert after performing a full export without the analytic workspaces in a database, I ran into this error when I added the last column to the query. I was told to "delete from sys.exppkgact$ where package = 'DBMS_AW_EXP';" to prevent the AW's from being exported in a full export. This is being done because we are importing from 10.1 to 10.2 and have to do the AW's separately. Not being a SQL wizard, I wonder if someone could explain the error and/or point me to the right docs to understand it.

Thanks,
-joe

http://www.peaceaday.com

SQL> select package, schema, class from sys.exppkgact$ where package='DBMS_AW_EXP';

PACKAGE                        SCHEMA                              CLASS


------------------------------ ------------------------------ ----------

DBMS_AW_EXP                    SYS                                     2

SQL> select package, schema, class, level from sys.exppkgact$ where package='DBMS_AW_EXP';
select package, schema, class, level from sys.exppkgact$ where package='DBMS_AW_EXP'

                                              *

ERROR at line 1:
ORA-01788: CONNECT BY clause required in this query block

SQL>
--

http://www.freelists.org/webpage/oracle-l Received on Thu Aug 31 2006 - 11:20:29 CDT