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

[Former Member]

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 ?

[Former Member]

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.

[Former Member]

Dear all,

I am still not very clear :

(1) I could use to SAPDBA to reorganize a table had LONG column without shut down my SAP (that means it was Online SAP), why ?

(2) Now, my situation is :

Use SAPDBA to reogranize a table has LONG type : Yes,

Use BRTools to reogranize a table has LONG type : No,

Should I use SAPDBA to do table reorganize ?

Will it have any harmful effect on my data ?

SAPDBA is an outdated program while BRTools is the current tool to do many database tasks.

But now, the latest program (BRTools) cannot finish my task but an outdated program could.

I don't know how to choose.

Please give me your advices.

Thanks.

[Former Member]

Hi ,

You have to do following things for reorgenization

1. SAPDBA is outdated , so pl. do not use this tool and concentrate on BR*Tools

2. Through BRTools you can reorgenize the tablespace online except LONG and LONG RAW column tables.

If you want to reorgenize these tables you have to do it offline (database will be shutdown mode)

3. To reorgenize the table with LONG and LONG RAW column you have to export the tablespace and import it again .

you can get the help of following reference notes.

541538 , 646681

[former_member204746]

(1) I could use to SAPDBA to reorganize a table had LONG column without shut down my SAP (that means it was Online SAP), why ?

no, this is not true. you cannot reorg LONG RAW with Oracle even with SAPDBA

you were in fact reorg'ing this table offline and this table was not accessible to your SAP system while reorg was in effect. this is an offline reorg

Should I use SAPDBA to do table reorganize ?

no way, avoid it, use brtools, get used to it now.

why used an unsupported tool?

[Former Member]

Dear all, I am a new guy on SAP. I have this problem too.

Database: oracle 9i

brtools: 6.4

May I reorg the file has long column when I stopped SAP and Oracle?

I don't want to export/import, so danger.

[former_member204746]

you have 2 choices:

1. export/import while SAP is offline

2. use brspace with option long2lob. it can be done while SAP is online!

again, read SAP note 600141.

[anindya_bose]

You can look at the link below

Link: [Reorganization|;

Basically Brtools skips tables with LONG and LONG RAW column. LONG--->LOB migration could have performance problem

So for a table with LONG or LONG RAW field I prefer Export /Import. You can do export /import from brtools also. Pretty simple.

Steps:

1. Export the table in a dump file ( from brtools)

2.Truncate teh existing table ( truncate table <table_name>) --> From SQL

3.Import the table content from the dump file ( from brtools)

But for export /import , SAP should be down.

[Former Member]

Dear all,

Thanks for you help. I can find a functions Import / Export in brtools, but I don't how to do. does anyone could teach me the steps for Import/Export?

When I finished Import/Export, do I need to rebuild index for table?

The table "CDCLS" have 9579559 records, it cannot reorg in brtools.

Alan.

[anindya_bose]

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.

[stefan_koehler]

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

[Former Member]

Hello,

But I am still not very clear.

My company is using Oracle 9i.

My question is :

I know SAPDBA can reorg a table which has LONG column, but I am not sure such table reorg will have any harmful effect on my data as SAP says table reorg doesn't support LONG column.

Moreover, I am not clear what is "OFFLINE" table reorg.

Can you tell the answers of these 2 questions ?

Thanks.

[Former Member]

Hi

Offline means you have to stop SAP. Online means the system is up and running during the reorg.

Regards, Michael

[former_member204746]

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.