-
Error while exporting
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
-
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.
-
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
-
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.
-
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.
-
Time to open a TAR with Oracle.
-
Yeah PAVB, going to raise SR. Once it is solved i will let u know.
thanks for all the support
-
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.
-
Glad you got it fix.
Solution looks pretty much like the one I suggested on Nov 10th, isn't it?
-
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.