sqlplus example

********************* * Method 1: Simple connection. network configuration is not required. It is actually a tnsname. ora file, but only Oracle10g or above is supported.Command: sqlplus user name/password @ IP Address [: Port]/SERVICE_NAME [as sysdba]Example: sqlplus sys/pwd @ IP: 1521/test as sysdbaNote: You can omit the input when using the default port 1521.

Oracle startup error sqlplus/nolog Error [Oracle @ www.bkjia.com bin] $ sqlplus/nolog Sqlplus: error while loading shared libraries:/u01/oracle/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied An error occurred while executing the program in Linux: cannot restore segment prot after reloc: Permission denied It turns out this is a gho

Through the SQL plus spool function, we output the daily O M results of the database to the log file, and sometimes it needs to be output regularly to avoid repeated log file names, the output log file name can be dynamically named. This article provides an example for your reference. 1. Generate a dynamic Log File Script robin@SZDB:~> more dynamic_logfile_name.sql--+ ================================================================+ --| Filename:dyn

After installing Oracle on the Linux,unix operating system, use the Sqlplus '/as sysdba ' command to log in to the Oracle database as SYSDBA, which has some security implications, The operating system administrator can also log Oracle users to the Oracle database, do some sysdba the same thing, and then think, can not cancel this method of operating system authentication, and use Oracle username and password authentication, after searching documents,

Help is not in sqlplus after the manual build, and the following records how to install and delete the help command in Sqlplus. Note: The Sqlplus help command is available only when the database is open. Non-open state use help also error: Sp2-0171:help system not available. The experiment is as follows: Note: The ORACLE 11.2.0.4 Environment Experiment SYSDBA a

Tags: BMS manual example Redolog max user plus a list of Sch viewsI. Startup and shutdown of Oracle1, in a single-machine environment2, in the dual-machine environmentIi. What kinds of startup methods are available for Oracle database?1, startup Nomount non-installation start, this way startup executable: Rebuild the control file, rebuild the database2, startup Mount DBName installation starts, this way start under executable: Database log archive, da

Several cases of sqlplus and shell passing value to each otherScenario One: The simplest invocation of sqlplus in the shell$cat test.sh#!/bin/shSqlplus Oracle/[email Protected]>file.log SELECT * from Test;ExitEOF #注意EOF要顶格写$sh test.sh$cat File.log--Omit a number of system prompt information-------Sql>EMPNO EmpName SAL DEPTNO-----------------------------10002 Frank Naude 500 2010001 Scott Tiger 1000 40--Omit

Label:Although Sqlplus is the most common Oracle Client tool used by DBAs, it is not very good at output formatting, such as broken lines, poor paging, and so on, so generally start sqlplus after a few settings, such as Linesize, pagesize and so on.Common commands set linesize, pagesize,Set row size in Sqlplus Sql> Set Linesize 32767 Set Page size in

commands startupnomount alterdatabasemount alterdatabaseopen 5. startup restrict Constraint-based startup This method can start the database, but only allow access by users with certain privileges When a non-authorized user accesses the service, the following prompt is displayed: ERROR: ORA-01035: Oracle only allows users with restricted session Permissions 6. startup force Forced start method: bitsCN.com China Network Management Alliance When the database cannot be closed, you

Today, a new task is required to create a batch file for the customer to maintain the database. It is said that the management tool using access2003 was too slow. This time, the maintained SQL file is directly written into a package and then called with sqlplus. It should be executed soon. However, users do not know much about the database, and a batch processing file can be executed simply by inputting one or two conditions. First, write a title outp

