Re: Oracle on Windows

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.
>
> 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?
>
>
> Thanks

you can use sqlplus connect to database ,then desc table_name,you will see the table's structure.

you can use DBCA remove the new created database or you can use oradim commandline tool Received on Sat Aug 12 2006 - 08:49:22 CDT