资讯

精准传达 • 有效沟通

从品牌网站建设到网络营销策划,从策略到执行的一站式服务

oracle学习笔记删除example表空间

SQL> drop tablespace EXAMPLE  including  contents and datafiles;

创新互联-专业网站定制、快速模板网站建设、高性价比邵东网站开发、企业建站全套包干低至880元,成熟完善的模板库,直接使用。一站式邵东网站制作公司更省心,省钱,快速模板网站建设找我们,业务覆盖邵东地区。费用合理售后完善,10年实体公司更值得信赖。

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.


分享文章:oracle学习笔记删除example表空间
文章网址:http://www.cdkjz.cn/article/giiise.html
多年建站经验

多一份参考,总有益处

联系快上网,免费获得专属《策划方案》及报价

咨询相关问题或预约面谈,可以通过以下方式与我们联系

大客户专线   成都:13518219792   座机:028-86922220