CREATE SEQUENCE job_seq CACHE 30;CREATE OR REPLACE TRIGGER tri_grant2developers AFTER ddl ON DATABASEDECLARE v_jobname VARCHAR2(200) := 'DDL_JOB'||job_seq.NEXTVAL; v_sql VARCHAR2(2000);BEGIN IF (upper(ora_dict_obj_owner) IN &n...【阅读全文】
V$RMAN_BACKUP_JOB_DETAILS展示了rman备份的相关细节。比如,rman备份持续时间、rman备份的执行次数、每一次rman备份工作的状态(failed or completed and so on),每次rman备份的起始时间等等。SQL> desc sys.v$rman_backup_job_details Name ...【阅读全文】
Oracle Database 12c supports proxy authentication to the Oracle database. Proxy authentication is supported over thin and thick JDBC connections and on the command line. Users can authenticate to the database using their own credentials and then proxy to another user in the database. Proxy aut...【阅读全文】