copying .dbf files

[Yogeeraj_1]

hi,

to know more about the temporary files that are in use by your database, you can run the following SQL:

select * from dba_temp_files;

note that i you decide to create new temporary tablespaces (other that what you had previously), you will have to modify the user profiles accordingly.

hope this helps too!

kind regards
yogeeraj

[Dave Walley]

I believe the reason that the file shows as a smaller size is due to the fact that oracle temp files are only used when there is a query run that requires a sort. The files exist in sparse format and will use the true disk space only after the database is used and sorting occurs. To prove this have a dba run a query that involves a sort and watch the size of the file increase from a block usage point of view. Use "ll -s file_name" before and after the query is run. Dave

[TwoProc]

Right Dave,

but keep in mind that they don't shrink back down. Eventually, they will probably "fill out" to full size.

[Vanja]

Thanks to all for your information!