Database Administrator

Oracle deletes a shell script instance for a tablespace Shell script code for Oracle tablespace Deletion #! /Bin/bash# Ocpyang@126.com# Drop tablespace If [$ #-ne 1]; thenEcho "Usage: $0 TABLESPACE_NAME"Exit 1Fi # Configure oracle env: about oracle

Memory_target for Oracle initialization parameters I. Introduction: Oracle 9i introduces pga_aggregate_target to automatically adjust the PGA; Oracle 10 Gb introduces sga_target to automatically adjust SGA; Oracle 11g combines these two parts and

MySQL multi-log table result set splicing Stored Procedure Generally, MySQL logs only record the log information of the current day. If you need to view the log information within January, You Need To splice the result set of the daily log table,

Oracle configuration file Introduction Profile file or. bash_profile file (system-level environment variable file:/home/Oracle ); Oratab file (oracle self-run file:/etc/oratab ); InitSID. ora or spfileSID. ora file (database instance initialization

Oracle implements function-based indexing Use Cases:When a query runs slowly. By checking the where clause, it is found that the SQL lower function is applied to a column, and the lower function prevents the use of existing indexes on the column.

Rman database recovery; key/non-key files, image copies, control files, restore points, non-archive, incremental, new databases, catastrophic replies, and rman copies Perform full recovery: the system's key data files are lost in ARCHIVELOG mode: If

Oracle Database Review 2. Oracle Database ReviewSubquery and table connection1. query the names of the people who make the most moneySELECT ename, sal FROM empWHERE sal = (select max (sal) FROM emp );②. Query the employees whose salaries are above

What Does oracle do when data files are offline ?, Offlineoracle SQL> oradebug setmypidStatement processed.SQL> oradebug unlimitStatement processed.SQL> oradebug event 10046 trace name context forever, level 12;Statement processed.SQL> alter

The Oracle judgment value is not a number, and the Oracle judgment value is a number Select * from product_info t where t. contract_detailid is not nulland length (translate (t. contract_detailid ,'-. 0123456789 '| t. contract_detailid ,'-. 01234567

Create a temporary table in oracle and create a temporary table in oracleThe transaction is automatically cleared after the transaction is committed, and data is isolated between different transactions.Create global temporary table

How to Use cetos-5.5 to build a forum, cetos-5.5 to build a forum Lab environment centos-5.5 Lab Software Package Yum install-y zlibc gd * pcre * freetype * libpcap * libxml2 * libpng * perl-DBI * gcc * Gcc-c ++ * libtool * fontconfig *

Db4o officially stops supporting and object-oriented databases. I tried db4o some time ago. I really felt good, But I searched for it in China and did not find any special forum or object-oriented database products, I am deeply aware that this is

ORACLE compilation failure object, oracle compilation failureInvalid ORACLE compilation objectsThere are many reasons for database object invalidation:1: when the structure of the referenced object is changed, the dependent object will be changed to

Manually compile the. fmb file. pll file, and manually compile the. fmb. pll file.Compile compile manually compile the fmb file:Frmcmp userid = user/pwd @ db module = xxx. fmb batch = no module_type = form compile_all = yesCompile the mmb

Some Useful GoldenGate Commands, goldenw.commands 1. History Use History to view previously executed commands GGSCI (ogg1) 5> history GGSCI Command History 1: infoa2: inf3: info all4: show all5: history 2 ,! Use! You can run the last command

Practice: Create shell scripts and oracleshell scripts for oracle users #! /Bin/bash # ocpyang@126.com # create userif [$ #-ne 4]; then echo-e "\ e [1; 32 m ************************************** **************************************** * ** \ e [0

Expdp ora-31640, ora-19505Oracle @ db01:/oraapp/oracle/backup> impdp \ '/as sysdba \' directory = DB_BACKUP dumpfile = newdb.20140918.dmp logfile = newdb_0919.log parallel = 4 c>Import: Release 11.2.0.3.0-Production on Fri Sep 19 11:27:12

Considerations on keys outside of database design and database design There is no uniform standard for the use of foreign keys in the industry. The focus of the debate is data consistency and performance. Supports the use of foreign keysIt is

Chapter 2 User Authentication, Authorization, and Security (11): fixed the logon ing error in the restored database, authenticationSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for

Fine-grained audit using DBMS_FGA and fine-grained audit using dbms_fga Experiment: fine-grained audit using DBMS_FGA 1. Create a test tableTEST_USR1 @ PROD1> create table audit_test (x number ); Table created. 2. Create an Audit PolicyTEST_USR1 @