Tuesday, 12 March 2019

How to export between releases of oracle

Below script to export from 12c and import that dump into 11g to use version parameter -


expdp user/password@db directory=<directory_name> dumpfile=<dumpfile_name>.dmp logfile=<logfile_name>.log tables=<table_name> job_name=<job_name> version=11.2

Prerequisite Check “CheckActiveFilesAndExecutables” Failed

While applying a patch to oracle binary using opatch utility, got below error. Error -  $ORACLE_HOME/OPatch/opatch apply Oracle Interim Patc...