Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to get dbf file information?
hi,
Try selecting from V$DATAFILE or DBA_DATA_FILES and see if that provides what you want..
To drop a datafile, try
ALTER DATABASE DATAFILE 'filepath/filename' OFFLINE DROP;
Then remove the file through your operating system.
Hth,
Steve
In article <3a521831$0$23823_at_fountain.mindlink.net>,
"Gennady" <gennadyb_at_halcosoftware.com> wrote:
> Hello:
> 1.How can I get existing dbf files information:
> file path, file size, file creation time,
> using SELECT statement?
> 2.How can I drop a dbf file completely (physically),
> using SQL statement?
>
> Thanks.
>
>
Sent via Deja.com
http://www.deja.com/
Received on Tue Jan 02 2001 - 12:35:34 CST
![]() |
![]() |