Collections:
Error: Imported Table Already Exists in Oracle
What Happens If the Imported Table Already Exists in Oracle?
✍: FYIcenter.com
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
2016-10-15, 4518👍, 0💬
Popular Posts:
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...