2 Replies Latest reply: Aug 16, 2013 9:56 AM by Ben Speckhard-Oracle RSS

    PCTFREE value for _LT

    ⁸⁷Rb-⁸⁷Sr

      Hi,

      I want to change PCTFREE for some OWM tables.

       

       

      I traced two procedures for that. One is dbms_wm.AlterVersionedTable and second is dbms_wm.BeginDDL...

       

       

      BeginDDL creates temp _LTS table, indexes in the same tablespace and this process will fragment its, especially if a table is very big.

       

       

      Therefore I want to use dbms_wm.AlterVersionedTable. This is supported by Oracle?

       

      Oracle 11.2.0.3