DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002

    default database in 8i

    How can i view the default database in Oracle 8i enterprise edition on my computer from the SQL prompt?? Or do i have to go to the DOS prompt?


  2. #2
    Join Date
    May 2002
    What do you mean by "default" database? Do you mean the seed or starter database that is created during installation, or one that is the "default" because you have ORACLE_SID set as a user or system variable?

    If you have ORACLE_SID set, at a DOS prompt, you can enter
    "echo %ORACLE_SID%" and that will tell you what your "default" database is.

    To see the names of instances that may be running, you can look at services (look for OracleServiceDBNAME, where DBNAME is the all-uppercase name of your SID, or database).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width