468,135 Members | 1,394 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,135 developers. It's quick & easy.

drop tablespace

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
1 6863
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.

Similar topics

2 posts views Thread by Darshak Shah | last post: by
1 post views Thread by Ian Dobson | last post: by
2 posts views Thread by robert | last post: by
6 posts views Thread by robert | last post: by
2 posts views Thread by vj_dba | last post: by
1 post views Thread by gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.