-
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
Last edited by gopu_g; 11-10-2009 at 11:44 AM.
Thanks/Gopu
-
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.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
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
Last edited by gopu_g; 11-10-2009 at 01:40 PM.
Thanks/Gopu
-
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.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
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.
Thanks/Gopu
-
Time to open a TAR with Oracle.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Yeah PAVB, going to raise SR. Once it is solved i will let u know.
thanks for all the support
Thanks/Gopu
-
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.
Last edited by gopu_g; 11-30-2009 at 04:13 PM.
Thanks/Gopu
-
Glad you got it fix.
Solution looks pretty much like the one I suggested on Nov 10th, isn't it?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
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.
Thanks/Gopu
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|