Re: what's my DB name?

Hi Anand:

    In your case, just do a: select * from global_name; You will get the full service name.
I hate smart-ass, hot-shit answers like, "you should be able to ask your DBA".

• blacky

> > Hi,
> >
> > I've a fundamental question. If I am connecting to a remote server in
> > Oracle 8i as a non-DBA user then how can I find out the actual name of
> > database?
> >
> > Few options that I already know are:
> >
> > - viewing init.ora file: not applicable in my case as I am
> > connecting to remote server
> >
> > - i have following info: username, pwd and hoststring..... problem
> > with me is that there may be 'n' no. of users connecting to same db,
> > so i can not interpret dbname by username. Further, normally
> > hoststring is of the format dbName.hostName but this is no compulsion,
> > so I am not sure whether this will be database name or not?
> >
> > - using query: select value from v$parameter where name =
> > 'db_name'; but this query is of no use if I don't have privilege to
> > view any system table........
> >
> > So, is there any other way? Please do tell....
> >
> > Regards,
> > Anand
>
>
> There is someone called a "DBA", who is the single most important
> person when it comes to accessing a database. You should redirect this
> post to your DBA to give you proper access to data dictionary view/s
> to extract this value.
>
> /Rauf Sarwar
Received on Mon Sep 30 2002 - 17:52:44 CEST