New answers tagged tablespaces
The good thing with Oracle is, it lets you always trick things, do all manual stuff no matter how automatic it is. autoallocate in our DW/ODS environment is a real pain, not because it is bad, but because our conditions. All huge deletes, inserts and truncates fragmantation is unavoidable with autoallocate. The system always has to grow and the solution is ...
You have to create one new tablespace into the database because for the SYSTEM tablespace access, SYSDBA privileges are required. So, create one new tablespace and assign it as the default tablespace to all users. When you create any user, by default it will give assign particular tablespace.
Top 50 recent answers are included