Thursday, May 31, 2018

Datapump Export Fails with ORA-1950: "no privileges on tablespace" (Doc ID 1633698.1)

In this Document
Symptoms
Cause
Solution
References


APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 17-Aug-2015***

SYMPTOMS

The datapump export log shows errors like:
ORA-31642: the following SQL statement fails:
BEGIN "SYS"."DBMS_RULE_EXP_RULES".SCHEMA_CALLOUT(:1,0,1,'11.02.00.04.00'); END;
ORA-01950: no privileges on tablespace 'SYSAUX'

CAUSE

More information about the error is found after setting event 1950 and reproducing the problem, e.g.
SQL> connect / as sysdba
SQL> alter system set events '1950 trace name ERRORSTACK level 3';

Afterward reproducing the error as the SYSTEM user, the event can be turned off again using:
SQL> alter system set events '1950  trace name ERRORSTACK off';

The generated trace file showed next create sql statement:
----- Current SQL Statement for this session (sql_id=d72dvzc8mfmpb) -----
create table "SYSMAN".re$action_imp_tab(owner varchar2(30), name varchar2(30), action sys.re$nv_node) tablespace SYSAUX

In this case, the SYSMAN user is not able to create objects in the  sysaux tablespace.

SOLUTION

Grant unlimited quota on SYSAUX tablespace to the SYSMAN user, i.e.:
SQL> alter user SYSMAN quota unlimited on  sysaux;

REFERENCES

NOTE:1531789.1 - DataPump Export (EXPDP) Fails With Errors ORA-39126 ORA-06512 ORA-1950

No comments:

Post a Comment