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!

tablespace drop

user3266490Nov 19 2009 — edited Nov 19 2009

Hi,

SQL> drop tablespace STREAMS_TBS including contents and datafiles
2 ;
drop tablespace STREAMS_TBS including contents and datafiles
*
ERROR at line 1:
ORA-22868: table with LOBs contains segments in different tablespaces

THEN
i EXECUTED
SQL> select owner,tablespace_name from dba_Tables where OWNER like 'STRMADMIN%';

OWNER TABLESPACE_NAME
------------------------------ ------------------------------
STRMADMIN STREAMS_TBS
STRMADMIN STREAMS_TBS
STRMADMIN STREAMS_TBS
STRMADMIN STREAMS_TBS
STRMADMIN STREAMS_TBS
STRMADMIN STREAMS_TBS
STRMADMIN
STRMADMIN
STRMADMIN
STRMADMIN
STRMADMIN

OWNER TABLESPACE_NAME
------------------------------ ------------------------------
STRMADMIN

12 rows selected.

HOW TO DROP THE TABLESPACE?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 17 2009

Added on Nov 19 2009

#general-database-discussions

2 comments

460 views