cancel
Showing results for 
Search instead for 
Did you mean: 

Options to avoid error ORA-01653

sanjeev_kumar18
Explorer
0 Kudos

Hi all,

Error - ORA 01653,01654

Since this error message is related to tablespace overflow. So using what all options can we avoid this error, apart from table reorganisation ?

Regards,

Sanjeev Kumar

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Sanjeev,

This error as you know oocurs when there are no free contigous data block to be allocated in the data file.

There are two solutions for this.

1. Extend the table space i.e you add new data files in the table space.

2. Resize the datafile size.

Also if you are using Locally managed tablespaces, you can set the autoextend option on for a reasonable size if you can afford diskspace.

All this can be done using BR*TOOLs (which i am sure you are already aware of :-).

Hope this helps.

Regards,

Prashant

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Sanjeev,

This error 1653,1654 is related with table space over flow. for avoiding this errors we need to monitor data base using tcode DB02 and we need to configure CCMS. In configuration we need to set trishold values if table space reached 90% then Alarm has to give.Means in configuration of thrishold value red mark will give immidiate we can take raquired steps.

eighther it is LMTS or DMTS databases.

Please reward the points if it is usefull.

Regards,

Raju.