Storage space not adequate
Your current database uses dictionary managed tablespaces. In running various performance tuning scripts, you have discovered that one of these tablespaces seems to have run out of space long before you calculated that it would. In tracking activity in the tablespace, you discover that the process of tables being created, then dropped and re-created, with different storage settings, has been excessive. Give an explanation for why your tablespace might have a problem, and list at least two actions you can take to lessen the problem. Some of the solutions are short term and some are long term. Your solution cannot implement ASM nor a GRID technology as resources are not available for that.