Clever Geek Handbook

Start with Oracle Express Edition?

I am new to oracle. I am using oracle express 10.2.0 but I don’t know how to create my own database and where my database is created (path to my new database).

+2


source to share


4 answers


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



What other vendors commonly refer to as a database (like on Sql Server) is Schema in Oracle. To create it, use the command CREATE USER

(not CREATE SCHEMA

: welcome to the amazing world of Oracle!) Using SQL * Plus or APEX.

+3


source


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



For file paths, this article might help: Create an Oracle Database (XE) manually on XP .

+1


source


Creating a new database is easiest with the web interface. Go to the launch menu for the oracle. In the meantime, there is no need to know about it. ”

0


source


Oracle 10g XE comes with a built-in browser interface. You can access it withhttp://machine-name:port/xe

It almost looks like an Oracle Enterprise manager. You can also use Oracle Application Express and develop web applications.

0


source






More articles:


All Articles