Tech Talk

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

thanks
Manu

Trace the export and see wht the output.


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

manudba wrote: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

Here is your solution.

alter user SNASLOGAPP quota unlimited on SNASLOG_DATA;

SNASLOGAPP does not have privs on the tablespace SNASLOG_DATA.

Now start the export and check it.

Thanks Gopu it worked, thanks for your help

manudba wrote:Thanks Gopu it worked, thanks for your help

Ur welcome

Hi gopu..

you started answering for user's queries.. Great man.. u will rock..