By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,004 Members | 1,296 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,004 IT Pros & Developers. It's quick & easy.

drop tablespace

P: n/a
Hi,
I need to drop a tablespace, I am unable to drop because it says the
containers it uses is inaccessible, because a process deleted the
container. the tablespace went into pending state. I just want to drop
the table in it and the tablespace. i dont need that. but i need the
name of the table it is using. i creted another table in another
tablespace, i will rename that once i can drop this table.&
tablespace.

Can anyone help me on this.

Thank you.
Dec 3 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Ian
bu*******@gmail.com wrote:
Hi,
I need to drop a tablespace, I am unable to drop because it says the
containers it uses is inaccessible, because a process deleted the
container. the tablespace went into pending state. I just want to drop
the table in it and the tablespace. i dont need that. but i need the
name of the table it is using. i creted another table in another
tablespace, i will rename that once i can drop this table.&
tablespace.
See the 'restart database' command, with the 'drop pending tablespaces'
option:

http://publib.boulder.ibm.com/infoce...c/r0001974.htm
Dec 3 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.