Ora-22868

Ora-22868

删除fondomedia表空间时出现ora-22868错误

ORA-22868 table with LOBs contains segments in different tablespaces

Cause: An attempt was made to drop a tablespace which contains the segment(s) for the LOB columns of a table but does not contain the table segment.

Action: Find table(s) with LOB columns which have non-table segments in this tablespace. Drop these tables and reissue drop tablespace.

 

查找dba_segments中发现有tablespace=fondomedia的segment，type为lobsegment和lobidnex

查找dba_index和dba_lobs发现表f_cp_request_info使用lob字段，删除info表后即可删除fondomedia空间，重建info表。 注意建表时使用lob的storage为指定表空间。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17066567/viewspace-675637/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17066567/viewspace-675637/