Skip to Content
avatar image
Former Member

But SAPDBA supports LONG column type Table ReOrganize, can I use it ?

BRTools doesn't reorganize a table which has LONG data type column but SAPDBA does.

So, will it have any harmful effects on my SAP if I use SAPDBA to reorganize table which has LONG column ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 17, 2008 at 08:24 AM

    Hello Ming,

    this is not a question about the tools.. this is a question about how the reorganization is done and the impacts of it.

    If you have tables with LONG columns, you can reorganize this table OFFLINE. If you have Oracle 10g and using BR*Tools you are doing an implicit conversion to LOB with an ONLINE reorg (sapnote #835552). But you can do this also OFFLINE with LONGs..

    Both tools can reorganize a table with LONG columns, but you have to think about the effect and the way how it is done (ONLINE/OFFLINE/LONG-LOB conversion).

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

    • SAPDBA can reorg offline only, while SAP is down.

      brtools can reorg offline. but can also reorg online, while SAP is up.

      one exception though... LONG and LONG RAW must be reorg'ed offline

      so, if you plan or reorg'ing LONG or LONG RAW often, you could convert it to LOBs. Check SAP note 600641.

  • avatar image
    Former Member
    Oct 17, 2008 at 02:30 PM

    Hello,

    AS long as data type doesnt change it is not matter which tool you used to reorg. You can use SAPDBA but it should be done offline so that data type still LONG as you are on Oracle 9.

    Thanks,

    Kiran.

    Add comment
    10|10000 characters needed characters exceeded

    • After you choose Export options from BRTOOLS , you have to specify the Export Dump Directory, that means where the dump file will be created. Like D:\Reorg\export\<tablename> ...export table name , tablespace name

      Keeep your SAP down that time. As that table contains lots of entries it might take long time like 3 hours or so for export.

      Once export is finished you will get a message from brtools. Ensure your export has finished successfully.

      Now, come out of brtools and Login to SQL prompt.

      >connect /as sysdba

      >select count(*) from <SAPCHEMA>.<tablename>;

      >truncate table <SAPCHEMA>.<tablename>;

      >select count(*) from <SAPCHEMA>.<tablename>;

      Last select statement should show 0 entries.

      Then, from brtools again , select import option. Here you need to provide the dump file location. Rest of the thing BRTOOLS will take care of. After sucessful import , if you issue the SQL select command >select count(*) from <SAPCHEMA>.<tablename>;

      it should return the same number of entries as it was there before export.