-
Drop Partition Problems
I have a problem dropping a partition. The partition is on a bad tablespace. The tablespace is missing a file. I just want to drop the tablespace (it has not data). I have to drop the partition first but it telling me I can't because I have a bad tablespace.
-
offline drop the datafile then delete the tablespace including contents and datafiles
-
Still Have Error
SqlPlus>drop tablespace wtd_ts41 including contents and datafiles;
drop tablespace wtd_ts41 including contents and datafiles
*
ERROR at line 1:
ORA-14404: partitioned table contains partitions in a different tablespace
-
Move Partition
Is there a way to force a move partition?
I am getting an error trying to move the partition to another tablespace.
Once I do that I probably would be able to drop the tablespace.
-
Exchange Partition
I was able to solve my problem with Exchange Partition.
I created a temp table with the data I needed in a new tablespace.
Ran and exchange partition
Dropped the temp table
Dropped the bad tablespace
-
Was recovery not an option?
Good solution though.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|