. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects
and actions
EXP-00008: ORACLE error 33272 encountered
ORA-33272: Analytic workspace
DOTSOFT.DSLAB1 cannot be opened.
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_AW", line
67
ORA-06512: at "SYS.DBMS_AW", line
131
ORA-06512: at "SYS.DBMS_AW", line
701
ORA-06512: at "SYS.DBMS_AW", line
1045
ORA-06512: at "SYS.DBMS_AW_EXP",
line 514
ORA-06512: at line 1
EXP-00083: The previous problem occurred
when calling SYS.DBMS_AW_EXP.schema_info_exp
. exporting user history table
. exporting default and system auditing
options
. exporting statistics
Export terminated successfully with
warnings.
The error tells that there is some kind of issue with the OLAP installation -- there are numerous reportings of these errors; essentially they are typically due to post_upgrade issues, invalid olap objects, prior attempt to drop olap functionality/objects ...
The export completed (though with this one warning), so you should be able to rebuild your DB using the export dump file.
If you do not use OLAP, and are concerned about the warning message, then doing
This step will prevent Analytic Workspaces from being exported via exp commands
SQL> delete from sys.exppkgact$ where
package = 'DBMS_AW_EXP' and schema= 'SYS';
2 rows deleted.
SQL> commit;
Commit complete.
and then re-running
the full export; it will then complete without this error/warning.