CODEWITHSUNDEEP
sqloracle-databaseoracle10g
user188036
user188036

Reputation:

Get Started with Oracle Express Edition?

I'm novice in oracle.I'm using oracle express 10.2.0 but i don't know how to create my own database and where my database is created.(The path of my new database).

Upvotes: 2

Views: 746

Answers (4)

Mac
Mac

Reputation: 8339

Not to be confused : in Oracle terminology, a database instance (called XE) is automatically created during installation (limitation : there can be only one database instance running at a time in Oracle Express).

What other vendors usually call a database (like in Sql Server) is a Schema in Oracle. To create one, use the CREATE USER command (and not the CREATE SCHEMA command : welcome to the marvelous world of Oracle !), using SQL*Plus or APEX.

Upvotes: 3

Pascal Thivent
Pascal Thivent

Reputation: 570615

I think it's possible to create a database schema through the web administration interface. Check the Getting Started Guide from the Oracle Database 10g Express Edition.

For the path to the files, this article may help: Creating an Oracle (XE) database manually on XP.

Upvotes: 1

Guru
Guru

Reputation: 2371

Oracle 10g XE comes with the integrated browser interface. You can access it from http://machine-name:port/xe

It is almost similar to Oracle Enterprise manager. You can also try using Oracle Application Express on it, and develop web applications.

Upvotes: 0

tangens
tangens

Reputation: 39753

Creating a new database is easiest with the web frontend. Look inside the start menu for oracle.

Upvotes: 0

Related Questions