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

Thread: setting sid on sqlplus

  1. #1
    Join Date
    Aug 2002
    Posts
    40

    Arrow setting sid on sqlplus

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

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    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