Error while exporting

[gopu_g]

Hi Pavb,

THE ISSUE IS FIXED

ERROR

------

EXP-00008: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'SNASLOG_DATA'
ORA-06512: at "SYS.DBMS_RULE_EXP_RL_INTERNAL", line 328
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 cluster definitions

EXP-00008: ORACLE error 1950 encountered
ORA-01950: no privileges on tablespace 'SNASRPT_DATA'
ORA-06512: at "SYS.DBMS_RULE_EXP_RL_INTERNAL", line 328
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 cluster definitions



CAUSE
-----

Trace the export by setting this.

SQL> ALTER SYSTEM SET EVENTS '1950 TRACE NAME ERRORSTACK LEVEL 4';



The generated trace file showed:

ORA-01950: no privileges on tablespace 'SNASLOG_DATA'
Current SQL statement for this session:

create table "SNASLOGAPP".re$action_imp_tab(owner varchar2(30), name varchar2(30), action sys.re$nv_node)
----- PL/SQL Call Stack -----
object line object
handle number name
0x72b37bd8 328 package body SYS.DBMS_RULE_EXP_RL_INTERNAL
0x89d77c00 147 package body SYS.DBMS_RULE_EXP_RULES
0x99d00e18 1 anonymous block

ORA-01950: no privileges on tablespace 'SNASRPT_DATA'
Current SQL statement for this session:
create table "SNASRPTAPP".re$action_imp_tab(owner varchar2(30), name varchar2(30), action sys.re$nv_node)
----- PL/SQL Call Stack -----
object line object
handle number name
0x72b37bd8 328 package body SYS.DBMS_RULE_EXP_RL_INTERNAL
0x89d77c00 147 package body SYS.DBMS_RULE_EXP_RULES

SOLUTION
--------

alter user SNASLOGAPP quota unlimited on SNASLOG_DATA;
alter user SNASRPTAPP quota unlimited on SNASRPT_DATA;

And started the export.

. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting user history table
. exporting default and system auditing options
. exporting statistics
Export terminated successfully without warnings.