convert TS from manual to assm
Oracle 11.2.0.4.0 SE-One 64-bit
Windows Server 2012
Developer brings to me error "ORA-4853: SECUREFILE lobs cannot be used in non-ASSM tablespace ...."
This is in a prod database and error did not reproduce in test. Found that the TS in test is defined SEGMENT SPACE MANAGEMENT AUTO while in prod it is SEGMENT SPACE MANAGEMENT MANUAL.
Fix appears to be to expdp the TS, drop the TS, recreate the TS, then impdp the export.
Just want to make sure there are no 'gotchas'. The TS has the following segment types, especially as regards the LOBs
SQL> select segment_type,
2 count(*)
3 from dba_segments