删除Repository里OBJECT和PACKAGE
原创
©著作权归作者所有:来自51CTO博客作者wx638ee25dac6f7的原创作品,请联系作者获取转载授权,否则将追究法律责任
当发现REPOSITORY里面的OBJECT无法删除时,可以尝试去IDE里面去删除,
如果IDE里面也不好用了,那么以下命令可以彻底删除,不过要慎用,万一一个PACKAGE NAME输错了,那就悲剧了!
delete from "_SYS_REPO"."ACTIVE_CONTENT_TEXT" where package_id = '<package_name>'
;
delete from "_SYS_REPO"."ACTIVE_CONTENT_TEXT_CONTENT" where package_id = '<package_name>'
;
delete from "_SYS_REPO"."ACTIVE_OBJECT" where package_id = '<package_name>'
;
delete from "_SYS_REPO"."ACTIVE_OBJECT_TEXT" where package_id = '<package_name>'
;
delete from "_SYS_REPO"."ACTIVE_OBJECT_TEXT_CONTENT" where package_id = '<package_name>'
;
delete from "_SYS_REPO"."ACTIVE_TAGS" where package_id = '<package_name>'
;
delete from "_SYS_REPO"."CHANGE_ENTRIES" where package_id = '<package_name>'
;
delete from "_SYS_REPO"."CONTENT_TEXT_HISTORY" where package_id = '<package_name>'
;
delete from "_SYS_REPO"."OBJECT_HISTORY" where package_id = '<package_name>'
;
delete from "_SYS_REPO"."HISTORICAL_OBJECTCROSSREF" where from_package_id = '<package_name>'
;
delete from "_SYS_REPO"."ACTIVE_OBJECTCROSSREF" where TO_package_id = '<package_name>'
;
delete from "_SYS_REPO"."ACTIVATION_HELPER2" where package_id = '<package_name>'
;
delete from "_SYS_REPO"."INACTIVE_CONTENT_TEXT" where package_id = '<package_name>'
;
delete from "_SYS_REPO"."INACTIVE_CONTENT_TEXT_CONTENT" where package_id = '<package_name>'
;
delete from "_SYS_REPO"."INACTIVE_OBJECT" where package_id = '<package_name>'
;
delete from "_SYS_REPO"."INACTIVE_OBJECT_TEXT" where package_id = '<package_name>'
;
delete from "_SYS_REPO"."INACTIVE_OBJECT_TEXT_CONTENT" where package_id = '<package_name>'
;
delete from "_SYS_REPO"."INACTIVE_OBJECTCROSSREF" where TO_package_id = '<package_name>'
;
以上不能还无法清理PACKAGE,要删除PACKAGE可以先到EXPLORER里面删除PACKAGE,然后到WORK SPACE去提交,再然后去SYSTEM里找到对应CONTENT下面去删掉。