oracle dba commands

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 submitted, including other uncommitted sessions. Once the task is cleared, the task cannot be rolled back.Only the table creator or other users (such as DBA) with the permission to delete any table can clear the table.Truncate table dept30;Table truncated. The following

--first create a temporary tablespace createtemporarytablespacetest_temptempfile ' path ' size32mautoextend onnext32mmaxsize2048mextendmanagementlocal;--Creating Tablespace Createtablespace test_dataloggingdata ' path ' size32mautoextendonnext32mmaxsize2048mextend managementlocal;--create user, allocate table space createtusertestidentifiedby ' 123456 ' defaulttablespacetest_datatemporarytabletablespacetest_temp;--User Authorization grant createview,resource,

/group_4.266.685491921 Name---------------------------+ Rac_disk/novadb/tempfile/temp.263.685491617 12 rows selected. SQL> All ASM disks belonging to the "rac_disk" disk group SQL> select path from V $ asm_disk where group_number in (select group_number from V $ asm_diskgroup where name = 'rac _ disk '); Path---------------------------/Dev/raw/raw3/Dev/raw/raw4Orcl: nova3 Start/stop a RAC cluster Make sure that you log on with an oracle UNIX user. We

I collected a summary of Common commands used to execute scripts in oracle databases, hoping to help you. 1. Execute an SQL script file The Code is as follows: Copy code Sqlplus user/pass @ servicename OrSQL> start file_namesOrSQL> @ file_name We 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

Common maintenance commands for Oracle 10g RAC: status of all instances and services [oracle @ vzwc1 ~] $ Srvctl status database-d zwc Instance zwc1 is running on node vzwc1 Instance zwc2 is running on node vzwc2 status of a single Instance [oracle @ vzwc1 ~] $ Srvctl status instance-d zwc-I zwc1 Instance zwc1 is runni

autoextend on next 5 M maxsize 2048M; #增加数据文件方式且允许自动增长sql> ALTER DATABASE datafile '/HOME/ORACLE/TABLESPACE.DBF ' autoextend on next 5M maxsize 2048M; #允许已存在的数据文件自动扩展sql> ALTER DATABASE datafile '/HOME/ORACLE/TABLESPACE.DBF ' resize 2048M; # Change the current data file size#调整临时表空间文件sql> Alter tablespace temp add tempfile '/home/oracle/temp2.dbf ' size 2048M; #

Trimspool on set Linesize a set pagesize set newpage 1 set heading off set term Off spool path + filename Select col1| | ', ' | | col2| | ', ' | | col3| | ', ' | | col4| | '. ' FROM TableName; Spool off With some basic commands 1. Get database name and date created Copy Code code as follows: SELECT name, created, Log_mode, open_mode from V$database; 2, the Oracle databa

Create/delete Table spaces Created: Create tablespace USERS datafile '/oracle/oradata/mytest/tsuser.dbf ' size 500M autoextend on next 10M maxsize unlimite d extent management local; Delete: Drop tablespace USERS including CONTENTS and datafiles;2. Create/delete usersCreate User ERIC identified by Password Default tablespace USERS; You can also do this without specifying a table space, and you can authorize drop user Eric Cascadegrant Connect,resour

. dmp schemas = ScottImpdp system/manager directory = dump_dir dumpfile = schema. dmp schemas = Scott remap_schema = SCOTT: System3. Import the tablespaceImpdp system/manager directory = dump_dir dumpfile = tablespace. dmp tablespaces = user014. Import the databaseImpdp system/manager directory = dump_dir dumpfile = full. dmp full = y There are two scenarios for the features of our system1. the username and tablespace of the imported database are the same as those of the exported database. For e

tiger 1 input C: \ sqlplus/nolog in Dos 2. Log On As A DBA connsys/passwordassysdba; 3 unlock alteruserscottaccountunlock; 4. A dialog box is displayed to change the password. Conn scott/tiger SQL> conn sys/sysAsSysdba; Connected. SQL>AlterUserScott account unlock; UserAltered. SQL>Commit; CommitComplete. SQL> conn scott/tiger // enter the new password and confirm the password. OK PasswordChanged Connected.

Common commands in Oracle Oracle 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

1. log on to Oracle AS A DBA A: Start Oracle services. B: Run cmd to open the command window. C: Enter "sqlplus sys/root as sysdba" in the command line. The root is the logon password. In this way, you can successfully log on to Oracle. 2. query all usernames in the Or