Error while exporting

[gopu_g]

Hi All,

i am getting the below error while exporting full database.kindly suggest a solution.

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

[PAVB]

It looks to me the user running export either has no privileges on tablespace SNASLOG_DATA or tablespace SNASLOG_DATA is full or user's quota in such tablespace got exausted. I would go with first one.

Remember, export do creates a table on default tablespace.

[gopu_g]

Pavb,

Thanks for your answer.
we have enough space in the tablespace, i have given the grants and restarted the the export. Then also it is throwing the same error.

TABLESPACE_NAME Tot size MB Tot Free MB %FREE %USED
------------------------- ----------- ----------- ---------- ----------
SNASLOG_DATA 16384 9671 59 41

[PAVB]

Try this ...

alter user USER_RUNNING_EXP quota unlimited on SNASLOG_DATA;

where: USER_RUNNING_EXP is the account running exp

... then try export again.

[gopu_g]

The export is running from the "system" user. I have granted like you said before and after.Then also i can see the error in the export log.

[PAVB]

Time to open a TAR with Oracle.

[gopu_g]

Yeah PAVB, going to raise SR. Once it is solved i will let u know.
thanks for all the support

[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.

[PAVB]

Glad you got it fix.
Solution looks pretty much like the one I suggested on Nov 10th, isn't it?

[gopu_g]

yes.. but, the mistake we did is we have granted the privs to the system user.
When i traced the export then only came to know that for which user the privs are missing.
Thanks for your help MAN.