How to Resolve ORA-30036
Cause :- Undo tablespace is full.
Check how much free space availiable in UNDO tablespace
SELECT TABLESPACE_NAME,SUM(BYTES)/1024/1024/1024 "FREE SPACE(GB)"
FROM DBA_FREE_SPACE WHERE TABLESPACE_NAME='UNDOTBS1' GROUP BY TABLESPACE_NAME;
Solution:- Extend undo tablespace.
There are two possibilities
- Add a New datafile to UNDO tablespace,
- ensure you have sufficient space under /mount_point where you are adding the datafile.
- adjust path, size, autoexend etc according to your requirement
alter tablespace UNDOTBS1 add datafile '/ora_app/product/oradata/oemrp/undotbs02.dbf' size 100M autoextend on next 100M maxsize unlimited;
Tablespace altered.
2. Resize the existing datafile if possible
alter database datafile '/ora_app/product/oradata/oemrp/undotbs01.dbf' resize 1G;
Database altered.
No comments:
Post a Comment