Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » suse oracle »

[suse-oracle] ORA-37002

Mad Unix

2006-04-08


I am getting thenfollowing error when I try to export from the 10g on SuSE
Entrp. Linux
C:\Documents and Settings\Administrator>D:\ORACLE9I\bin\EXP.EXE
usr/pass@(protected)
log=C:\exp\usr.log0060408.log

Export: Release 9.2.0.1.0 - Production on Sat Apr 8 15:19:04 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 -
Produc
tion
With the Partitioning, OLAP and Data Mining options
Export done in AR8ISO8859P6 character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user WEB_FINAL
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user WEB_FINAL
About to export WEB_FINAL's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export WEB_FINAL's tables via Conventional Path ...
. . exporting table             CNTRL_UPDATE       1 rows exported
. . exporting table                 CODES      97 rows exported
. . exporting table               COUNTRIES     150 rows exported
. . exporting table                   NAT       0 rows exported
. . exporting table          PRIVATE_ACCOUNTS      19 rows exported
. . exporting table           PRIVATE_CLIENTS       2 rows exported
. . exporting table        PRIVATE_DAILY_TRANS    15614 rows exported
. . exporting table         PRIVATE_OWNERSHIP     159 rows exported
. . exporting table       PRIVATE_TRANSACTIONS   130408 rows exported
. . exporting table        PRIVATE_TRANS_TYPES     112 rows exported
. . exporting table    PUBLIC_DEPOSITED_ANALYSIS     3024 rows exported
. . exporting table      PUBLIC_MAJOR_INVESTORS     735 rows exported
. . exporting table          PUBLIC_OWNERSHIP      72 rows exported
. . exporting table       PUBLIC_PRESINTATIVES     1612 rows exported
. . exporting table         PUBLIC_SDC_MEMBERS     323 rows exported
. . exporting table         PUBLIC_SECURITIES     338 rows exported
. . exporting table    PUBLIC_SHAREBOOK_ANALYSIS     648 rows exported
. . exporting table    PUPLIC_ELECTRONICS_TRADES     1044 rows exported
. . exporting table         PUPLIC_NATIONALITY     358 rows exported
. . exporting table          PUPLIC_TRANSFERS     812 rows exported
. . exporting table                 USERS       0 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
EXP-00008: ORACLE error 37002 encountered
ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP
technica
l support.
ORA-33262: Analytic workspace EXPRESS does not exist.
ORA-06512: at "SYS.DBMS_AW", line 93
ORA-06512: at "SYS.DBMS_AW", line 122
ORA-06512: at "SYS.DBMS_AW_EXP", line 473
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling
SYS.DBMS_AW_EXP.schema_inf
o_exp
. exporting statistics
Export terminated successfully with warnings.
How to resolve this issue

--
madunix
Communications Engineering (RWTH Aachen University)
Systems and Network Engineer
MCSE, IBM AIX System Specialist, CCNP, CCSP(SECUR,CSVPN)
©2008 dba.5341.com - Jax Systems, LLC, U.S.A.