Skip to Content
0
Dec 26, 2007 at 09:52 AM

database reorganization error

42 Views

Hi All

According to note no 646681 we had performed DB reorganization for Oracle 10 G by using BRSPACE commands

Long fields conversion

1. brspace -f tbreorg -a long2lob -t "*" -n psapclud_n -p 4

2. brconnect -u / -c -f stats -t all -f collect -p 4

***********************

1. brspace -f tscreate -t psapclud_n -d both -l psapclud

2. brspace -f tbreorg -s psapclud -t "*" -n psapclud_n -p 4

3. brspace -f tsdrop -t psapclud

4. brspace -f tsalter -a rename -t psapclud_n -n psapclud

5. brconnect -u / -c -f stats -t psapclud -f collect -p 4

Currently we have reorganised for single tablespace PSAPCLUD

After all the steps got completed we started sap but

As soon as we logon by logonpad

we are gettin the ABAP dump

DBIF_RSQL_TABLE_UNKNOWN

A table is referred to in an SAP Open SQL statement that either does not

exist or is unknown to the ABAP Data Dictionary.

The table involved is "AGR_DATEU " or another table accessed in the statement

no errors occured during reorganization but are unable to run any transaction codes in sap

Can any please suggest where any logs would be generated

where any errors can be found ,we are clueless please help