OraFAQ Forum: Client Tools » Connect as SYSTEM

Home » Other » Client Tools » Connect as SYSTEM (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connect as SYSTEM [message #407209]

Tue, 09 June 2009 02:05

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.

Report message to a moderator

Re: Connect as SYSTEM [message #407214 is a reply to message #407209]

Tue, 09 June 2009 02:28

ThomasG
Messages: 3212
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

Report message to a moderator

Re: Connect as SYSTEM [message #407215 is a reply to message #407209]

Tue, 09 June 2009 02:29

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 02:39:47 CST 2025