oracle commands

Tags: network services Super SQL script Pool parameter strong file Ora hangOne, sys users and system usersThe Oracle installation automatically generates SYS users and system users(1), sys user is superuser, has the highest privileges, has the SYSDBA role, has the rights to create database, the user's default password is Change_on_install(2), the system user is the management operator, the authority is also very large. With the Sysoper role, without t

One, sys users and system usersThe Oracle installation automatically generates SYS users and system users(1), sys user is superuser, has the highest privileges, has the SYSDBA role, has the rights to create database, the user's default password is Change_on_install(2), the system user is the management operator, the authority is also very large. With the Sysoper role, without the CREATE DATABASE permission, the default password is the manager(3), gene

/backup/rman/***.log ' unavailable Change Backupset Delete--Remove backup set 16 (sync Delete)Delete Expired backupset (Archivelog all); --Delete invalid Delete Expired--Deleting a failed backupDelete obsolete--delete backups older than the backup policy date (expired) --Recovery checkRestore database validate;Validate Backupset 218; Restore Database preview;Restore tablespace users preview;Restore datafile 5 Preview; --Command blockrun{2> shutdown immediate;3> startup Mount;4> Allocate channel

Label:One, sys users and system usersThe Oracle installation automatically generates SYS users and system users(1), sys user is superuser, has the highest privileges, has the SYSDBA role, has the rights to create database, the user's default password is Change_on_install(2), the system user is the management operator, the authority is also very large. With the Sysoper role, without the CREATE DATABASE permission, the default password is the manager(3)

Label:1. Start the Oracle database:To switch to an Oracle User:[Email protected] ~]# su-oracleEntering the Sqlplus environment, the Nolog parameter indicates no login:[Email protected] ~]$ Sqlplus/nologLog in in Administrator mode:[Email protected] ~]$ Sqlplus/as SYSDBASql*plus:release 11.2.0.3.0 Production on Fri Apr 17 10:13:07 2015Copyright (c) 1982, Oracle. A

Sqlplus is a common development tool for Oracle databases. Common commands in sqlplus are as follows. 1. Connection command (1). Conn [ect] Usage: conn username/password @ network service name [as sysdba/sysoper]. When connecting with a privileged user identity, you must include as sysdba or as sysoper. (2). Disc [onnect] Note: This command is used to disconnect from the current database. (3). psssw [ord]No

; --Implementing Audit Capabilities Create Tableinfo (Infomationvarchar2( $) ); --all the information of the failed Students Insert Info table Create or Replace TriggerCH afterUpdate onSt forEach rowbegin if: New.math - or: New.english - Then Insert intoInfoValues(: New.math||','||: New.english); End if; End; --data Backup and synchronization (shown here) --Create a backup table Create TableSt_copy as Select * fromtest1; Create or Replace TriggerSTD AfterUpdate ontest1 forEach rowb

Oracle First chapter: Log Management 1.forcing Log Switches sql> alter system switch logfile; 2.forcing checkpoints Sql> alter system checkpoint; 3.adding Online Redo Log groups sql> ALTER DATABASE Add logfile [Group 4] Sql> ('/disk3/log4a.rdo ', '/disk4/log4b.rdo ') size 1m; 4.adding Online Redo Log Members sql> ALTER DATABASE Add logfile Member Sql> '/disk3/log1b.rdo ' to group 1, Sql> '/disk4/log2b.rdo ' to group 2; 5.changes the name of the on

For comparison of some simple commands of Oracle and mysql, refer to [group chart] Comparison of some simple commands of Oracle and mysql. Oracle mysql vs. Personal Oracle7 Release 7.3.4.0.0 mysql 3.22.34-ware-debug startup screen Default installation directory C: ORAWIN9

This article mainly describes the Oracle-related commands commonly used in shell programming. 1. Sqlplus-l/-s ParametersSqlplus-l user/-S User/password #-s to set silent mode, commonly used2. Set related commandsset timing on #显示SQL语句的运行时间. The default value is off. Can be used for performance analysis of SQL execution efficiency. Set autotrace on #允许对执行的SQL进行分析set trimout on # Remove trailing spaces per li

Ext.: http://database.51cto.com/art/200910/158576.htmIn the daily work of the DBA, the operations that are unlocked for the Oracle user are often encountered, and this article gives an operation method for unlocking the Oracle user under the command line, which can be accomplished with a few simple unlocking statements. Here are the specific procedures:The default Scott user is locked out and can be logged

Chapter 1: Log Management 1. forcing log switches SQL> alter system switch logfile; 2. forcing checkpoints SQL> alter system checkpoint; 3. adding online redo log groups SQL> alter database add logfile [group 4] SQL> ('/disk3/log4a. rdo', '/disk4/log4b. rdo') size 1 m; 4. adding online redo log members SQL> alter database add logfile member SQL> '/disk3/log1b. rdo' to group 1, SQL> '/disk4/log2b. rdo' to group 2; 5. changes the name of the online redo logfile SQL> alter database rename file 'C:

Chapter 1: Log Management 1. Forcing log Switches SQL> alter system switch logfile; 2. Forcing checkpoints SQL> alter system checkpoint; 3. Adding online redo log groups SQL> alter database add logfile [Group 4] SQL> ('/disk3/log4a. rdo', '/disk4/log4b. rdo') size 1 m; 4. Adding online redo log members SQL> alter database add logfile Member SQL> '/disk3/log1b. rdo' to group 1, SQL> '/disk4/log2b. rdo' to group 2; 5. Changes the name of the online redo logfile SQL> al

Source: http://blog.csdn.net/zhrzhl/article/details/24020319 1. ORACLE SID View Settings View SID, User name $ env|grep SID, select * from V$instance, select Instance_name,host_name from V$instance; View all users and user status of the database:Sql> select Usernames,account_status from Dba_users; Set SID $ Export ORACLE_SID=HISVHFS View database dbid:Sql>select * from V$dbid 2, query, set the Oracle databa

Common dump commands in Oracle for future reference. 1. Memory Dumps 1). Global AreaAlter session set events 'immediate trace name global_area level n ';1 Including PGA2 contains SGA4 include UGA8 contains indrect memory 2). Library CacheAlter session set events 'immediate trace name library_cache level n ';1. library cache statistics2 contains hash table histogram3 include object handle4 contains the obje

Spool outputs all the output on the screen to the specified file-- Spool file path name; spool G: \ mysql. SQL; -- business operation -- end output spool off; Execute an SQL script fileWe can save multiple SQL statements in a text file, so that when we want to execute all the SQL statements in this file, we can use any of the following commands, which is similar to batch processing in DOS. -- Start file_name -- @ file_namestart G: \ mysql. SQL; @ g: \

Common ORACLE commands 1. How can I view all tables in the database? Select * from sys. user_tables; 2. How to connect to a database Sqlplus/nolog; conn sys/oracle as sysdba; 3. How to start a database Startup; 4. view the ORACLE instance Structure Desc V $ instance; 5. view User's default and temporary tables

tablespace_name[Account Lock/unlock]Grant connect to user_name;Grant CREATE table to Suer_name;Grant update on TABLE_NAME to user_name;Revoke CREATE table from user_name;Revoke update on TABLE_NAME from USER_NAME; What are the usual ways to view current users in Oracle? (Hint: Show user and SELECT * from user_users) show User;/select username from User_users; What is your understanding of the role and what are the common roles?A role is a set of pe

Oracle learning notes-command and Function Command www.2cto.com usage format Description Example DescDesc table name display table structure Desc bk_bookinfoSet lineSet line n Set the screen output to n characters wide Set line 100LL display SQL Buffer the content www.2cto.com LNN textN is the statement row number in the SQL Buffer. Text is used to replace the error SQL statement 2 from studentinfo // The statement that runs the SQL Buffer/nn uses the

Brief Introduction of oracle imp and exp commands for data migration, especially migration between different versions and between different systems, can be completed using exp/imp. Of course, we recommend that you use expdp/impdp to import and export data. Next, let's briefly talk about the basic operations of exp and imp. 1. Export the entire database, import a, and confirm the character set of the databas