摘要:
SELECT obj# FROM obj$ AS OF TIMESTAMP TO_TIMESTAMP('2016-06-30', 'YYYY-MM-DD') WHERE NAME = 'PFWZ_APPLICATION_OPERATION'; 87842 87852 SELECT source FROM source$ AS OF TIMESTAMP TO_TIMESTAMP('2016-06... 阅读全文
摘要:
创建目录 create or replace directory exp_dir as '/tmp'; 赋权 grant read, write on directory exp_dir to PUBLIC; 测试写文件 declare fhandle utl_file.file_type; begin fhandle := utl_file.... 阅读全文
摘要:
检查状态select saddr,sid,serial#,paddr,username,status from v$session where username is not null查询用户的连接状态Select username,sid,serial# from v$session where 阅读全文