摘要:
#### 查看某个用户下所有类型为视图的表名 ```select * from dba_tab_comments where owner='名字' and table_type='VIEW';``` #### 开启某用户下所有表的全列 ``` select 'alter table ' || OWN 阅读全文
posted @ 2023-08-01 14:36
by1314
阅读(180)
评论(0)
推荐(0)
摘要:
#### 查看rman备份计划 ``` select * from dba_scheduler_jobs; desc DBA_SCHEDULER_JOB_RUN_DETAILS SELECT a.job_name, start_date, end_date, status FROM DBA_SCHE 阅读全文
posted @ 2023-08-01 14:29
by1314
阅读(492)
评论(0)
推荐(0)