Oracle Database Space Issue

[Former Member]

Hi,

In the Oracle Database Server, which are the files other than Archive file can be deleted.

Regards,

Jigar Panchal.

[Former Member · Accepted solution]

Hi,

1) You can schedule job for cleanup logs

<b>http://help.sap.com/saphelp_nw2004s/helpdata/en/15/01df3a1fd91974e10000000a11402f/frameset.htm</b>

2) Tablespace reorganization sapdba

3) DE-FRAGMENTING OF TABLESPACE

Example: <b>PSAPTEMP</b>

sqlplus> <b>alter tablespace psaptemp COALESCE;</b>

regards,

kanthi

[Former Member]

Hi,

In an oracle database you should not delete anything.

The archive logs should only be deleted after they have been backed up.

COALESCE does not <b>free</b>space at OS level.

You can clean the logs created by the BR* tools and copy+compress the alert log if it is too big. Other than that, there is nothing that can be deleted