Oracle解锁表、包、用户、杀会话、停job
一、创建包tzq_server_pkg
sys用户以sysdba身份登录Oracle数据库,创建包 tzq_server_pkg ,上代码:
CREATE OR REPLACE PACKAGE sys.tzq_server_pkg IS
PROCEDURE unlock_table(table_owner IN VARCHAR2, table_name IN VARCHAR2);
sys用户以sysdba身份登录Oracle数据库,创建包 tzq_server_pkg ,上代码:
CREATE OR REPLACE PACKAGE sys.tzq_server_pkg IS
PROCEDURE unlock_table(table_owner IN VARCHAR2, table_name IN VARCHAR2);