Better than that -- one day I was creating a database and forgot to set the
temporary tablespace -- then I loaded and indexed a rather large table (>4G, >78M
rows). I now have a 4G system tablespace on that database :-).
"Joseph S. Testa" wrote:
> Ganti, things like new users get created in the
Ganti, things like new users get created in the database every day.
sometime people put
create user scott identified by tiger;
ok their default and temp ts is system.
u let it go to max extents, scott is logged in and creates some
outrageous table with 10K initial 10K next pctincrease 0, they
OK Joe,
I am taking back my suggestionCan you exactly tell me what would happen if
(maxextents unlimited ) for system tablespace
As far as i know only datadictionary and packages(compiled code) reside in
tablespace SYSTEM.So even if i give maxextents unlimited
What would happen if no bod