Running Export Into Multiple Files Gives EXP-00008 ORA-600 [Xsoptloc2] (Doc ID 300849.1)

Last updated on MARCH 10, 2020

Applies to:

Symptoms

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 9.2.0.5 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], [4], [4], [0], [], [], [], []
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;

.

.

.

As the 9.2.0.5 Enterprise Edition patchset was installed in this case, the SELECT statement should show 9.2.0.5 database options (see column 'VERSION'). But the SELECT statement shows only 9.2.0.1 database options.

Changes

RDBMS patchset 9.2.0.5 was applied to a 9.2.0.1 RDBMS instance.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.