[Oracle]sqlplus Start parameter description# su-oracle [Grid]Usage 1:sqlplus-h | -V-H[ELP]:Displays the syntax and usage of the Sql*plus command, and then returns control to the operating system.-v[ersion]:Displays the version number of the Sql*plus,
Use SQL * Plus to connect to the database and sqlplus to connect to the database
About SQL * Plus
SQL * Plus is the primary command-line interface to your Oracle database. you use SQL * Plus to start up and shut down the database, set database
Sqlplus provides many common commands. The following describes how to use them.
1-> sqlplus login and exit
Sqlplus-H |-v-H displays the version and help information of sqlplus, and-V displays the login Syntax of its version information:
Is :
Databases in the production environment cannot directly use development tools (such as toad and PL/SQL developer) to connect and perform data operations, because they have strict permission control (for DB security considerations ), the only tool
Oracle Note (ii) sqlplus commandFor Oracle database operations, the command line is used primarily, and all commands are done using sqlplus, and there are two forms for sqlplus.
One is the sqlplus:sqlplus.exe of DOS style;
The other is
Data replication between Oracle databases-the COPY command in SQLPlus can replicate data between different Oracle databases and replicate data in the same database, its performance is the same as that of import/export. Schematic diagram: According
I. 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
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>
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>
The ㈠ command line uses sqlplus syntax to explore.
Serial number
Command line
Examples of usage
①
Sqlplus
> Sqlplus
Ii
sqlplus [option]
> sqlplus-l
③
Sqlplus [
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.