Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

table with LOBs contains segments in different tablespaces

JhilJul 29 2014 — edited Jul 29 2014

Hi all ;

i cannot drop  users tablespace.

SQL> drop tablespace users including contents and datafiles;

drop tablespace users including contents and datafiles

*

ERROR at line 1:

ORA-22868: table with LOBs contains segments in different tablespace

SQL> drop table cibel.tab1;

Table dropped.

SQL> drop table cibel.tab2;

Table dropped.

SQL> drop tablespace users including contents and datafiles;

drop tablespace users including contents and datafiles

* ERROR at line 1:

ORA-22868: table with LOBs contains segments in different tablespaces
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 26 2014
Added on Jul 29 2014
#general-database-discussions
6 comments
2,731 views