Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> temp.dbf and no dba
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:05:25 CST