Re: Help! Urgent! Database incredibly grown.

Hi,

My guess is one of the users has been created without specifying default temporary tablespce parameter. This has caused to use system's tablespace as default temporary tablespace and that user was running some large queries (may be causing large sorts) wich has caused to grow that temporary segment

check the sys.dba_users

by checking default_tablespace and
temporary_tablespce values for all the users

You can identify from that query
what's the wrong

If you find any user having temporary_tablespace as SYSTEM, ypou need to issue the sql command alter user user_name temporary tablespe TEMP(whatever your temporary tablespace)

HTH Madhu Cherukuri

Danil Krasnov wrote in message <01bdcde1$4aa2c980$528480c3_at_www>...
>Hello, gurus!
>
>Usually my database takes about 270 Mbytes of diskspace.
>Today something happend (don't know what) and database grown up to 700
>MBytes.
>
>Tablespace manager shows that about 500 Mb takes sys's extent of
>'temporary' type.
>
>What could be a reason and what I have to do now to reduce database size?
>
>Please help..
>
>Thanks in advance.
>
>
>Danil Krasnov
>danil_at_maginfo.net
Received on Mon Aug 24 1998 - 00:00:00 CEST