impdp
Oracle: using impdp from a full DB expdp
I’ve got a full Dump of an Database (all schema, system etc...) Now I want to import just one schema of this file, is this even possible?[详细]
2023-04-07 23:06 分类:问答Migrating Oracle Database with expdp and impdp
Does the target database need to be prepared with tablespace and/or user (schema) in order to successfully migrate a schema from one database (11g R1) to another (11g R2)?[详细]
2023-04-07 15:27 分类:问答How complete is an Oracle11g IMPDP?
I was given the task of upgrading to a new Oracle Database Server (11gR2).The former DBA gave these instructions:[详细]
2023-03-24 13:26 分类:问答Return code/ exit code for Oracle's DataPump API
I w开发者_运维知识库rapped oracle\'s IMPDP and EXPDP in a console and could not find a good place for the return codes that these two return. I want to be more specific in pointing out errors than jus[详细]
2022-12-30 05:59 分类:问答Is there a good workaround to the Oracle IMPDP REMAP_SCHEMA issue with triggers (ORA-39083, ORA-00942)?
One can use the Oracle data pump import tool (IMPDP.EXE) to import one schema into another using the REMAP_SCHEMA option. However there is an issue in that triggers are not properly remapped. This lea[详细]
2022-12-17 08:35 分类:问答How do I append data with Oracle's impdp?
Does impdp always truncate the table before it loads the data even if I don\'t recreate the m开发者_如何学Ceta data? If it does, is there an option to tell it to append the data instead?What impdp doe[详细]
2022-12-11 23:39 分类:问答