Re: Resizing datafiles

> Is it possible to resize a temp datafile (in a temp tablespace)
> to a smaller size? What would be the syntax? Would it have
> any negative effects to do that?

To resize the file to 15 MB u can execute

ALTER DATABASE DATAFILE '/path/to/file/temp01.dbf' RESIZE 15M;  

hth,

    Marin

"The important thing for all of us is never look *at* the bars, look *through* them. Because if you keep looking *at* bars, you'll never get anything done, and you'll never have fun in life, any joy."

                                                  William Wharton, "Pride"