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