Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to get dbf file information?

Re: How to get dbf file information?

From: <steveee_ca_at_my-deja.com>
Date: Tue, 02 Jan 2001 18:35:34 GMT
Message-ID: <92t71l$a5n$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US