Monday, May 3, 2010

Getting started with Oracle XE (oracle database express edition)

Once you install the product, you have a database created with name XE.

Go to C:\oraclexe\app\oracle\product\10.2.0\server\BIN and run sqlplus
connect as system (pw admin presumably)

You can do: connect system as sysdba
and startup and shutdown the DB.

these commands will give you the installed DB:

select * from global_name;
select name from v$database;

No comments: