Oracle - Error: Imported Table Already Exists in Oracle

Error: Imported Table Already Exists in Oracle

Q

What Happens If the Imported Table Already Exists in Oracle?

✍: FYIcenter.com

A

If the import process tries to import a table that already exists, the Data Pump Import utility will return an error and skip this table. The following exercise shows you a good example:

>cd \oraclexe\app\oracle\product\10.2.0\server\BIN
>impdp hr/fyicenter TABLES=employees 
  DIRECTORY=hr_dump DUMPFILE=tables.dmp LOGFILE=tables.log

Master table "HR"."SYS_IMPORT_TABLE_01" loaded/unloaded
Starting "HR"."SYS_IMPORT_TABLE_01":  hr/** TABLES=employees
  DIRECTORY=hr_dump DUMPFILE=tables.dmp LOGFILE=tables.log
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39151: Table "HR"."EMPLOYEES" exists. All dependent
  metadata and data will be skipped due to table_exists_action
  of skip
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
......

⇒Loading and Exporting Data in Oracle

⇒⇒Oracle Database Tutorials

2016-10-15, 2273👍, 0💬

Import One Table back from a Dump File in Oracle
How To Import One Table Back from a Dump File in Oracle? If you only want to import one table back to the database, you can use a dump file that was created by full export, schema export or a table export. The following tutorial exercise shows you how to import the "fyi_links" table from a dump file... 2016-10-15, 1390👍, 0💬

Export Your Own Schema in Oracle
How To Export Your Own Schema in Oracle? If you have a non-system user account and you want to export all data objects in the schema associated with your account, you can use the "expdp" command with the SCHEMAS parameter. Running "expdp" command with a non-system user account requires a directory o... 2016-10-15, 1011👍, 0💬

Original Export/Import Utilities in Oracle
What Are the Original Export and Import Utilities in Oracle? Oracle original Export and Import utilities are standalone programs that provide you a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configuratio... 2016-10-15, 861👍, 0💬

Export Several Tables Together in Oracle
How To Export Several Tables Together in Oracle? If you don't want to export the entire schema and only want to export several tables only, you can use the "expdp" command with the "TABLES" parameter as shown in the following tutorial exercise: >cd \oraclexe\app\oracle\product\1 0.2.0\server\B... 2016-10-15, 854👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.