| Multiple Databases on Single Server [message #382425] |
Thu, 22 January 2009 04:37  |
|
|
Hello,
Please help me.
Where I can get multiple database names and their details on single server. Please let me know if you know file path or table name(s) for the same.
TNSNAME.ORA provides multiple database name but this will not help to my answer as HOST ip address will be different for each database
My requirement is as below:
Following is the out put of SQLServer on Windows. We need similar attribute details for Oracle on HP-UX/IBM-AIX from command prompt of UNIX server (root) or oracle login.
SQLServer Output:
<database name="C_EmilLundgren1">
<collation>SQL_Latin1_General_CP1_CI_AS</collation>
<users>dbo;qondoc;ssa</users>
<size>244</size>
<filepath>C:\Program Files\Microsoft SQL Server\MSSQL\Data\C_EmilLundgren1.mdf</filepath>
<transize>51</transize>
<tranfilepath>C:\Program Files\Microsoft SQL Server\MSSQL\Data\C_EmilLundgren1_log.ldf</tranfilepath>
<servername>SEGOTJOSA001</servername>
<options>0;0;0;0;1;1;1;0;</options>
</database>
Many thanks for your help.
Avinash
|
|
|
|
|
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
