オブジェクトを有効化(無効化)する

Pocket

/*
|| ■オブジェクトを有効化(無効化)する
|| ALTER オブジェクト・タイプ object_name ENABLE(DISABLE);
*/
–有効化
ALTER DATABASE LINK dblink_name ENABLE;
ALTER FUNCTION function_name ENABLE;
ALTER JOB job_name ENABLE;
ALTER PROCEDURE procedure_name ENABLE;
ALTER SEQUENCE sequence_name ENABLE;
ALTER SYNONYM synonym_name ENABLE;
ALTER VIEW view_name ENABLE;
–無効化
ALTER DATABASE LINK dblink_name DISABLE
ALTER FUNCTION function_name DISABLE
ALTER JOB job_name DISABLE
ALTER PROCEDURE procedure_name DISABLE
ALTER SEQUENCE sequence_name DISABLE
ALTER SYNONYM synonym_name DISABLE
ALTER VIEW view_name DISABLE

以上です (^^♪