Below command is the way to reclaim the tablespace from SOA schemas.
alter table audit_trail deallocate unused;
alter table audit_trail enable row movement;
alter table audit_trail shrink space compact;
alter table audit_trail shrink space;
alter table audit_trail disable row movement;
alter table audit_details deallocate unused;
alter table audit_details enable row movement;
alter table audit_details shrink space compact;
alter table audit_details shrink space;
alter table audit_details disable row movement;
alter table cube_instance deallocate unused;
alter table cube_instance enable row movement;
alter table cube_instance shrink space compact;
alter table cube_instance shrink space;
alter table cube_instance disable row movement;
alter table cube_scope deallocate unused;
alter table cube_scope enable row movement;
alter table cube_scope shrink space compact;
alter table cube_scope shrink space;
alter table cube_scope disable row movement;
alter table dlv_message deallocate unused;
alter table dlv_message enable row movement;
alter table dlv_message shrink space compact;
alter table dlv_message shrink space;
alter table dlv_message disable row movement;
alter table dlv_subscription deallocate unused;
alter table dlv_subscription enable row movement;
alter table dlv_subscription shrink space compact;
alter table dlv_subscription shrink space;
alter table dlv_subscription disable row movement;
alter table document_ci_ref deallocate unused;
alter table document_ci_ref enable row movement;
alter table document_ci_ref shrink space compact;
alter table document_ci_ref shrink space;
alter table document_ci_ref disable row movement;
alter table document_dlv_msg_ref deallocate unused;
alter table document_dlv_msg_ref enable row movement;
alter table document_dlv_msg_ref shrink space compact;
alter table document_dlv_msg_ref shrink space;
alter table document_dlv_msg_ref disable row movement;
alter table headers_properties deallocate unused;
alter table headers_properties enable row movement;
alter table headers_properties shrink space compact;
alter table headers_properties shrink space;
alter table headers_properties disable row movement;
alter table work_item deallocate unused;
alter table work_item enable row movement;
alter table work_item shrink space compact;
alter table work_item shrink space;
alter table work_item disable row movement;
alter table wi_fault deallocate unused;
alter table wi_fault enable row movement;
alter table wi_fault shrink space compact;
alter table wi_fault shrink space;
alter table wi_fault disable row movement;
alter table xml_document deallocate unused;
alter table xml_document enable row movement;
alter table xml_document shrink space compact;
alter table xml_document shrink space;
alter table xml_document disable row movement;
alter table audit_trail deallocate unused;
alter table audit_trail enable row movement;
alter table audit_trail shrink space compact;
alter table audit_trail shrink space;
alter table audit_trail disable row movement;
alter table audit_details deallocate unused;
alter table audit_details enable row movement;
alter table audit_details shrink space compact;
alter table audit_details shrink space;
alter table audit_details disable row movement;
alter table cube_instance deallocate unused;
alter table cube_instance enable row movement;
alter table cube_instance shrink space compact;
alter table cube_instance shrink space;
alter table cube_instance disable row movement;
alter table cube_scope deallocate unused;
alter table cube_scope enable row movement;
alter table cube_scope shrink space compact;
alter table cube_scope shrink space;
alter table cube_scope disable row movement;
alter table dlv_message deallocate unused;
alter table dlv_message enable row movement;
alter table dlv_message shrink space compact;
alter table dlv_message shrink space;
alter table dlv_message disable row movement;
alter table dlv_subscription deallocate unused;
alter table dlv_subscription enable row movement;
alter table dlv_subscription shrink space compact;
alter table dlv_subscription shrink space;
alter table dlv_subscription disable row movement;
alter table document_ci_ref deallocate unused;
alter table document_ci_ref enable row movement;
alter table document_ci_ref shrink space compact;
alter table document_ci_ref shrink space;
alter table document_ci_ref disable row movement;
alter table document_dlv_msg_ref deallocate unused;
alter table document_dlv_msg_ref enable row movement;
alter table document_dlv_msg_ref shrink space compact;
alter table document_dlv_msg_ref shrink space;
alter table document_dlv_msg_ref disable row movement;
alter table headers_properties deallocate unused;
alter table headers_properties enable row movement;
alter table headers_properties shrink space compact;
alter table headers_properties shrink space;
alter table headers_properties disable row movement;
alter table work_item deallocate unused;
alter table work_item enable row movement;
alter table work_item shrink space compact;
alter table work_item shrink space;
alter table work_item disable row movement;
alter table wi_fault deallocate unused;
alter table wi_fault enable row movement;
alter table wi_fault shrink space compact;
alter table wi_fault shrink space;
alter table wi_fault disable row movement;
alter table xml_document deallocate unused;
alter table xml_document enable row movement;
alter table xml_document shrink space compact;
alter table xml_document shrink space;
alter table xml_document disable row movement;
hi,
ReplyDeleteIf we using database version 12c, is it the way to reclaim space is same?
Thanks