Import: Release 10.2.0.4.0 - 64bit Production on Monday, 06 December, 2010 17:57:27 Copyright (c) 2003, 2007, Oracle. All rights reserved. ;;; Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Real Application Testing options Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded Starting "SYSTEM"."SYS_IMPORT_FULL_01": parfile=hm_camp_m010.par Processing object type TABLE_EXPORT/TABLE/TABLE ORA-39083: Object type TABLE failed to create with error: ORA-00959: tablespace '_$deleted$16$0' does not exist
Basically, bombed because the tablespace _$deleted$16$0 doesn't exist. Looked it up on MetaLink and found this document:
Import Partition Table Fails With Ora-00959: Tablespace '_$Deleted$0$0' [ID 798142.1]
There is an open unpublished bug where basic problem is that a tablespace is renamed to one that used to exist on the database. Here are the steps that will cause this problem.
create tablespace aa
create tablespace bb
drop tablespace aa
rename bb to aa
Then why it occurs is because when a tablespace is dropped, its ts$ entry is set to an invalid state, but it is not deleted. When a rename is done, if the target name already has a ts$ entry, then during the rename, because we cannot have two ts$ entries with the same name, the _$deleted$ construct is introduced. The change is not taken care of properly, and is flushed to other dictionary tables causing this problem.The note didn't have good instructions to fix my issue. So, I'm recording what I did here:
- Run impdp with this parameter SQLFILE=dir:name to pull the DDL for the object.
- Modify and execute the SQL created in step 1.
- Run impdp with this parameter CONTENT=DATA_ONLY to bypass the Metadata portion of impdp steps.
In step 2 you take the create table SQL and modify it by creating the table in a tablespace that does exist.
Hopefully, this will help you.
1 comment:
I was stuck with this and not matter what table exist action i was choosing, table creation steps were being performed, so after putting content=data, it worked , i already truncated my table and changed the tablespace attribute from deleted one to existing one.
thank you.
Post a Comment