on 03-03-2008 11:42 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.