setting sid on sqlplus Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: setting sid on sqlplus

  1. #1
    Join Date
    Aug 2002

    Arrow setting sid on sqlplus

    I have to set SID for creating new database on to do that.I already have oracle database on the same computer.This is possible on command line but not on sqlplus.please suggest.

  2. #2
    Join Date
    May 2002
    Can't. You can connect to a different database/SID via SQL*Plus, but you cannot set the ORACLE_SID in a SQL*Plus session. So what may not be obvious to you is this: set ORACLE_SID in the shell window (assuming UNIX), then do sqlplus /nolog, conn / as sysdba, create database, etc.

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