|
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|