Skip to Main Content

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!

Getting error ORA-22868 when trying to drop USERS tablespace

AchyotAug 4 2009 — edited Aug 4 2009
hello to all,

Due to users01.dbf file datablock corruption we need to drop USERS tablespace so we tried below steps
(we have full export dmp file)
1.
sql> ater tablespace users offline;
2.
SQL> drop tablespace users
2 including contents
3 and datafiles
4 cascade constraints;
drop tablespace users
*
ERROR at line 1:
ORA-12919: Can not drop the default permanent tablespace
3.
sql>alter database default tablespace system;
4.
SQL> drop tablespace users
2 including contents
3 and datafiles
4 cascade constraints;
drop tablespace users
*
ERROR at line 1:
ORA-22868: table with LOBs contains segments in different tablespaces

So, how to solve the above error. please give some guidence.

with regards,
Achyot
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 1 2009
Added on Aug 4 2009
7 comments
8,163 views