My Oracle Support Banner

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

Last updated on SEPTEMBER 20, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.3 [Release 10.1 to 10.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
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 '<tablespace name>' 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 "<table name>".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

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
Symptoms
Cause
Solution

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