2023年5月20日
【SQL】Check the tablesapce usage in PDB and CDB
摘要： check out the tbs's usage in PDB and CDB , run in CDB set line 200 pages 999 column name for a10 column tablespace_name for a15 column "MAXSIZE (GB)" 阅读全文
posted @ 2023-05-20 13:59 DBAGPT 阅读(18) 评论(0) 推荐(0)
Oracle DBA must aware the useful website
摘要： https://oracledbwr.com/category/scripts/ https://kancloud.cn/zatko/oracle/22898878 https://orahow.com/tablespace-utilization-in-oracle/ www.oracle-bas 阅读全文
posted @ 2023-05-20 13:54 DBAGPT 阅读(34) 评论(0) 推荐(0)
【PLSQL】Oracle migrate the users into another DB instance
摘要： -- ###############OnSource################### -- WX:DBAJOE399 create or replace procedure pr_user_ddl as cursor get_username is select username from d 阅读全文
posted @ 2023-05-20 13:45 DBAGPT 阅读(23) 评论(0) 推荐(0)