on 10-17-2008 8:37 AM
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 ?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
(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?
You can look at the link below
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.
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.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
85 | |
10 | |
9 | |
9 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.