Traditional Export Raises ORA-1647 When Default Tablespace Is READ ONLY And Schema Contains Ruleset (Doc ID 550710.1)

Last updated on NOVEMBER 17, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.3 - Release: 10.1 to 10.2
Information in this document applies to any platform.

Symptoms

1. When trying to export schema with traditional export utility (EXP), the below error is received:

. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 1647 encountered
ORA-01647: tablespace 'CCM_AGGR_DATA' is read only, cannot allocate space in it
ORA-06512: at "SYS.DBMS_RULE_EXP_RL_INTERNAL", line 324
ORA-06512: at "SYS.DBMS_RULE_EXP_RULES", line 147
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULES.schema_info_exp
. exporting foreign function library names for user CCM_PRG
. exporting PUBLIC type synonyms

2. This behavior only occurs with traditional export only. Exporting the same schema with DataPump works fine without any errors.

3. This schema that reports errors contains ruleset.

4. After setting the event 10046 before running the export, the trace shows the following:

PARSING IN CURSOR #18 len=102 dep=1 uid=0 oct=1 lid=0 tim=599722934468 hv=2256083186 ad='f196210'
create table "CCM_PRG".re$action_imp_tab(owner varchar2(30), name varchar2(30), action sys.re$nv_node)
END OF STMT
PARSE #18:c=10000,e=2995,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=1,tim=599722934435
...
ERROR #18:err=1647 tim=61411631
EXEC #13:c=110000,e=106843,p=0,cr=121,cu=18,mis=0,r=0,dep=0,og=1,tim=599722970998
ERROR #13:err=1647 tim=61411632

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms