Home » RDBMS Server » Server Administration » What table contain name of all datafiles???
What table contain name of all datafiles??? [message #50137] Sun, 03 March 2002 21:40 Go to next message
Anatol
Messages: 15
Registered: January 2002
Junior Member
I need to start some procedure after the change,insert or remove of any name of database files . How can I do it ( the good idea - from trigger , but what table contain name of all datafiles ).

Report message to a moderator

Re: What table contain name of all datafiles??? [message #50140 is a reply to message #50137] Sun, 03 March 2002 23:13 Go to previous messageGo to next message
ksr
Messages: 112
Registered: January 2002
Senior Member
Try..
select * from v$datafile;
This will contain all the datafile information

Report message to a moderator

Re: What table contain name of all datafiles??? [message #50151 is a reply to message #50137] Mon, 04 March 2002 04:32 Go to previous message
saleem
Messages: 65
Registered: January 2002
Member
dba_data_files

Report message to a moderator

Previous Topic: Re: Connectivity with non-oracle !!!!!! Very Urgent
Next Topic: script for tablespace growth
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 19:53:22 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.