Home » RDBMS Server » Server Administration » Database Name ?
Database Name ? [message #33445] Wed, 13 October 2004 02:09 Go to next message
swetha
Messages: 10
Registered: November 2000
Junior Member
How can I select databasenames which are available in my system ?

how to create a new database ?

pls help me..
thanks..
Re: Database Name ? [message #33450 is a reply to message #33445] Wed, 13 October 2004 05:19 Go to previous messageGo to next message
dilip kumar
Messages: 111
Registered: December 2003
Senior Member
Hi,
tell me which O/S you are using

Regards

D.Dilip
Re: Database Name ? [message #33452 is a reply to message #33445] Wed, 13 October 2004 05:43 Go to previous messageGo to next message
Rana Irfan
Messages: 15
Registered: August 2004
Junior Member
Hi,
U can See the Database Name like this.
select * from global_name;
Rana Irfan
Re: Database Name ? [message #33475 is a reply to message #33450] Wed, 13 October 2004 20:29 Go to previous messageGo to next message
swetha
Messages: 10
Registered: November 2000
Junior Member
Windows 2000 Proffesional

Oracle 9i server
and Oracle 8i client
Re: Database Name ? [message #33485 is a reply to message #33445] Thu, 14 October 2004 05:12 Go to previous messageGo to next message
dilip kumar
Messages: 111
Registered: December 2003
Senior Member
Hi

you can see in two different ways

1)go to services option of ur windows then u will find the instance name for each of the database created on your system(this will work only if your instance name is same as database name)

2)got windows registry under that select local machine software option under that u will see oracle_home once it shows that option on left hand side u will find all the database names)

select * from global_name from will give only one database name to which you have connected

regards

D.Dilip
Re: Database Name ? [message #33494 is a reply to message #33485] Thu, 14 October 2004 20:06 Go to previous messageGo to next message
swetha
Messages: 10
Registered: November 2000
Junior Member
How to create a new database ???
Re: Database Name ? [message #33495 is a reply to message #33494] Thu, 14 October 2004 21:10 Go to previous message
dilip kumar
Messages: 111
Registered: December 2003
Senior Member
Hi
you can create in two different ways

1)manually(needs to perform many tasks manually)
2)with help of database configuration assistant option(no need to perform any manual tasks it's gui tool just keep on click NEXT option then DBCA tool will create a database for you)

for 2 and option go to programs select oracle option under that select configuration assistant then you will find a option to create a database then it ask for some information from you like database name and all just type the options

Regards

D.Dilip
Previous Topic: Rebuild table in same tablespace
Next Topic: ORA-12154: TNS:could not resolve service name
Goto Forum:
  


Current Time: Thu Jan 09 22:56:25 CST 2025