Re: Newbie question. Help!

1. You can query v$database or v$parameter views to see which databse you are connected to. select name,value from v$parameter where name like '%name%' will give you the database name. Also ,

select * from user_users view;

 will be helful to you

2) If you running under Windows then you should see the registry

B>>>F>>>>S

Hartono Nugroho <hanugroNOSPAM_at_ibm.net> wrote in message news:37a44471_at_news1.us.ibm.net...
>Hi all,
>
>I am a university student learning Oracle using Oracle 8i. I am used to
>using PC databases such as Access and become confused with Oracle. I have
>few questions regarding Oracle database system.
>
>1. How can I specify a table that I created to go to specific database? I
>got few databases in the computer. I am usually logged in using
>Internal/Oracle to create a table. Yet I don't have any idea which
database
>that I actually used at that time.
>
>2. Is there anyway to erase database and service completely from my
system?
>I deleted a databases recently and would like to create a new one with the
>same SID, however Oracle won't let me even though I already deleted the
>database and the service.
>
>
>Thanks in advance for all your help.
>Hartono
>
>
Received on Sun Aug 01 1999 - 21:01:31 CDT