Common commands and functions of Oracle SQL * plus, oracleplus
Common commands and functions in Oracle are sorted out for future use for convenient reference.Common commands:
Connect to sqlplusRun cmd in the command line to enter. For example, to log on in sys mode, the comm
If you are puzzled by common Oracle backup commands in actual operations, you can use the following articles to understand the actual application and functions, the following is a detailed introduction of the article. I hope you will gain some benefits after browsing the following content.
Oracle Summary of common backup comm
= "American_america" in the. Bash_profile in the/home/oracle and/root user directories.
UTF8 "statement to close the current SSH window.
Drop tablespace ts_data including contents and datafiles; Create tablespace ts_data logging datafile ' D:\tablespace\TS_DATA.dbf ' size 50m autoextend on next 50m maxsize 20480
m extent management local;
Drop user User1 cascade;
Create user user1 identified by 123456 default Tablespace ts_data;
Grant Connect,r
One, Oracle trace FileOracle trace files are grouped into three categories:
One is the background alarm log file that records the activity of the background process during startup, shutdown, and running of the database , such as table space creation, rollback segment creation, some alter commands, log switches, error messages, and so on. When a database fails, the file should be viewed first, but the infor
Today, a strange problem has been found that the SRVCTL and Crs_start commands cannot start an Oracle RAC instance, but with Sqlplus it can start normally. The final reason for this is that the state of the database becomes disable in OCR, and this state is changed to enable after it returns to normal. The following is a simulation example: [emailprotected]:~ $> crs_stat-tname Type Target State Host--------
NY TABLE, ALTER any PROCEDURE, drop no table, drop any VIEW, drop all INDEX, drop any PROCEDURE, SELECT any tabl E, INSERT any table, UPDATE any table, DELETE any table to maindb Grant DBA to Maindb; Imp maindb/[email protected] full=y file= ' e:/ycsy/data/maindbdata20150428.dmp ' ignore=y log = ' e:/ycsy/data/maindbdata20150428.log ' ============================ Completion of Import Database command end =====================Long-use commands for ful
Oracle in Oracle 8i, there is often a situation in which you want to run operating system commands in a stored procedure. Typically, you can do this by using Oracle Enterprise Manager to set up jobs. However, due to the lack of flexibility of the OEM in setting up the job, The parameters of the set are fixed. In practi
the "orcl_data1" disk group
SELECT Path
From V$asm_disk
WHERE group_number in (select Group_number
From V$asm_diskgroup
where name = ' orcl_data1 ');
PATH
----------------------------------
Orcl:vol1
Orcl:vol2
14. Start/Stop RAC cluster
Make sure that you are logged on as an Oracle UNIX user. We will run all commands from the RAC1 node:
# su–oracle
The following articles mainly describe the Oracle rman command. The main content of the following articles is a collection of Oracle rman commands found in an online warfare with good reputation: THE list command lists the backup information in the control file and Oracle RMAN recovery directory.
Is one of the most int
Oracle SQL * plus is a client tool that interacts with oracle. In SQL * plus, you can run the SQL * plus command and the SQL * plus statement. The DML, DDL, and DCL statements we usually call are SQL * plus statements. After they are executed, they can be stored in a memory area called sqlbuffer, you can only save one of the most recently executed SQL statements.
Oracle
.clear screenClear Screen2), File Operation command1.start and @Description: Run SQL scriptCase: sql>@ d:\a.sql or Sql>start d:\a.sql2.editDescription: The command can edit the specified SQL scriptCase: Sql>edit D:\a.sql, this will open the D:\a.sql file.3.spoolNote: This command can output the contents of the Sql*plus screen to the specified file.Case: Sql>spool d:\b.sql and input sql>spool offegSql>spool D:\b.sql;Sql>select * from EMP;Sql>spool off;3), interactive commands1.Note: You can overr
Common Oracle commands-log management
1. view log filesSyntax: select Member from V $ logfile
1. Forcing log SwitchesSQL> alter system switch logfile;
2. Forcing checkpointsSQL> alter system checkpoint;
3. Adding online redo log groupsSQL> alter database add logfile [Group 4]SQL> ('/disk3/log4a. rdo', '/disk4/log4b. rdo') size 1 m;
4. Adding online redo log membersSQL> alter database add logfile M
Create an Oracle 11g database using commands
This document describes how to create an Oracle database that complies with the OFA specification using the create database Command of the Oracle database.
1. Set the environment variable (vi. bash_profile or save it as an executable file for creation)
ORACLE_BASE =/u01/app
Common Oracle backup commands, oraclebackup
1. Set the backup tag
1. backup database tag = 'full _ bak1 ';
Note: Each tag must be unique. The same tag can be used for multiple backups to restore only the latest backups.
2. Set the backup set size (all results of one backup set are regarded as a backup set. Pay attention to the backup set size)
Backup database maxsetsize = 100 m tag = 'datafile1 ';
Note: ma
How to run Oracle commands in SUSE Linux:Suid/guid:Non-Oracle users are required to run oracle commands such as sqlplus.
Solution:If you want to set s u I d, set the one before the corresponding permission bit to 4; if you want to set g u I d, set the one before the corresp
1. su-Oracle is not required. It is suitable for use without a DBA password. You do not need a password to enter the sqlplus interface.2. sqlplus/nolog, sqlplus system/manager, or./sqlplus system/manager @ ora9i;3. SQL> connect/as sysdba; (as sysoper) orConnect internal/oracle as sysdba; (scott/tiger)Conn sys/change_on_install as sysdba;4. SQL> startup; start the database instance5. view all current databas
SQL Introduction SQL supports the following categories of commands: 1. Data definition Language (DDL) 2. Data Manipulation Language (DML) 3. Transaction Control Language (TCL) 4. Data Control Language (DCL) Here are the detailed notes for these four SQL languages: Oracle learning note Three SQL life Order (ii): SQL Action Language category when you create a table for an
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.