Help!!! Tablespace in backup pending state after delete hi there!
While trying to issue a command to delete several rows from a table
and due to the big amount of registers I have obtained an error (I
suppose that the DB tries to save rollback info and it has no space).
After that I am having the following error while trying to
delete/update/insert in a table:
During SQL processing it returned:
SQL0290N Table space access is not allowed. SQLSTATE=55039
after type command "list tablespaces" I can see that the tablespace
that table belongs to is in "backup pending state".
I have tried to restore the tablespace to its normal state using the
command:
"QUIESCE TABLESPACES FOR TABLE...."
with no success and right now I have no idea of what to do...
Can anyone help me???
Thanks a lot
Tomas |