Hi! 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).
+1
A:
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.
Pascal Thivent
2009-10-11 18:15:35
A:
Creating a new database is easiest with the web frontend. Look inside the start menu for oracle.
tangens
2009-10-11 18:23:54
A:
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.
Guru
2009-10-12 10:13:34
+3
A:
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.
Mac
2009-10-12 12:30:15
I may be wrong but I think that the limitation is actually that you can only run one instance at a time. See http://devtime.blogspot.com/2006/01/creating-oracle-xe-database-manually.html
Pascal Thivent
2009-10-12 12:47:29
That's right : my phrasing was misleading.
Mac
2009-10-12 13:57:21