Oracle

Use note amdu to recover from a hard disk fault database is a free tool provided in Oracle 11g. It is used to analyze the metadata of the ASM disk group and extract data files from an unmounted disk group. NOTE: 553639.1 Placeholder for AMDU

Oracle backup recovery overview introduces that backup recovery is an important technology of oracle. Of course, we 'd better not use this technology, just as we do not need to go to the hospital. When you open the database, oracle compares the

In many cases, we need to use alter system kill session to terminate a session in the database and release the resources occupied by the session to solve the problem. For example, daniel's environment often uses the following statement to kill

Oracle datapump expdp/impdp: When importing and exporting data to the database, the hang has been used to solve the problem of being hang when recently exporting schema-level data and has to stop the current export job. If you have similar problems,

How to monitor the current situation of oracle database tables and tablespaces declare unf number; unfb number; fs1 number; fs1b number; fs2 number; fs2b number; fs3 number; fs3b number; fs4 number; fs4b number; full number; fullb number; begin dbms_

Some special characters in ORACLE are oracle wildcards. The use of the operators for where comparison conditions include: equal to: =, , >=, and <> include: in, not in exists, not exists range:... and, not .... and Matching Test: like, not like Null

The aggregate function in Oracle performs computation on a column in a group of rows and returns a single value. The aggregate function ignores NULL values. Aggregate functions are often used together with the group by clause of SELECT statements,

PMON, RECO, and ARCn PMON: processmonitor process Monitoring of oracle 10g processes performs data recovery when the user process is interrupted (abnormal. PMON is responsible for clearing the data buffer pool and releasing resources used by user

Complete notes on learning oracle plsql pl/SQL anonymous block declare -- Declaration part, optional begin -- execution part, required exception -- exception, optional end; -- the required stored procedure create procedure name (which can be written

[Oracle] uses autonomous transactions to implement the audit function. In a transaction (outer transaction), one or several autonomous transactions can be defined. An autonomous transaction can be committed independently without affecting the outer

Oracle materialized view creation report ORA-00942 error solution in Oracle10g Database, a materialized view made a simple Condition Clause modification, delete and re-build, but, it is not created successfully, reported ORA-00942 table or view does

Oracle Skip Locked [html] Oracle Skip Locked Oracle 11g introduces skip locked. Skip Locked is used to Skip the rows that have been Locked by other query select statements in the query select statement, and only execute the rows that can obtain the

The reason why a common user (users Group) cannot log on to oracle is a strange problem recently. In windows 2003, when the Administrator logs on to the system, if you use pl SQL dev to enter the account and password to log on to oracle, you can log

The blob type in the oracle database can be directly converted to varchar2 if there is no data. If you have tried it, you can also change it. However, it is generally only possible to modify the data, which is troublesome and cannot be changed

Delete the field Dropping Columns in a large table delete the field Only with the release of Oracle 8i has it been possible to drop a column from a table. prior to this it was neccessary to drop the entire table and rebuild it. now you can mark a

How to compile invalid objects 1. Find INVALID objects: SELECT object_name, object_type FROM dba_objectsWHERE status = 'invalid'; 2. compile invalid objects: manually COMPILE: alter package pkg1 compile reuse settings; compile with PL/SQL Package:

ORA-00376: file x cannot be read at this time solves the problem of data center power failure before, after restarting the database found a ORA-00376 error. Query the data file status: SQL> select file_id, online_status from dba_data_files order by 1

Oracle performance optimization operation (1) select the most efficient table name sequence (only valid in the rule-based Optimizer ): the ORACLE parser processes the table names in the FROM clause in the order FROM right to left. The table written

Oracle data is transferred from one user to another. export the available command exp, similar to the following exp da1/da1 @ ORCL file = E: \ da1.dmp log = E: \ da1.log da1 is the user name, And the backslash is the password, @ is the database

Set up database links, Count table records, view sessions, and Max sessions. 1. SQL code select 'analyze table' | table_name | 'compute statistics; 'From user_tables where table_name like 'pr \ _ % 'escape '\' and tablespace_name = 'pr _ DATA1 '2.