oracle dba commands

Oracle 11G 64-bit automatic restart and shutdown commands in RHEL (Red Hat Enterprise Linux, the same below) 5.5 64-bit: Log On As an oracle user and enter: VI/etc/init. d/Oracle On the Edit page, add the following content: (assume that the Oracle main directory is/u01

in (select group_numberFrom v $ asm_diskgroupWhere name = 'orcl _ data1 '); Path----------------------------------Orcl: vol1Orcl: vol2 Start/stop a RAC cluster Make sure that you log on with an oracle UNIX user. We will run all the commands from the Rac1 node: # Su-Oracle $ Hostname Rac1 Stop Oracle

[Oracle] Some Common commands in RAC (1) Node layer: Olsnodes -N: displays the number of each node. [Oracle @ rac1 ~] # Olsnodes-n Rac1 1 Rac2 2 2 -P: displays the name of the network interface used by each node for private interconnect. [Oracle @ rac1 ~] # Olsnodes-p Rac1 rac1-priv Rac2 rac2-priv -I: displays the VIP

onset serveroutput on #设置允许显示输出类似DBMS_ Outputset Verify of #可以关闭和打开提示确认信息old 1 and new 1 display.Show All #显示当前所有参数情况3. Save SQL Execution ResultsMethod One: Use the spool commandSqlplus-s/As Sysdba EOF echo off; 0 ; Max ; Spool temp.txt; Select username from dba_users; Spool off; ExiteofMethod Two: Using redirectionEcho "set echo off;">>${operate_sql}Echo "set pagesize 0;">>${operate_sql}Echo "set linesize;">>${operate_sql}Echo "select username from dba_users;">>${operate_sql}Echo

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 defaul

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

Tags: view select usage of file pac ble toe dba file---view tablespace name and file location: Select Tablespace_name, file_id, File_name,round (bytes/(1024*1024), 0) Total_space from Dba_data_ Files ORDER BY Tablespace_name ---How to see if the Oracle Tablespace is automatically expanded (increment_by is the block number "8192byte/block") Select file_name,tablespace_name,bytes/1024/1024 "Bytes MB", autoext

--==cmd Console ==----== Daily User Management sql==----Connect to Sqlplus>sqlplus/nolog--Connect as DBASql>conn/as SYSDBA--Modify the user password to modify the system user's password to systemSql>alter user system identified by "system"--Connecting Sql>connPlease enter user name: SystemEnter Password:--Query All usersSql>select * from User_users;Sql>select * from All_users;--Delete the user clsp and all tables below itSql>drop user CLSP Cascade--Create users and give

Label:Recently in the use of Oracle, often to import export data, commands are simple, but often forget, so write down. Drop UserYfplssCascade;--log on to the system user to delete the existing user name and everything under that user is deleted. --CREATE TABLE Space Createtablespace yfplss Logging datafile'd:/app/administrator/oradata/oral/yfplss.dbf'--address of the storage table spaceSize 100m--sizeAuto

Delete deletes a large table. It is not released between time and space. It is very slow because it occupies a large amount of system resources and supports rollback. The space is also occupied by this table.Truncate table Name (tablespace is released when table records are deleted)DML statement:Table-level shared locks: they do not affect each other when operating different records in a table.Row-level exclusive lock: oracle only allows one user to m

Delete deletes a large table. It is not released between time and space. It is very slow because it occupies a large amount of system resources and supports rollback. The space is also occupied by this table. Truncate table Name (tablespace is released when table records are deleted) DML statement:Table-level shared locks: they do not affect each other when operating different records in a table. Row-level exclusive lock: oracle only allows one user

Data Base Oracle Common commands1. Login: (no password required, administrator rights)Conn/as SYSDBA2. View the database storage location:Select name from v$datafile; 3. Create TABLE spaces:Syntax:create tablespace tablespace name datafile ' data file path ' size; Example:create tablespace test_db datafile ' D:\ORACLE\ORADATA\ORCL\test_db.dbf ' size 3000m; 4. Create a User:Syntax:create user username ide

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

This article details the use of ORACLE commands to create databases and table spaces on the command line 1, the use of Super User login Sqlplus. 2, create the table space: sql> Create tablespace Test 2 datafile ' D:\oracle\oradata\test\test.dbf ' 3 size 100M autoextend on next 10M maxsize unlimited extent management local; 3. Create User and Password: Sql>

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

The DELETE statement deletes a row from the table each time, and saves the DELETE operation of the row as a transaction record in the log for rollback. TR The DELETE statement deletes a row from the table each time, and saves the DELETE operation of the row as a transaction record in the log for rollback. TR First, let's talk about the truncate command:Syntax: truncate table;The data in the table is cleared and the storage space is released.After the task is run, the task is automatically s