OraFAQ Forum: Server Administration » Multiple database on Oracle 10G Express edition ???

Home » RDBMS Server » Server Administration » Multiple database on Oracle 10G Express edition ???

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

Multiple database on Oracle 10G Express edition ??? [message #225568]

Tue, 20 March 2007 06:37

naimish_hit
Messages: 34
Registered: March 2007

Member

Hi All,

I have just join this forum before few days back and I found that this Forum is very useful for Oracle developers.

I have installed Oracle Database 10g Express Edition (Western European) on Windows XP.

I am able to connect XE database and login into it with system as well as HR login. Upto here everything is working fine.

My question is that is it possible to create a new database on Express edition ?? Can I have multiple databases on Express edition ?

Does Express edition support Database Configuration Assistant (DBCA) Or Is there any other tool for database creation (which runs on Express edition) ?

Thanks in advance..

Naimish R. Dave

Report message to a moderator

Re: Multiple database on Oracle 10G Express edition ??? [message #225572 is a reply to message #225568]

Tue, 20 March 2007 06:53

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I dont think so.
XE comes with a pre-configured 4gig limited database.
You can create multiple databases, but you cannot use them all together (as in a regular Oracle standard/enterprise edition).
You can have only one instance at a time.

[Updated on: Tue, 20 March 2007 06:55]

Report message to a moderator

Re: Multiple database on Oracle 10G Express edition ??? [message #225579 is a reply to message #225568]

Tue, 20 March 2007 07:08

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://www.oracle.com/technology/pub/articles/cunningham-database-xe.html

Report message to a moderator

Re: Multiple database on Oracle 10G Express edition ??? [message #225684 is a reply to message #225568]

Tue, 20 March 2007 23:59

naimish_hit
Messages: 34
Registered: March 2007

Member

Thanks Mahesh,

But what if I want to create a new database on 10G Express edition.

I have read 10G XE limitations (http://www.oracle.com/technology/pub/articles/cunningham-database-xe.html). They have stated that we cannot run multiple databases at a time (which we can do in Standard or Enterprise).

Here in my scenario I dont want multiple databases but I also dont want to work on default database. I want to create a new database and make it active.

How to disable/stop/deactivate default database and Create a new database?

Regards and Thanks in advance

Naimish R. Dave

Report message to a moderator

Re: Multiple database on Oracle 10G Express edition ??? [message #225700 is a reply to message #225684]

Wed, 21 March 2007 01:17

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

Go through below link
http://st-curriculum.oracle.com/tutorial/DBXETutorial/index.htm

You can use DBCA for create new database or drop old database.

hope this helps
Taj

Report message to a moderator

Re: Multiple database on Oracle 10G Express edition ??? [message #225701 is a reply to message #225568]

Wed, 21 March 2007 01:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How to disable/stop/deactivate default database and Create a new database?
If you are smarter than GUI tools, there is alway SQL*Plus which allows you to do anything you are capable to doing.

Report message to a moderator

Previous Topic:	Oracle 9i CPU Affinity
Next Topic:	Recover using ARCHIVE files in Oracle 8i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 15:33:10 CST 2024