Saturday, January 7, 2017

ORA-01950: no privileges on tablespace 'SYSAUX'

While taking a 12c database FULL export as sysdba and I got the below error

LINUX01:testdb:/opt/oracle/CB $ expdp directory=EMP_DIR dumpfile=testdb_FULL_dec14.dmp logfile-exp_testdb_FULL_dec14.log full=y exclude=statistics metrics=y

Export: Release 12.1.0.2.0 - Production on Wed Dec 14 15:14:16 2016

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting "SYS"."SYS_EXPORT_FULL_01":  /******** AS SYSDBA directory=EMP_DIR dumpfile=testdb_FULL_dec14.dmp logfile=exp_testdb_FULL_dec14.log full=y exclude=statistics metrics=y
Startup took 4 seconds
Estimate in progress using BLOCKS method...
>>> ORA-31642: the following SQL statement fails:
BEGIN "SYS"."DBMS_RULE_EXP_RULES".SCHEMA_CALLOUT(:1,0,1,'12.01.00.00.00'); END;
ORA-01950: no privileges on tablespace 'SYSAUX'
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA


Solution:

To fix this issue just grant below privilege to the SYSMAN user

LINUX01:: testdb:/export/testdb $ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Dec 15 14:54:30 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> alter user SYSMAN quota unlimited on sysaux;
User altered.

Rerunning export job again resolved the issue and it is SUCCESS!!!


Refer:

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


0 comments:

Post a Comment

Auto Scroll Stop Scroll