Gents,
Scenario is: I want to migrate enterprise edition database 12c (2 node rac) to a standard edition 2 database 12c (standalone server).
1- I have installed Oracle 12c SE2 on a standalone server and create a blank database
2- I want to export enterprise database from SE2 server using expdp utility (because It is recommended to export EE database using SE utility)
3- But when I run the command I am getting the following message:
C:\Windows\system32>expdp full=y directory=data_pump_dir dumpfile=prod.dmp logfi
le=data_pump_dir:prod_full.log exclude=SCHEMA:"IN ('DBSNMP','SYSMAN','OLAPSYS')"
flashback_time=systimestamp
Export: Release 12.1.0.2.0 - Production on Thu Aug 18 16:29:53 2016
Copyright (c) 1982, 2015, Oracle and/or its affiliates. All rights reserved.
Username: system@enterprise_edition
Password:
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit
Production
With the Partitioning, Real Application Clusters, Automatic Storage Management,
OLAP,
Advanced Analytics and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
4- Following directory exist and has read, write access to system user:
SQL> SELECT directory_name, directory_path FROM dba_directories
2 WHERE directory_name='DATA_PUMP_DIR';
DIRECTORY_NAME
------------------------------------------------------------------------
DIRECTORY_PATH
------------------------------------------------------------------------
DATA_PUMP_DIR
d:\backup\exp
SQL>
Any idea what I am missing here or how can I fix this error.
Regards,