Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: temp.dbf and no dba
I forgot to mention that we are on hpux 10.20 oracle 7.3.3.
Tim Downs wrote:
> Help, are dba has left and are temp.dbf file was set to auto extend.
> Some one wrote a crystal report wrong and are temp.dbf grew to 2gig
> (filled up our volume). I used an oracle tool called DBArtisan to turn
> auto extend off but I need want to reduce the temp.dbf to 500 meg.
> DBArtisan says that there is 1 meg worth of data in the temp.dbf. It
> also appears that I can use DBArtisan to reduce the file size. Can I do
> this anytime or do I have to make sure all users are off, or do I have
> to drop the table and recreate it?
>
> tia
>
> Tim Downs
> tim.downs_at_thedacare.org
Received on Tue Nov 28 2000 - 16:24:38 CST