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)