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
......

⇒ Import One Table back from a Dump File in Oracle

⇐ Export Several Tables Together in Oracle

⇑ Loading and Exporting Data in Oracle

⇑⇑ Oracle Database Tutorials

2016-10-15, 5840🔥, 0💬

Where Is the Export Dump File Located in Oracle
Where Is the Export Dump File Located in Oracle? If you are not specifying the dump directory and file name, the dump file will be stored in the default dump directory with the default file name. The tutorial exercise below tells you find what is your default dump directory and locate the dump file.... 2016-10-15, 4238🔥, 0💬

What Is Open Database Communication (ODBC) in Oracle
What Is Open Database Communication (ODBC) in Oracle? ODBC, Open Database Communication, a standard API (application program interface) developed by Microsoft for Windows applications to communicate with database management systems. Oracle offers ODBC drivers to allow Windows applications to connect... 2016-10-15, 3568🔥, 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, 3153🔥, 0💬

Disk Space Needed for an Export Job in Oracle
How To Estimate Disk Space Needed for an Export Job in Oracle? If you just want to know how much disk space for the dump without actually exporting any data, you can use the ESTIMATE_ONLY=y parameter on the expdp command. The following tutorial exercise shows you how a system user wants to see the d... 2016-10-15, 2788🔥, 0💬

Perform a Full Database Export in Oracle
How To Do a Full Database Export in Oracle? If you are ready to do a full database export, you can use the FULL=y parameter on the expdp command, as shown in the following tutorial exercise: >expdp SYSTEM/fyicenter FULL=y ESTIMATE_ONLY=y Starting "SYSTEM"."SYS_EXPORT_FULL_01": SYSTEM/**** FUL... 2016-10-15, 2754🔥, 0💬

ODBC Drivers and DSN Configuration for Oracle
Where to find answers to frequently asked questions on ODBC Drivers, DSN Configuration and ASP Connection for Oracle? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team ODBC Drivers, DSN Configuration and ASP Connection for Oracle. Clear answers are pro... 2016-10-15, 2409🔥, 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, 2402🔥, 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, 2328🔥, 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, 2294🔥, 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.