Link to home
Start Free TrialLog in
Avatar of Waqasulhaq
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.
Avatar of Devinder Singh Virdi
Devinder Singh Virdi
Flag of United States of America image

Please provide initial and next parameter of SYS.AUD$ table, definition of SYSTEM tablespace and output of the following.

select *from dba_tablespaces;

select * From dba_data_files where tablespace_name ='SYSTEM';
ASKER CERTIFIED SOLUTION
Avatar of no worries :-) no nothing
no worries :-) no nothing
Flag of Greece image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bencanty
bencanty

sugeti pula cu site-ul vostru