Re: Oracle on Windows

From: Martin T. <bilbothebagginsbab5_at_freenet.de>
Date: 8 Aug 2006 23:38:47 -0700
Message-ID: <1155105527.524557.30800@75g2000cwc.googlegroups.com>

Uri Dimant wrote:
> Hello
>
> Oracle 10g on Windows XP SP2 Pro
>
> I have just intalled Oracle 10g and as I understood it created a database
> ORCL by default
>
> My question is how can I get the table's structure, make a query within
> Oracle for Windows Assistance ( like a Enterprise Manager in SQL Server)
> I mean I have connected to the database ,however could not see the
> tables/views.
>

Your start menu entry for Oracle should contain a bunch of entries ... In 9i2 there was the Enterprise manager Console ... in 10XE there's a http-interface -- I guess 10g will have some administration interface?

Also take a look at:
http://www.oracle.com/technology/products/database/sql_developer/index.html

> Another question is , I created a new database by using DAC and it created
> three services on my computer , so if I have 1000 databases , will I see
> 1000*3 =3000 services? How can I delete/remove the new created database?
>

9i2 Created 9 Services on this box here - 3 of which are actually running. :-)

For 1000 Database instances there would be more like 2+1000 processes on windows.

There is a concepts manual PLUS a windows specific manual for this friggin' complex product. Better read it. (just go to their HP, you can read it online or download the PDFs)

best,
Martin Received on Wed Aug 09 2006 - 01:38:47 CDT