Skip to Content

single table reorganization

I need to reorg a single table offline since I have LRAW data type and I'm running Oracle 9.2.0.7. The procedure in note 646681 is for reorging tablespaces. If you can share your thoughts and experiences on how to perform a single table offline reorg, it would be appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 02, 2010 at 07:52 PM

    The brtools allow you to reorganize a single table.

    brspace u2013f tbreorg -t <table>

    Check that you use a current version of brtools 7.00 or 7.10. According to SAP note 12741 those versions also support Oracle 9.

    But why are you still using Oracle 9. You are strongly advised to update to Oracle 10.2.0.4 and if possible even to Oracle 11. I suggest you update your db because newer versions of brtools offer more functions than the old versions. But they do no longer support Oracle 9.

    Kind regards,

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 02, 2010 at 08:15 PM

    Hi,

    The steps mentioned in SAP Note 646681 are well explained and are enough to perform offline reorganization for the tables which are having LONG RAW data field. You will have to execute the steps 1,3,4,5,7,8,9,10 & 11 in sequence as mentioned in SAP Note 646681. Instead of * as an input in -t option of BRSPACE -f tbexport , you can specify the single table name.

    Alternatively,

    Using BRSPACE, you can export/import single table to perform such Offline reorganization.

    i.e.

    Brtools ->Segment Management ->export tables

    Brtools >Segment Management ->Import Table

    Take the reference of [this thread|table-reorg-failed; and Refer the steps mentioned to perform Export/Import of table with LONG data field.

    As of Oracle 10g, one can do online reorganization of such Tables with LONGtoLOB option of table reorg using BRSPACE.

    Regards,

    Bhavik G. Shroff

    Edited by: Bhavik G. Shroff on Dec 3, 2010 1:48 AM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Jamal Asi

      >>step #1: Do I need to create a new tablespace? Can't I use the existing table space?

      Yes, you can use the the existing tablesapce.

      >>step #6: brspace -f tsdrop -t <tsp_name> -f: Do I need to drop the entire tablespace if I'm only reorging just one table?

      No, do not drop the tablespace if you performing the reorg for a single table.