Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 294
  • Last Modified:

How can I connect to a local oracle database?

I just installed Oracle 10g. How can I create a table in a database?

Thanks
0
kosenrufu
Asked:
kosenrufu
  • 3
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
look for a sqlplus icon under the Oracle folder program files in Windows.

or
from a command prompt:
sqlplus

enter a username and password or '/ as sysdba' (without the quote marks).
0
 
kosenrufuAuthor Commented:
I tried entering the username and password I entered when I ran the .exe to install the express edition but getting an error saying invalid username/password; login denied
0
 
slightwv (䄆 Netminder) Commented:
It's been a while since I installed XE.  What specific users?

there is always connecting as 'SYS with: / as sysdba

From there you can reset the other account passwords with alter user commands.
0
 
kosenrufuAuthor Commented:
when I enter / as sysdba i get the message 'nothing in sql buffer to run'
0
 
slightwv (䄆 Netminder) Commented:
sqlplus / as sysdba
or
connect / as sysdba from the SQL prompt.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now