Video for Restoring Accidentally Dropped Table space.See Database Rebuild with only subset of table spaces in Action.
Hi Guy Przytula,
After a quick reading from Info center...
If you have dependencies then it will not allow to drop table spaces. Say A table having Data and Index in separate table spaces, then you have to drop both the table spaces together.
I am just creating simple examples. Please consider that.
I was able to drop a table space and it had a table defined in the table space. If you look past 5 min of video, i have demonstrated the scenario with examples. Please have a look and let me know.
I had in mind (and already seen) that drop tablespace is not possible if any object exists in tablespace
dropping an empty tablespace is no problem - just re-create
dropping a table : if dropped table recovery is activated : nop
best regards, Guy Przytula
Sign Upor Sign In
Or sign in with:
© 2019 Created by channeldb2.
Report an Issue |
Terms of Service
Please check your browser settings or contact your system administrator.