You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
bigstinky86
changed the title
Doesn't extract ddl from dmp in case of not all schemas is chosen for import
Doesn't extract ddl from dmp in case of not all schemas are chosen for import
Mar 15, 2019
When not all schemas are chosen for import it generates the command below:
export ORACLE_HOME=/jv01/app/oracle/product/11.2.0/dbhome_1;export ORACLE_SID=SOMENAME; /jv01/app/oracle/product/11.2.0/dbhome_1/bin/impdp TO_AGENT/'TO_AGENT' DUMPFILE=from_agent_01-01-2011.dmp schemas=FROM_AGENT remap_schema=null:TO_PUB,null:TO_CORE,null:TO_CATA,null:TO_CATB,FROM_AGENT:TO_AGENT remap_tablespace=USERS:USERS DIRECTORY=DB_DUMPS_DIR logfile=import_data_TO_AGENT.log skip_unusable_indexes=YES content=DATA_ONLY
Code which generates the command (from build.xml):
The command fails with error below and schema structure doesn't create;
Tried to specify other schemas as null but got the same outcome.
Due to the
<param name="fail_on_error" value="false"/>
The macros generateSQLscript doesn't fail so job continue and fails on dmp import step with an error
The text was updated successfully, but these errors were encountered: