Oracle

I think everyone is familiar with the use of the alter database open resetlogs command of ORACLE_RESETLOGS command. Have you ever wondered why this resetlogs option should be used? When will it be used? What is its mechanism? What are their roles?

Oracle uses Sequence and triggers to automatically increase IDs. Many companies use Oracle databases and require automatic increase of IDs. However, there is no ready-made method to use auto_increatment like SQL Server. Under www.2cto.com, I wrote a

PL/SQL Chinese display is displayed as "?" Problem encountered: Chinese Characters in PLSQL are garbled, and if the SQL statement contains Chinese characters, an error is reported during execution. In fact, the system cannot recognize Chinese

Oracle entry to master Part 3-query 2 Table query (2) www.2cto.com using logical operation symbols problem: Query employees whose salary is higher than 500 or whose position is MANAGER, at the same time, must their first letter of name be uppercase

The process executes DDL statements to prompt ORA-01031 errors [SQL] -- create test user create user hat identified by hat default tablespace doldolphin; www.2cto.com -- grant permissions grant connect, resource to hat; -- view the role permissions

In linux, emca re-build EM in oracle. If you change the machine name, you can re-create EM. Generally, you do not need to re-configure emca to re-create EM [oracle @ dev ~]. $ Cd/u01/app/oracle/product/11.2.0/dbhome_1/bin www.2cto.com recreate an EM

Empdp/impdp after 10 Gb of ORACLE needs to export the database on the server to the local for testing. One of them has a large amount of data and does not need to be exported. Currently, exp/imp cannot be used to import or export some tables.

Common rman backup and recovery commands SQL code Oracle official documentation contains a complete description of the rman command, we can refer. The following are examples of commonly used commands: www.2cto.com common Rman commands: 1. RMAN

A Method of dynamically initializing numbers often needs to initialize some data, and some regular numbers need to be filled according to the actual situation, such as fixed length and several parts, the most common example is the first digit,

Transaction locks in Oracle (locked tables and locked sessions) Today I learned another trick to view the transaction locks caused by abnormal session exits in Oracle Database: 1. view the locked table SELECT B. owner, B. object_name,. session_id,.

Explain the following example of an Oracle execution plan: www.2cto.com [html] SQL> explain plan for 2 select. name, B. name 3 from t1 a, t2 B 4 where. id = B. id 5 and. id = '1'; Explained. SQL> set lines 200 SQL> set pagesize 0 SQL> select * from

Oracle is really difficult to uninstall .... 1. Choose "start"> "Settings"> "Control Panel"> "Administrative Tools"> "services" to stop all Oracle services. 2. Start-> Program-> Oracle-OraHome81-> Oracle Installation Products-> Universal Installer,

To establish logical standby, you must first establish physical standby. The process of establishing physical standby is omitted. The main process of the logical DB at www.2cto.com is reader (read redo entries) ---> prepare (generate LCR) --->

Analysis of OCP question _ 043: flashback logs to flash back to the database, oracle needs to record the before image of the data block to a new log. This log is named flashback database logs flash back log, and Flash Back log is always recycled,

To reduce the redo size of Oracle, use lab instructions www.2cto.com 1. In non-archive mode: [SQL] SQL> archive log list database log mode automatic archiving in non-archive mode disable archiving end point USE_DB_RECOVERY_FILE_DEST oldest online

Golden Gate entry guide: Install the installation environment of this experiment: www.2cto.com OS → Red Hat Enterprize Linux 5.4 DB → Oracle 10g GG → ogg112101_fbo_ggs_Linux_x86_ora10g_32bit note that if the database version is different, Golden

Precautions for oracle Import and Export: The oracle Import and Export solution is the main melody of backup and reply, not dba. There is not much research on data import and export, and there is only a little bit of experience in the use process,

Description by Source when the Oracle client is garbled, the developer will inevitably re-build the database environment when deploying a new runtime environment. However, I found that when many colleagues execute the database creation script, the

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,

Oracle unconventional recovery (skip archiving with BBED) I. BBED tool 1. the BBED package is missing in oracle 11g installation of bbed, oracle11g bbed install and example 1. upload (sbbdpt. o ssbbded. o bbedus. msb, which copies the linux64