Reorganisation files

[Former Member]

Hi,

Can we delete SAP reorganisation files?

The files are located under

R:\oracle\PR1\sapreorg\ORACLE\PR1\SAPDATA5

contents are

BTABD_1,BTABD_2,BTABD_3,BATBD_4,BATBD_5, BATBD_6, BATBD_7 and BATBD_10. and their timestamp is 3/6/2009 6:38 PM,3/6/2009 6:41PM,3/6/2009 6:42 PM,3/6/2009 6:43 PM,3/6/2009 6:44 PM,3/6/2009 6:45 PM,3/6/2009 6:46 PM and 3/19/2009 10:50 AM respectively.

where PR1 is SID of production

If deleteing is not possible, can we move this files to another location.

Our environment is SAP R/3 4.6C, Oracle 10g and windows 2003.

Thanks and Regards

Satya

[JPReyes]

If the data have been reorganized into another tablespace and those datafiles belong to a tablespace that is not in use anymore you can drop the tablespace. I'll check before doing anything as PSAPBTABD is an important tablespace.

Read SAP Note 646681 for reorganization procedures

Regards

Juan

[former_member204746]

shutdown your DB. once this is done, check timestamp of datafiles (not directories).

they should all be dated at the time of your shutdown. if not, they are probably lost files and you can probably delete those old files. but, just to be sure, back them up first.

[Former Member]

Hi,

thanks, the provided information is very use full.

Thanks and Regards

Satya

[Former Member]

Hi,

As orasid open an sql session :

sqlplus "/ as sysdba"

and execute the following command

SQL> select file_name from dba_data_files ;

It will list all datafiles belonging to your database. You can delete the files that are not on the list.

Thanks,

Mohamed.

[Former Member]

Sorry,

I noticed that you are on Windows so instead of orasid use sidadm.

Thanks,

[Former Member]

Thanks, I got it.

Regards

Satya