2023年5月30日
【Oracle】Clean all objects belong to particular the user but not using drop user xxx cascade
摘要： # -- WX:DBAJOE399 -- DEST_SCHEMA=Expected_user_name sqlplus / as sysdba << !EOF set serveroutput on set echo off set feedback off WHENEVER SQLERROR EX 阅读全文
posted @ 2023-05-30 18:21 DBAGPT 阅读(7) 评论(0) 推荐(0) 编辑
【Oracle】Check size of datafiles and tempfile tablespaces used in CDB and PDB
摘要： -- WX:DBAJOE399 --set line 200 pages 999 column name for a10 column tablespace_name for a15 column "MAXSIZE (GB)" format 9,999,990.00 column "ALLOC (G 阅读全文
posted @ 2023-05-30 17:58 DBAGPT 阅读(8) 评论(0) 推荐(0) 编辑