摘要:
#生产库数据库登陆异常,通过排查发现归档无法删除,使用rman调用删除脚本如下报错: RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process archived log 阅读全文
摘要:
set lines 200 set pages 200 col object_name for a30 select a.obj#,b.object_name, a.analyzetime, to_char(a.savtime, 'yyyy-mm-dd hh24:mi:ss'), to_number 阅读全文
摘要:
accept owner prompt " Enter the schema name to check for Row Chaining (RETURN for All): " prompt prompt accept table prompt " Enter the table name to 阅读全文
摘要:
column owner format a6 column segment_type format a10 column segment_name format a15 column partition_name format a15 column TABLESPACE_NAME for a15 s 阅读全文