:-) Question meant for developers ..
Yes we can do it but table should not have any active transactions also we need to think about integrity constraints
using dbms_redefinition we can change structure of table eg. heap to cluster or hash table etc.
but dbms_redefinition doesn't work certain kind of table eg. SPATIAL table.
Spatial table?
:-)
ReplyDeleteQuestion meant for developers ..
Yes we can do it but table should not have any active transactions also we need to think about integrity constraints
ReplyDeleteusing dbms_redefinition we can change structure of table eg. heap to cluster or hash table etc.
ReplyDeletebut dbms_redefinition doesn't work certain kind of table eg. SPATIAL table.
ReplyDeleteSpatial table?
ReplyDelete