Hi
Oracle 11.2.0.4.0
I have a little problem.
So I wanted to move all the stuff away from one tablespace to another. That is what I did. Also this tabelspace has table that has single lob column and also this table is partitioned.
My problem is with the partitioned table.
I moved all the partitions away from this tablespace + updated global indexes, with command:
ALTER TABLE ETOIMIK.LOGI MOVE PARTITION <<PARTITION_NAME>> TABLESPACE <<TABLESPACE_NAME>> LOB(MESSAGE) STORE AS (TABLESPACE <<TABLESPACE_NAME>>) UPDATE INDEXES;
Indexes also got rebuilt to a new tablespace after.
So basically at the moment, these are, that are checked, and each of which return 0 rows, except dba_lobs.
select * from dba_tables where tablespace_name = 'LOGI_OLD';
select * from dba_tab_partitions where tablespace_name = 'LOGI_OLD';
select * from dba_ind_partitions where tablespace_name = 'LOGI_OLD';
select * from dba_indexes where tablespace_name = 'LOGI_OLD';
select * from dba_users where default_tablespace = 'LOGI_OLD';
select * from dba_ts_quotas where tablespace_name = 'LOGI_OLD';
select * from dba_lobs where tablespace_name = 'LOGI_OLD'; --<-- This is the problem. Look the following picture
My question is, how can I move only this segment away from this tablespace..? (I would not rather move whole table, because there is quite lot of data.)
This does not work for the partitioned table
alter table ETOIMIK.LOGI move lob (MESSAGE) store as SYS_LOB0000035008C00005$$ (tablespace LOGI);
ORA-14511: cannot perform operation on a partitioned object
And also, is there some other view, that I must check, before I can successfully drop this tablespace..?
Also not that this is production system.
Regards
Raul