0 Replies Latest reply on Nov 30, 2012 8:48 AM by 862343

    how can i purge expire data in OMR?

    862343
      i use gc 12c ,and i find tablespace is allmost full,how can i clean the old data from tables?
      TABLESPACE_NAME                FILE_NAME                                             free(M)   total(M)    used(%)
      ------------------------------ -------------------------------------------------- ---------- ---------- ----------
      UNDOTBS1                       /data/app/oracle/oradata/mygc/undotbs01.dbf          333.5625        545 38.7958716
      MGMT_ECM_DEPOT_TS              /data/app/oracle/oradata/mygc/mgmt_ecm_depot1.dbf       4.625         20     76.875
      USERS                          /data/app/oracle/oradata/mygc/users01.dbf              3.6875          5      26.25
      MGMT_AD4J_TS                   /data/app/oracle/oradata/mygc/mgmt_ad4j.dbf          197.5625        200    1.21875
      SYSAUX                         /data/app/oracle/oradata/mygc/sysaux01.dbf                 45        820 94.5121951
      MGMT_TABLESPACE                /data/app/oracle/oradata/mygc/mgmt.dbf                73.6875       1050 92.9821429
      SYSTEM                         /data/app/oracle/oradata/mygc/system01.dbf              6.375        830 99.2319277