Re: current size of file in v$tempfile

"sarab" <sarabjeetd_at_hotmail.com> wrote in message news:D7mKa.3371$MZ1.1566_at_news.cpqcorp.net...
> Hi,
> How do i find out the current size of the file in the v$tempfile view.
> The create_bytes and bytes column in the view have the same value.
> Another question: If the temp file is full, how does oracle handle it.
> Oracle Version 9i
> regards
> -sarab
>
>
>
>

1 if bytes= create_bytes the file has never been extended and the current value is bytes
2 if the file can be autoextended it will be autoextended. Otherwise you'll get an error.

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address