drop tablespace

[bujjus173]

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.

[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