Running Export Into Multiple Files Gives EXP-00008 ORA-600 [Xsoptloc2]
(Doc ID 300849.1)
Last updated on FEBRUARY 02, 2022
Applies to:Oracle OLAP - Version 10.2.0.4 and later
Information in this document applies to any platform.
Running an export statement such as the following:
exp system/systempassword@sid full=yes log=c:\logfile.log filesize=1GB file=exp1.dmp, exp2.dmp
on a 184.108.40.206 Enterprise Edition with the OLAP option installed (Windows 2003) returns the following errors in the export log (logfile.log):
EXP-00008: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [xsoptloc2], , , , , , , 
ORA-06512: in "SYS.DBMS_AW", line 347
ORA-06512: in "SYS.DBMS_AW", line 470
ORA-06512: in "SYS.DBMS_AW_EXP", line 270
ORA-06512: in line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_AW_EXP.schema_info_exp
The following was checked in SQL*Plus:
sqlplus '/ as sysdba'
SQL> select comp_name, version, status from dba_registry;
|OLAP Analytic Workspace||220.127.116.11||VALID|
|Oracle OLAP API||18.104.22.168||VALID|
As the 22.214.171.124 Enterprise Edition patchset was installed in this case, the SELECT statement should show 126.96.36.199 database options (see column 'VERSION'). But the SELECT statement shows only 188.8.131.52 database options.
RDBMS patchset 184.108.40.206 was applied to a 220.127.116.11 RDBMS instance.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document