oracle9i 包编译卡主,在10g下没有问题,也不能删除
急!!!! 高分求救包主体有8000多行。

解决方案 »

  1.   

    会锁住这些系统表:
    3 XSTZJK TABLE LOCK 7 SYS IDL_SB4$ TABLE 15 7 ORA9ISTD WORKGROUP\ORA9ISTD plsqldev.exe ORA9ISTD\Administrator
    4 XSTZJK TABLE LOCK 7 SYS ERROR$ TABLE 15 7 ORA9ISTD WORKGROUP\ORA9ISTD plsqldev.exe ORA9ISTD\Administrator
    5 XSTZJK TABLE LOCK 7 SYS SOURCE$ TABLE 15 7 ORA9ISTD WORKGROUP\ORA9ISTD plsqldev.exe ORA9ISTD\Administrator
    6 XSTZJK TABLE LOCK 7 SYS IDL_UB1$ TABLE 15 7 ORA9ISTD WORKGROUP\ORA9ISTD plsqldev.exe ORA9ISTD\Administrator
    7 XSTZJK TABLE LOCK 7 SYS IDL_CHAR$ TABLE 15 7 ORA9ISTD WORKGROUP\ORA9ISTD plsqldev.exe ORA9ISTD\Administrator
    8 XSTZJK TABLE LOCK 7 SYS IDL_UB2$ TABLE 15 7 ORA9ISTD WORKGROUP\ORA9ISTD plsqldev.exe ORA9ISTD\Administrator
    9 XSTZJK TABLE LOCK 7 SYS PROCEDUREINFO$ TABLE 15 7 ORA9ISTD WORKGROUP\ORA9ISTD plsqldev.exe ORA9ISTD\Administrator
    10 XSTZJK TABLE LOCK 7 SYS ARGUMENT$ TABLE 15 7 ORA9ISTD WORKGROUP\ORA9ISTD plsqldev.exe ORA9ISTD\Administrator
    11 XSTZJK TABLE LOCK 7 SYS PROCEDUREC$ TABLE 15 7 ORA9ISTD WORKGROUP\ORA9ISTD plsqldev.exe ORA9ISTD\Administrator
    12 XSTZJK TABLE LOCK 7 SYS PROCEDUREJAVA$ TABLE 15 7 ORA9ISTD WORKGROUP\ORA9ISTD plsqldev.exe ORA9ISTD\Administrator
    13 XSTZJK TABLE LOCK 7 SYS VTABLE$ TABLE 15 7 ORA9ISTD WORKGROUP\ORA9ISTD plsqldev.exe ORA9ISTD\Administrator