Home » RDBMS Server » Server Administration » Physical structure
Physical structure [message #344239] Fri, 29 August 2008 03:12 Go to next message
ORAGENASHOK
Messages: 238
Registered: June 2006
Location: Chennai
Senior Member
At the time of installation which file name is for data,control,redo log files.

Its helpful to mention the name of the file.






Re: Physical structure [message #344293 is a reply to message #344239] Fri, 29 August 2008 05:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You can name it whatever you want.
I would stick with OFA conventions and give meaningful names for datafiles (associated tablespace name).
Re: Physical structure [message #344295 is a reply to message #344239] Fri, 29 August 2008 05:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle does not care about file names.

Regards
Michel

[Updated on: Fri, 29 August 2008 05:52]

Report message to a moderator

Re: Physical structure [message #344761 is a reply to message #344295] Mon, 01 September 2008 03:59 Go to previous messageGo to next message
ORAGENASHOK
Messages: 238
Registered: June 2006
Location: Chennai
Senior Member
If i have not created the database and i suppose to work on that on that suituation how can i know this files. There may have different name, is there is any particular extension to identify these files.

simply i want to see that files.

[Updated on: Mon, 01 September 2008 04:01]

Report message to a moderator

Re: Physical structure [message #344767 is a reply to message #344761] Mon, 01 September 2008 04:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Fri, 29 August 2008 12:52
Oracle does not care about file names.

This means that the name cannot be used to determine what is the content.

Regards
Michel

Re: Physical structure [message #344772 is a reply to message #344767] Mon, 01 September 2008 04:06 Go to previous messageGo to next message
ORAGENASHOK
Messages: 238
Registered: June 2006
Location: Chennai
Senior Member
ok Is there is any way to find details about that files.
And i want to know all system tables name and details about that can you please provide the link for that.

[Updated on: Mon, 01 September 2008 04:11]

Report message to a moderator

Re: Physical structure [message #344815 is a reply to message #344772] Mon, 01 September 2008 05:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
And i want to know all system tables name and details about that can you please provide the link for that.

select * from dba_objects;
Database Reference

Regards
Michel
Re: Physical structure [message #345372 is a reply to message #344239] Wed, 03 September 2008 04:42 Go to previous message
rooneyd
Messages: 9
Registered: September 2008
Junior Member
Hi,

For data files

select file_name from dba_data_files;

for control files

select name from v$controlfile;

for redo logs

select member from v$logfile;

Thanks
Previous Topic: Error while running dbms_repair
Next Topic: db instance not able to connect from sqlplus
Goto Forum:
  


Current Time: Sat Dec 03 01:14:45 CST 2016

Total time taken to generate the page: 0.04657 seconds