SQL> create user abce identified by abce; User created. SQL> grant resource,connect to abce; Grant succeeded. SQL> conn abce/abce
Connected.
SQL> purge dba_recyclebin;
purge dba_recyclebin
*
ERROR at line :
ORA-: insufficient privileges SQL> conn /as sysdba
Connected.
SQL> grant purge dba_recyclebin to abce; Grant succeeded. SQL> conn abce/abce
Connected.
SQL> purge dba_recyclebin; DBA Recyclebin purged. SQL>
相关文章
- Oracle 12C ORA-65096: 公用用户名或角色名无效
- Oracle 12C ORA-65096: 公用用户名或角色名无效
- ORACLE 12c 固定表2
- Oracle 12C云数据库安装介质下载链接
- 学习笔记:Oracle 12C 数据非常规恢复工具bbed的使用说明
- Oracle 12c 创建表空间和用户并为用户授权
- oracle 12c RMAN异机恢复还原RAC集群(ASM)为单实例库(文件系统)记录
- Oracle WebLogic Server 与 Oracle Database 12c 的集成 (1)
- oracle 12C管理用户帐户和安全
- [翻译] Oracle Database 12c 新特性Multitenant