Oracle

Environment: Oracle10g, Red Hat 4, Oracle running in archive mode. Simulation Scenario: The user01.dbf data file is corrupted, and the database recovery is disabled. Procedure: 1. perform a full-database cold backup to back up control files, data

ORACLE was originally designed to be transaction-based, so it won't be authentic in terms of processing analyticdb. Recent developments in ORACLE related technologies have gradually adapted to OLAP needs.1 partition technology 2 compression

Using oracle control files to store large amounts of data into the database is much more efficient than SQL script files.A m data file, the ctl file is stored in about 20 mins, and the SQL script file takes about 2 hours. To use the ctl control file,

SQL> connect user name/Password 02 (successful, the connection is displayed .) 03 04/****** modify the http service port ******/ 05 SQL> call dbms_xdb.cfg_update (updateXML (dbms_xdb.get _get (),

The user status changes to the resignation status, the system configuration table is triggered, and the configuration table status is modified.Create or replace trigger BASEDB_USERLEFTBefore update or delete on basedb_usersFor each rowDeclare--

  SQL * LOADER is a data loading tool for ORACLE. It is usually used to migrate operating system files to ORACLE databases.   SQL * LOADER is large data Repository selection method, because it provides the fastest way (DIRECT, PARALLEL ). Now, let's

  Every time an Oracle database is started, it goes through a series of steps to ensure Database Consistency.   When a database is started, it goes through three modes: NOMOUNT, MOUNT, and OPEN.   Startup nomount option: (read the initialization

  Where can I start learning about Oracle? Here, I will take you to the door of Oracle. One chapter a day, seven days of entry is not a dream.     1. Synonyms   1.1 Solution The solution is a collection of database objects. To distinguish each set,

  Output query content to text Set echo off pagesize 0 heading off feedback off termout off Spool test. SQL Select count (*) from user_tables; Spool off   After the preceding script is executed, the query content is output to test. SQL.   The set

Simple query of a single Oracle table View the table structure desc emp; query all columns Select * from emp; find the Department number (query the specified column) select deptnofrom emp; find the Department numbers with different numbers

DBA Note: SQL _TRACE is a background news publishing system used to track and diagnose cases. The main performance problem is that it is extremely slow to access news pages through connections, which usually takes more than 10 seconds to return,

Oracle up/down keys prompt history when Oracle in linux is used, its up/down keys by default do not prompt historical records. Therefore, we need to install an additional package, this package can achieve this function 1: Install readline (usually

Oracle full backup 1. export epmssit database backup; exp system/sysadmin @ hnepms file = d: \ datas \ epmssit_bak20100401.dmp owner = epmssit2. create epmsprd users and tablespaces; sqlplus "/as sysdba" create tablespace epmsprd datafile 'd: \

Oracle table common query Experiment (2) Common query experiment of Oracle table (1) http://www.bkjia.com/database/201309/242198.html 1. query the total names of all employees, SAL and COMM. Select ename, sal + nvl (comm, 0) "sal-and-comm" from emp;

Note: SID-Database ID HOME_NAME-oracle Home Name, such as OraHome92 and OraHome81 (1) OracleServiceSID Database Service, this service automatically starts and stops the database. If a database is installed, its default start type is automatic. The

Solve the paging error caused by inconsistent sorting fields using rownum in oracle. Recently, when I wrote a list component ulynlist, I detected a problem and recorded it here. Today, when I called the list component, I tried to lower the number of

A shallow summary of oracle log miner Sometimes, we shocould recover one or more rows data which is deleted carelessly by users, but it is not necessary to recover the whole db and the flashback does not recovery the data because it's timeout. for

In this example, we will shorten the downtime during Oracle database migration and use the export/import method to perform the steps for fast application database migration, we do not focus much on the detailed steps of export/import or database

When dbms_stats Imports and Exports table statistics in SQL tuning, incorrect or outdated statistics result in incorrect execution plans being used. Of course, in this case, we can collect the latest statistics to achieve the goal of optimization.

ORA-00314, redolog corruption, or loss of processing method alertsid. log error message: Fri Sep 27 15:18:39 2013Started redo scanFri Sep 27 15:18:39 2013Errors in file /oracle/admin/lixora/udump/lixora_ora_23439.trc:ORA-00314: log 2 of thread 1,