oracle 学习笔记 删除example表空间

发布时间:2020-03-30 22:13:13 作者:鹏爱
来源:网络 阅读:1312

SQL> drop tablespace EXAMPLE  including  contents and datafiles;

drop tablespace EXAMPLE  including  contents and datafiles

*

ERROR at line 1:

ORA-29857: domain indexes and/or secondary objects exist in the tablespace

---提示:ORA-29857:表空间存在域索引和/次级对象


SQL> col owner format a15;
SQL> col segment_name format a30;
SQL> col segment_type format a20;
SQL> set pagesize 300;
SQL> select distinct owner,segment_name,segment_type from dba_extents where tablespace_name='EXAMPLE';

OWNER SEGMENT_NAME SEGMENT_TYPE
--------------- ------------------------------ --------------------
HR DEPARTMENTS TABLE
OE ORDERS TABLE
OE PROMOTIONS TABLE
PM ONLINE_MEDIA TABLE
……
PM SYS_LOB0000051988C00006$$ LOBSEGMENT
SH SYS_LOB0000052332C00002$$ LOBSEGMENT

175 rows selected.


SQL> col owner format a15;
SQL> col segment_name format a30;
SQL> col segment_type format a20;
SQL> select distinct owner,segment_name,segment_type from dba_segments where tablespace_name='EXAMPLE';

OWNER SEGMENT_NAME SEGMENT_TYPE
--------------- ---------------------------------------- --------------------
SH PRODUCTS_PROD_CAT_IX INDEX
SH CUSTOMERS TABLE
HR DEPARTMENTS TABLE
HR DEPT_LOCATION_IX INDEX
HR JHIST_JOB_IX INDEX
HR JHIST_EMPLOYEE_IX INDEX
HR JHIST_DEPARTMENT_IX INDEX
OE SYS_LOB0000051924C00023$$ LOBSEGMENT
OE ORDERS TABLE
……
SH SYS_IL0000052332C00002$$ LOBINDEX
SH SYS_LOB0000052332C00002$$ LOBSEGMENT

已选择175行。


SQL> drop user SH cascade;
User dropped.

SQL> drop user PM cascade;
User dropped.

SQL> drop user OE cascade;
User dropped.

SQL> drop user IX cascade;
User dropped.

SQL> drop user HR cascade;
User dropped.

SQL> drop tablespace example including contents and datafiles;
Tablespace dropped.


推荐阅读:
  1. oracle学习笔记
  2. 学习oracle

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

oracle 学习笔记 删除

上一篇:Java常用消息队列原理介绍及性能对比

下一篇:asp.net在动态网页中的使用技巧

相关阅读

您好,登录后才能下订单哦!

密码登录
登录注册
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》