Get Started with Oracle Express Edition?

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

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.

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.

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

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.