on 03-08-2010 5:03 PM
Oracle Version: Oracle 9.2.0.7
OS: HP Tru64
These tables have LONG RAW columns
ECC - EDI40
ECC - CDCLS
CRM - CDCLS
brtools checks for LONG columns, and you cannot reorginze the table.
What are the options for reorganization?
Thanks in advance
Hi,
What are the options for reorganization?
Option-1.
Upgrade to Oracle 10g.As of Oracle Database 10g, it is also possible to reorganize a table that has data type LONG or LONG RAW online. For releases prior to and including Oracle9i, this is not possible. Please refer SAP Note 835552.
Option-2.
With Oracle 9.2, the table with LONG and LONG RAW fields can be reorganized Offline, by exporting/importing such tables. Please refer SAP Note Note 646681 - Reorganizing tables with BRSPACE to get more information.
Regards,
Bhavik G. Shroff
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.