Oracle

Oracle automatically backs up and deletes the previous backup file for batch processing. I found some information from the Internet, sorted out oracle's automatic backup batch processing, and saved the following code. bat can be used together with

Oracle autotrace parameter description SQL> set autotrace traceonly explainSP2-0613: unable to verify PLAN_TABLE format or entity SP2-0611: Error resolution when enabling EXPLAIN Report: www.2cto.com 1. log on to CONNECT/@ as SYSDBA as a SYS user; 1.

After the oracle database is detached, delete the original SID Implementation Method: 1. Start-> Settings-> Control Panel-> Administrative Tools-> stop all Oracle services. 2. Start-> Program-> Oracle-OraHome81-> Oracle Installation Products->

One-point discovery of ORACLE indexes (Requirements for indexes for different table join statements)Two different table join statements are written: (the same effect) www.2cto.com select * from T_FORM_ELEMENT t join t_form_resources t1 on t1.meta _

Decompress the cpio file and decompress the cpio file cpio-idmv [file | device] Back up data to a file or device to restore: cpio-icduv

Oracle stored procedures with input and output parameters Return Affected rows SQL % ROWCOUNT [SQL] CREATE OR REPLACE PROCEDURE PROC_UPDATE_TEMP (P_DAYS IN NUMBER, -- execution days P_ROWS OUT VARCHAR2, -- returns the NUMBER of affected rows

Oracle inspection tool: RDA introduction (I) download RDA and decompress it: http://up.2cto.com/2013/0323/20130323110229534.rar [Plain] [oracle @ localhost vmshare] $ gunzip pull [oracle @ localhost vmshare] $ tar-xf rda_41_12.16.1-051205.tar

Enable the Database flash back function-to close the Database, you need to open the Database to the mount State to enable the flash back function: SQL> shutdown immediate Database closed. database dismounted. ORACLE instance shut down. SQL> show

Background of index creation for some rows: if the data distribution of one column in a table is uneven, most of the data is 1, and a small part is 0, and the data that we often query is exactly 0, in this case, full table scan is a waste of

Undo tablespace role and ora-01555 below we through DML operations, from a simple to a deep interpretation of the role of undo tablespace and the generation of ora-01555 errors: 1, when we issue DML statements, update t set col = 'B' where col = 'a';

Oracle High Water level line I. oracle High Water level line I. What is a High Water Mark )? All the oracle segments (segments here, for ease of understanding, we recommend that you use segment as a synonym for the table) have an upper limit to

Arcsde post oracle11g error solution environment: oracle11.2.0.3 and oracle10.2.0.1, Arcsde9.3.1 create an AB instance in oracle11.2.0.3, then use Arcsde9.3.1 post oracle11.2.0.3 to create the sde configuration and report an error during the post

Oracle job is required to regularly execute the project. oracle job is used. I tried it myself and solved some problems. I published the job I wrote and kept a record. begin sys. dbms_job.change (job => 22, what => 'Clare result1 varchar2 (200);

SQL Group by summary for Oracle databasesPrefaceAs mentioned above, grouping Functions Act on a group of records. What can this group of records be generated? ImpossibleThey are all in the form of a whole table. This requires the Group by

RMAN delete expired & delete obsolete read the official documentation for explanation: delete exipired [plain] If you run CROSSCHECK, and if RMAN cannot locate the files, then it updates their records in the RMAN repository to EXPIRED status. you

Pre-fabricated users in oracle are enabledSome ORACLE users are premade and useful, but they are locked during initialization. We need to manually enable it.SQL * Plus: Release 10.2.0.1.0-Production on Tuesday April 9 20:02:02 2013Copyright (c) 1982,

The SQL subquery of the Oracle database is described in the preface, considering this situation: queries which employees have higher salaries than SMITH. To solve these problems, we need to first query the SIMTH salary and then compare the salaries

To use the UTL_FILE class to export multiple files: To export ALL_OBJECTS according to 3000 files, for example, 6001 records, you should export three files, the first and second files are 3000, And the last file should be 1. The following example

A cainiao's oracle road -------- 3. knowledge points learned today include 1. Non-correlated subqueries learn the data environment and syntax of non-correlated subqueries 2. correlated subqueries Compare non-correlated subqueries, GRASP syntax 3,

Setting oracle automatic memory management to enable oracle automatic memory management requires shutdown, restart 1. determine the sga pga memory size: show parameter target 2. determine the maximum pga usage since the database is started: select