SQLPLUS login through the command line environment

SQLPLUS login through the command line environment in the following ways:
A:
SQLPLUS SYS / PASSWORD AS SYSDBA to SYS user login, must be developed SYSDBA login as an administrator.
II:
SQLPLUS SYSTEM / PASSWORD. Of course, other users can login.
III:
SQLPLUS NOLOG by the command, follow the prompts, enter the user name, user password to log SQLPLUS environment.
  • del.icio.us
  • StumbleUpon
  • Digg
  • TwitThis
  • Mixx
  • Technorati
  • Facebook
  • NewsVine
  • Reddit
  • Google
  • LinkedIn
  • YahooMyWeb

Related Posts of SQLPLUS login through the command line environment

  • Shoubashoujiao you write a batch

    Batch Introduction Extension is a bat (in the nt/2000/xp/2003 can also be under the cmd) file is a batch file. Editor's note ======================================= ==== willsort . bat is a dos batch file under the . cmd is the nt kernel command line

  • Java for beginners JDK command-line environment path problem

    Screen appears: Exception in thread "main" java.lang.NoClassDefFoundError: C: \ JavaTest \ Hello hello.class obvious why CLASS is not in because in the CLASSPATH 1, SET CLASSPATH =,,,, 2, JAVA-CLASSPATH C: \,,, JDK will be with the spaces C: \ J

  • Changes caused by an accident oracle startup error

    The oracle client windows2003r2 loaded it but I never thought sga small, less than 100M, thoughts, and linux should be able to lower the tone, like bigger, it changed the 7G, did not think restart database after database also can not login: prompt OR ...

  • CentOS5.3 install Oracle11g (Photo) (6)

    Database after installation is complete, create a database operation First of all configuration netca This is oracle 11g new features View the process is complete ps-ef | grep / fantlam can see the listener is already running up Took configure dbca (note

  • Modify the SGA size of the actual

    Install oracle 10g r2 in the database, the default SGA size of 584M, a lot of space in the implementation of complex SQL calculations or calculation time, often share_pool can not be assigned a problem in the Internet looking for some information, th ...

  • Oracle study notes 1 - Basic knowledge

    Current mainstream database: Microsoft: sql server and access Sweden MySql: AB Company mysql IBM Corporation: DB2, Sybase, the United States: Sybase IBM Corporation: informix United States oracle Company: oracle For oracle jobs that demand is quite b ...

  • Oracle Backup and Recovery (2)

    My test steps: 1 Export: will export the entire database file backup - The system user identity of the user to export all the tables lee, export table for the C: \ exp.dmp Be a little test: - The result is 10010 The following is an example of the use ...

  • Oracle XE to solve the number of users allowed to connect the problem of inadequate

    In the database server to run sqlplus system / password @ xe (which is a database user without changing the system; password is the database password should be specified as the actual password; xe is the database instance name), and: alter system set ...

  • Using ActiveRecord from Rails

    ActiveRecord is by far the best I have seen the ORM library, apart from DB2, supports all the mainstream databases. If you want to know how to use a separate Activerecord, please follow me. Introduce my system environment: OS: windows2003 DataBase: O ...

  • 2010.03.12 - jdbc Use

    2010.03.12 - jdbc use today to write the bulk export of data to use to jdbc, on the familiar look 1. Jdbc six steps 2. A jdbcutil config.properties

blog comments powered by Disqus
Recent
Recent Entries
Tag Cloud
Random Entries