Re: Personal Oracle7

Hi,

Local database connection string: 2:
Default SID name for Personal Oracle: ORCL Default database name = oracle (defined in %oracle_home%\database\initxxxx.ora, xxxx = orcl in this case)

you can query db_name in sql*plus:
SQL> select * from global_name;

GLOBAL_NAME

ORACLE.WORLD You don't need to type connection string in LOGON screen for local database. If you'd like type '2:'

Regards

Hakan

N.D. Nguti wrote:

> Dear Sirs,
> I am trying to find my way around developer/2000 using Personal Oracle7 as
> DBMS. However, I am curious as to the name of the 'local' or 'default'
> database in the dbms and dev/2000 documentation.
>
> When you request access to the database it gives you the option to specify
> the name of the database in addition to username/password. What is the name
> of the default database that comes with Personal Oracle7? I am still able to
> log into the database[blank field for databasename]
> and do all I want to but it is a slight irritation
> that I do not know the name of the database and cannot find it so far!!!
>
> Thanks for you help.
>
> Don NGUTI
>
> --
> Nde D. Nguti, Dept of Physics, Keele University
> Keele - Staffs ST5 5BG England
> TEL: (W) +44 1782 583319 Tel/Fax (h) "can't recall"
> email: n.d.nguti_at_phys.keele.ac.uk
Received on Mon Aug 10 1998 - 16:39:26 CDT