oracle segment_name能删除吗,oracle 学习笔记 删除example表空间

SQL> drop tablespace example including contents;

drop tablespace example including contents

*

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;

Tablespace dropped.

SQL>

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值