Home » RDBMS Server » Server Administration » Is there any tool for database creation?
icon5.gif  Is there any tool for database creation? [message #225690] Wed, 21 March 2007 00:12 Go to next message
naimish_hit
Messages: 34
Registered: March 2007
Member
Hi All,

Can we use DBCA or similiar type of tool with Oracle 10G Express edition?

Thanks in advance

Naimish R. Dave
Re: Is there any tool for database creation? [message #225698 is a reply to message #225690] Wed, 21 March 2007 01:13 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Can we use DBCA


Yes, you can use DBCA for database creation, deletion ,configure.

regards
Taj
Re: Is there any tool for database creation? [message #225764 is a reply to message #225690] Wed, 21 March 2007 06:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
why not continue in single thread?
Flooding the forums will help nothing!
icon5.gif  Re: Is there any tool for database creation? [message #225765 is a reply to message #225690] Wed, 21 March 2007 06:10 Go to previous messageGo to next message
naimish_hit
Messages: 34
Registered: March 2007
Member
Thanks Mohhamad Taj,

I was refering your article for creating database but I dont have DBCA installed on my PC.

Can you tell me from where I can get DBCA ?

Thanks in advance,

Naimish R. Dave
Re: Is there any tool for database creation? [message #225768 is a reply to message #225765] Wed, 21 March 2007 06:21 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
No need DBCA.
Use SQL*Plus.
Usual procedures.
set new ORACLE_SID.
create a pfile. Startup nomount
use a create database script.
Re: Is there any tool for database creation? [message #225769 is a reply to message #225768] Wed, 21 March 2007 06:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://devtime.blogspot.com/2006/01/creating-oracle-xe-database-manually.html
Re: Is there any tool for database creation? [message #225775 is a reply to message #225765] Wed, 21 March 2007 07:09 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Can you tell me from where I can get DBCA ?
start >>> program >>> oracle_home >>>configuration and migration tools >>> DATABASE CONFIGURATION ASSISTANTS.

or just try like
start >>> run >>> dbca <<hit enter>>

regards
Taj
Previous Topic: Init Parameters to be set for Oracle 10g R2
Next Topic: Oracle 9i lock file (lkDBNAME)
Goto Forum:
  


Current Time: Tue Dec 06 08:28:43 CST 2016

Total time taken to generate the page: 0.23862 seconds