JZTXT
  • 首页
  • Ai
  • Java
  • Python
  • Android
  • Mysql
  • JavaScript
  • Html
  • CSS

【Oracle】Clean all objects belong to particular the user but not using drop user xxx cascade

发布时间 2023-05-30 18:29:05作者: DBAGPT

 

 

# -- WX:DBAJOE399 --

DEST_SCHEMA=Expected_user_name

sqlplus / as sysdba << !EOF

set serveroutput on
set echo off
set feedback off
WHENEVER SQLERROR EXIT 1
WHENEVER OSEEROR EXIT 1
alter session set current_schema=${DEST_SCHEMA};




purge dba_recyclebin;
  EXIT
!EOF

  

    本栏目推荐文章
  • Center-based 3D Object Detection and Tracking
  • oracle清除日志
  • mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION; ERROR 1410 (42000): You are not allowed to create a user with GRANT
  • Oracle用户授权篇
  • Oracle 19c 升级错误【verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table】
  • oracle varchar字段修改为clob字段(已经有数据的也可以修改)
  • Learning Dynamic Query Combinations for Transformer-based Object** Detection and Segmentation论文阅读笔记
  • OOP语义学 第一章 关于对象(Object Lessons)
  • Oracle 21c-创建数据库
  • Oracle查询多种数据结构并计算合计值
版权声明:本网站为非赢利性站点,本网站所有内容均来源于互联网相关站点自动搜索采集信息,相关链接已经注明来源。
联系我们