database reorganization error

[Former Member]

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

[ulrich_henkenjohann · Accepted solution]

Hi,

maybe the reorg was done well and only the tablespace rename failed.

Can you check the status of you new tablesapce.

select tablespace_name, status from dba_tablespaces.

should be online.

Check that the table exists in the right schema after reorganisation.

select owner, table_name from dba_tables where table_name = '<TABLE_NAME>';

The reorg protocolls you should find in /oracle/<SID>/sapreorg

Check the ORACLE Alert file also: /oracle/<SID>/saptrace/backgroung/alert_<SID>.log

Regards Ulrich Henkenjohann