Database Administration (MOSC)

MOSC Banner

Using DBMS_REDEF to move non partitioned table to new tablespace and change basic lobs to securefile

Hello All,

We have a 19.13.0.0.0 database 

There is a table that has LOBS defined as BASIC FILES

The table is huge with 32 GB of data and 10 TB of LOBS

We need to relocated the LOBS to a different tablespace and also convert Basic LOBS to securefiles lobs

The table has a few columns defined as data types including the LOB columns

We explored the alter table move and export / import but since the data is not partitioned it is taking a long time (downtime of more than 20 hours) and we are seeking a process that is comparatively faster and will not require that big of a downtime (if at all) so we are thinking of using DBMS_REDEF 

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