OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Physical structure

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Physical structure [message #344239]

Fri, 29 August 2008 03:12

ORAGENASHOK
Messages: 240
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.

Report message to a moderator

Re: Physical structure [message #344293 is a reply to message #344239]

Fri, 29 August 2008 05:51

Mahesh Rajendran
Messages: 10708
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).

Report message to a moderator

Re: Physical structure [message #344295 is a reply to message #344239]

Fri, 29 August 2008 05:52

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

ORAGENASHOK
Messages: 240
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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Physical structure [message #344772 is a reply to message #344767]

Mon, 01 September 2008 04:06

ORAGENASHOK
Messages: 240
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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Physical structure [message #345372 is a reply to message #344239]

Wed, 03 September 2008 04:42

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 19:41:04 CST 2024