BYS @ bys1> set arraysize 200BYS @ bys1> set autotrace traceonly statBYS @ bys1> select * from test2 order by 3;72465 rows selected.Elapsed: 00:00:00. 57Statistics----------------------------------------------------------1 recursive cballs0 db block gets1037 consistent gets0 physical reads0 redo size2909118 bytes sent via SQL * Net to client4401 bytes encoded ed via SQL * Net from client364 SQL * Net roundtrips to/from client1 sorts (memory)0 sorts (disk)72465 rows processed

] | Wor[d_wrapped] | Tru[ncated] Here's an example: sql> COLUMN SAL ALIAS Salary FORMAT $99,990.90 We've specified Sal. An alias and a digital display format for this column, and the following display shows the effect of the setting. Figure 1 Tips on Format: ¨ a variety of text settings, with A[n] to represent, n represents the length of the display. Then the display length of this text column is in the width of N characters, if the content is

Oracle sqlplus login. SQL settings, sqlpluslogin. SQL Sqlplus automatically runs two scripts at startup: glogin. SQL and login. SQL. The execution order is 1. The glogin. SQL file is searched for and executed in the $ ORACLE_HOME/sqlplus/admin path by default. 2. By default, the login. SQL file is searched in the current path for execution. If the corresponding f

Sqlplus automatically runs two scripts at startup: Glogin.sql, login.sql these two files The order of execution is 1. Default to find Glogin.sql file execution under $oracle_home/sqlplus/admin path 2. Default in the current path to find Login.sql file execution, if not found the corresponding file is executed 3 3. Determine whether to set the SQLPATH environment variable, if the variable is set to find

Original works, allow reprint, please be sure to use hyperlinks in the form of the original source of the article, author information and this statement. Otherwise, the legal liability will be investigated. http://nbmonster.blog.51cto.com/1977736/665767Several cases of sqlplus and shell passing value to each otherScenario One: The simplest invocation of sqlplus in the shell$cat test.sh#!/bin/shSqlplus Oracl

1. Oracle startup and Shutdown1. In a single-host environmentTo start or shut down the Oracle system, you must first switch to the Oracle user, as shown below:Su-Oracle A. Start the Oracle SystemOracle> svrmgrlSvrmgr> connect internalSvrmgr> startupSvrmgr> quit B. Disable the Oracle system.Oracle> svrmgrlSvrmgr> connect internalSvrmgr> ShutdownSvrmgr> quit Run the following command to start the Oracle9i database:$ Sqlplus/nolog SQL * Plus: Release 9.2

1. Oracle startup and Shutdown1. to enable or disable the Oracle System in a single-host environment, you must first switch to the Oracle user, as shown below:Su-Oracle A. Start the Oracle SystemOracle> svrmgrlSvrmgr> connect internalSvrmgr> startupSvrmgr> quit B. Disable the Oracle system.Oracle> svrmgrlSvrmgr> connect internalSvrmgr> ShutdownSvrmgr> quit Run the following command to start the Oracle9i database:$ Sqlplus/nolog SQL * Plus: Rel

: SQL spool a SQL spool is spooled to a.lst SQL spool off SQL spool not currently spooled exit exit sqlplus Desc Table name Displays the structure of the table Show user displays the currently Connected users Show error shows errors Show all Show all system variable values Edit to open the default editor, the default is Notepad.exe in the Windows system, the last SQL statement in the buffer into the Afiedt.buf file for editing Edit file

1, first you have to install the Oracle database server and client software, in the installation process to be aware of, select the Oracle installation directory, remember not to use the Chinese directory or a directory with spaces.：Http://hi.baidu.com/dashuaiwang/blog/item/42f8e7fab96978d6b58f314b.html/cmtid/d5bba9190dd0904a42a9ad772, after the installation, you will be prompted to remember something. That is, some URLs, which is also important. Here is the information for my Oracle tips:Enterp

title of each reportBtitle26. Write a commentRemark [text]27. output the specified information or an empty row to the screen.Prompt [text]28. Pause the execution process and wait for the user to respond.Pause [text]SQL> pause adjust paper and press return to continue.29. copy some data from a database to another database (for example, copy data from one table to another)Copy {from database | to database | from database to database}{Append | create |