Database Administration (MOSC)

MOSC Banner

convert TS from manual to assm

edited Jul 25, 2017 3:15PM in Database Administration (MOSC) 17 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center