Home » Other » Client Tools » Connect as SYSTEM (Oracle 10g)
Connect as SYSTEM [message #407209] Tue, 09 June 2009 02:05 Go to next message
satish_j
Messages: 35
Registered: June 2009
Location: Mumbai,India
Member
A big Hi to all..iam a new member to this forum searching for some answers to my queries..
I have just installed Ora10g on my system(XP)and need to know how to connect to server using SYSTEM id through sqlplus.Actually,i need to know what possible ways are there to connect to server..

One such way is the SQLPlus GUI screen which asks for username,password and Host.I can connect to scott account through this,but not system or sys account.
Also,on this GUI screen,there is no Database option..so how does it connect to server??
I know that sysdba or sysoper rights are needed for sys or sysdba accounts,but how to use them??
also,Iam a newbie to oracle world,so can u suggest some good ebook(should focus on 10g) for it.
Re: Connect as SYSTEM [message #407214 is a reply to message #407209] Tue, 09 June 2009 02:28 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
All the documentation in s on Tahiti. Very Happy

Central search page : http://tahiti.oracle.com/

Version 10.2 Documentation : http://www.oracle.com/pls/db102/homepage
Re: Connect as SYSTEM [message #407215 is a reply to message #407209] Tue, 09 June 2009 02:29 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
.I can connect to scott account through this,but not system or sys account.

No difference for SYSTEM (but the password).

Quote:
Iam a newbie to oracle world,so can u suggest some good ebook(should focus on 10g) for it.

All documentation is on http://tahiti.oracle.com

You can start with those in http://www.oracle.com/pls/db102/portal.portal_db?selected=1
and
SQL*PlusĀ® User's Guide and Reference

Regards
Michel

[Updated on: Tue, 09 June 2009 02:29]

Report message to a moderator

Previous Topic: NLS_DATE_FORMAT
Next Topic: Column headers displayed to full length despite using substr
Goto Forum:
  


Current Time: Thu Mar 28 13:51:19 CDT 2024