Oracle

In oracle10g, If you accidentally drop a table, Can you restore it? The answer is yes. In oracle10g, when you run the drop table tablename command, the table will not be deleted, instead, the table is stored in the recycle bin (the recycle bin

Explain several usage and significance of Oracle temporary tables can be said to be a good way to improve database processing performance, when there is no need to store, only stored in the Oracle temporary tablespace. I hope this article will help

Redo log files of storage structure can be divided into online redo log files and archived redo log files. It is the transaction log of a database. The purpose is to restore committed transactions when a failure occurs. Almost every operation you

About solving oracle login: ora-12154: tns: unable to resolve the problem of the specified connection identifier ready May day to start learning oracle, so today I plan to install oracle 10g. After the installation is complete, test whether the job

Oracle autotrace enabling and option description platform: ora 10g, the RHEL-5.8 steps are as follows: 1) sys @ ORCL> @ $ ORACLE_HOME/sqlplus/admin/plustrce. SQL www.2cto.com 2) sys @ ORCL> grant plustrace to public; Description of several common

Oracle SQL Summary 2: Set operator and DML Statement 3. Set operator 3.1 The set operator can only appear before the order by clause. Www.2cto.com 4, DML statement 4.1 SAVEPOINT from ORACLE SQL references Savepoint names must be distinct within a

Using Oracle LogMiner to analyze archived log received an alert email today, resulting in a rapid growth of archived log. Unable to determine the cause of the problem. LogMiner is used to analyze the archived log. The main source and network of the

An in-depth exploration of the oracle rollback mechanism the undo mechanism is a clever feature of oracle and one of the difficulties in learning oracle. Next we will learn more about it internally. Session 1: scott user, initiates a transaction

Recently, we found that the REDUNDANCY policy for retaining 10 Gb RMAN backups has changed compared with 9i. In Oracle9i, the REDUNDANCY value of the backup retention policy refers to the number of Backup REDUNDANCY. That is to say, if REDUNDANCY is

Install oralce 11g full version in centos linuxSystem Environment: CentOS 5.5 64bit Software Version: linux. x64_11gR2_database_1of2 is good. Now you can install: 1. hardware requirement: memory: grep-I memtotal/proc/meminfo officially requires at

In practice, the best practice of oracle password operations is that oracle password operations are implemented through profile, while resources are controlled by resource consumption groups. profile is actually a limitation. Use profile to control

Profile management user password and unlock user use profile Management user Password account lock 1) Lock SQL> create profile lock_account limitfailed_login_attempts 3 password_lock_time 1; ---- create a profile named lock_account, three logon

A Redhat official ORACLE Installation document is displayed two days ago when you set Kernel Parameters in Linux. The modification description of Linux kernel parameters is very clear. Before installing Oracle, in addition to checking whether the

Comparison of insert, copy and insert append operations in oracle is still due to database migration. The execution speed of insert, copy and insert append is tested. Environment: migrate oracle9i to oracle11g, linux system. The table has been

Oracle recursive statement Start with... Connect By clause recursive query is generally used for a table to maintain a tree structure. CREATE example TABLE: create table TBL_TEST (id number, NAME VARCHAR2 (100 BYTE), pid number default 0);

In Oracle8i or a later version, you can create two types of temporary tables: 1. Session-specific TEMPORARY table create global temporary () on commit preserve rows; 2. TEMPORARY table www.2cto.com create global temporary () on commit delete

Oracle multi-table insert all statement: SQL code create table ORDERS (CUSTOMER_ID NUMBER, SUM_ORDERS NUMBER); create table small_customers (CUSTOMER_ID NUMBER, SUM_ORDERS NUMBER ); create table medium_customers (CUSTOMER_ID NUMBER, SUM_ORDERS

Differences between on and where in left join of Oracle databases when two or more tables are connected to return records, an intermediate temporary table is generated, then, return the temporary table to the user. When left jion is used, the on and

The insert SQL statement used to export the joined table in the stored PROCEDURE. To facilitate the data migration of the three associated tables, export the data into an insert SQL statement. By the way, let's take a look at PROCEDURE.Usage TABLE

Oracle 11g table smart monthly partition before the log table more than 7 million data, involved in the log table business query speed is very slow, a month of data query is about 30 seconds, the study found that oracle has a table Partition