Home » RDBMS Server » Enterprise Manager » Create DataBase in oracle 10g XE
Create DataBase in oracle 10g XE [message #239039] Mon, 21 May 2007 05:43 Go to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

Hii All

I am new in using oracle 10g
and my supervisor asked wants to work with this version (Oracle 10g Express Edition)

so
i want to have references on this Version


and have some questions

there is only one Alias database which is 'HR'
how can i create a new database ??


do i must be online on the internet to work 
as i think it create a session for me on the internet
and how can i work local??



does this version contain a developer tool??
and what is the development tool that is suitable for it??
and can i install oracle developer 10g and work beside it



where is the sql plus
I saw something like the command prompt



Pleas don't ignore my question
it may be simple but i really need answers
thanks for everyone helped and helping me
Re: Create DataBase in oracle 10g XE [message #239112 is a reply to message #239039] Mon, 21 May 2007 09:08 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
there is only one Alias database which is 'HR'
HR is not DATABASE NAME it is SCHEMA/USER name or you can create your own schema/user.



how can i create a new database ??

You cann't create more than one database in ORACLE XE... when you install oracle XE it will create detault database name XE you can use that database.


do i must be online on the internet to work
as i think it create a session for me on the internet
and how can i work local??


You can work offline with ORACLE XE database.


where is the sql plus
I saw something like the command prompt


You can check >>> start ---> program ----> Oracle XE ---> SQL COMMAND PROMPT

http://st-curriculum.oracle.com/tutorial/DBXETutorial/index.htm
http://www.oracle.com/technology/products/database/xe/pdf/dbxe_faq.pdf


Hope this helps
Taj
Re: Create DataBase in oracle 10g XE [message #239353 is a reply to message #239039] Tue, 22 May 2007 02:04 Go to previous messageGo to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

Thanks alot for your reply

but i also want
if i can use a developer tool beside it
or it contain its developer (there is a tool of application builder but it is different from the developer that i usually work on it)
do i need to install oracle developer 10g




and also
how can i work offline??
i saw that when i login i must open a browser 
to connect and also to run the application and build an application 
Re: Create DataBase in oracle 10g XE [message #345723 is a reply to message #239353] Thu, 04 September 2008 10:51 Go to previous message
jainebri
Messages: 1
Registered: September 2008
Junior Member
Hi.

The following link explain how to create a new database(different from default databes called XE) in Oracle XE.

http://devtime.blogspot.com/2006/01/creating-oracle-xe-database-manually.html

It works out because I have to create a new database to project I'm working for...

I hope it help...

Regards,

Jaider.
Previous Topic: Adding New Targets to Grid Control
Next Topic: disable gather stats job
Goto Forum:
  


Current Time: Sun Aug 31 04:07:50 CDT 2014

Total time taken to generate the page: 0.12563 seconds