Hi ,
I'm getting this error:
Unable to extend table emp by 15552 in tablespace users
How do I rectify this ?
Thanks
pst
Printable View
Hi ,
I'm getting this error:
Unable to extend table emp by 15552 in tablespace users
How do I rectify this ?
Thanks
pst
your table EMP needs 15552 bytes of chunk in users tablespace which it can't find.
Reasons(solution):
Its might have been fragmented(Try Coalesciing users with "ALTER TABLESPACE users COALESCE;"
Its might have been ran outta space (add space by resizing/adding datafile)
Quick fix in this situation is to see how much free space you have in the tablespace from DBA_FREE_SPACE and then Alter table ..... storage (NEXT .......) so that it will fit.
Then find out why you had the problem. ANALYZE the table and try to establish a growth pattern.
Check the available disk space and add a new datafile with Autoextend ON.
Run Alter table .... storage (NEXT .....) again after you have some idea of what its future requirements are.
Good DBA's know their data.