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
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