Waqasulhaq
asked on
ORA-01653 error even though there is space in tablespace.
I get the following error even though my system tablespace is not full.
ORA-01653: unable to extend table SYS.AUD$ by 1049868 in tablespace SYSTEM.
When i check the system tablespace it is only 32% full.
I have also made the maxextents unlimited for the AUD$ table.
Please let me know if you need any other info.
ORA-01653: unable to extend table SYS.AUD$ by 1049868 in tablespace SYSTEM.
When i check the system tablespace it is only 32% full.
I have also made the maxextents unlimited for the AUD$ table.
Please let me know if you need any other info.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
sugeti pula cu site-ul vostru
select *from dba_tablespaces;
select * From dba_data_files where tablespace_name ='SYSTEM';