Home » RDBMS Server » Server Administration » unable to drop a tablespace
unable to drop a tablespace [message #54172] Fri, 01 November 2002 09:15 Go to next message
Joe
Messages: 138
Registered: November 1999
Senior Member
I have a tablespace (test_data) that I would like to drop.

I issue the command:

sqlplus> drop tablespace test_data including contents;

and receive: ORA-14404: partitioned table contains partitions in a different tablespace

I am attempting to find out the name of the partitions in this particular tablespace so that I may drop them, drop the tablespace, then recreate the tablespace along with the partitions.

Thank you.

Report message to a moderator

Re: unable to drop a tablespace [message #54176 is a reply to message #54172] Fri, 01 November 2002 10:19 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
You have to find the name of the rest of the partitions belonging to this table, in which tablespace they reside.

To do that, you have to query DBA_TAB_SUBPARTITIONS view.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: Rebuilding SYS Objects - Safe?
Next Topic: 90131: Jobs falling off the Job Queue.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 17:04:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.