Unable to extend table

[pst]

Hi ,

I'm getting this error:

Unable to extend table emp by 15552 in tablespace users

How do I rectify this ?

Thanks

pst

[sreddy]

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)

[Tony Bass]

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.