Oracle

My colleague added a field to a table in the test database, prompting ORA-00054, resource busy. The table object lock is not released. Use the following SQL statement to check the locking status of related objects in the system: View plain/*

My colleague said that the query encountered a strange problem. Two tables did not return results after performing the not in operation. Normally, there should be returned results. I. Problem ReproductionIn general, the reproduction of the problem

1. Use the expdp command to back up data on the 11g Server Expdp userid = 'sys/cuc2009 @ cuc as sysdba 'schemas = sybj directory = DATA_PUMP_DIR dumpfile = aa. dmp logfile = aa. log version = 10.2.0.1.0 The red text is rewritten as needed. For

> IntroductionIn daily development, Oracle stored procedures are used to handle the case that multiple cursors are returned. The following describes how to use the Jorm framework to handle this situation. > Database preparation1. TableCreate table

Archive logs record database operation records, which are the basis for data recovery. If the archive mode is enabled for the database, a large number of archive logs will be generated. Of course, if there is an RMAN backup, logs that have been

1. Create Create table emp(Empno number (4) constraint EMP_pk primary key,Ename varchar2 (9 ),Job varchar2 (9 ),Mgr number (4 ),Hiredate date,Sal number (7,2 ),Comm number (7, 2 ),Deptno number (2) constraint EMP_PK_DEPTNO references DEPT (deptno));

    The alert file is located in the directory specified by the BACKGROUND_DUMP_DEST parameter and is named alert _ . log. In addition, after 11 GB, the warning file also generates an xml version, which is located in the directory specified by

  When PL/SQL developer is used to develop oracle stored procedures, a very confusing problem is that the stored procedures can be compiled after compilation, that is, there are errors after compilation, there is a small Red Cross in the name of

  Oracle 10g installation documentation OS: rhel5.4 Author: Lvan Date: 2011/10/29 After reading many documents, I will summarize them after installation. It should be useful for beginners.   1. Check the installation environment Binutils

  Segments are the database objects that occupy the storage space. Each object that occupies the storage space is stored in a segment, such as tables, indexes, and rollback segments. Segment type 1) Table segment 2) table partition or

  Learning must follow the gradual rules. Otherwise, you will find that learning is getting harder and harder, because the previous basics do not understand.   You must learn how to create tables in basic oracle learning. But before creating a table,

Complex query of a single Oracle table select avg(sal),max(sal),deptnofrom empgroupby deptno;   select avg(sal),max(sal),deptnofrom empgroupby deptnohavingavg(sal)>2000orderby deptno;   Query employees whose salaries are higher than 500 or whose

ORACLE cursor Traversal -- Created on 2011-10-9 by HUCHANGKUN declare -- Local variables here CURSOR C_EVENT is select t. eventname from T_Event t; temp T_Event.EVENTNAME % TYPE; begin -- for traversal cursor for temp in C_EVENT Loop dbms_output.put_

ORACLE query exercise emp employee table (empno employee No./ename employee name/job work/mgr superior No./hiredate employment date/sal salary/comm Commission/deptno Department No) dept Department table (deptno Department No./dname Department

Use the runcluvfy. sh scriptOracle officially recommends that you run this script before installing oracle grid to check whether each node meets the official requirements for grid installation: if it is your own test environment, some 'unpassed 'can

Oracle procedure trigger small example oracleproceduretrigger SQL code -- create or replace procedure p_update_dept (l_remarker in number, -- 0 increment, 1 Delete, 2. Change l_deptno in number, l_dname in varchar2, l_loc in varchar2, l_result out

Oracle database 10g falshback knowledge1. Knowledge reserve 1) when the media is damaged (such as the loss of data files), any flash back method is useless and can only perform standard backup, restoration, and recovery. 2. SCN record method [SQL]

Solving CRS-4639: cocould not contact Oracle High Availability Services When starting the asm instance, the following error is reported: [grid @ b1 ~] $ Sqlplus/as sysasmSQL * Plus: Release 11.2.0.1.0 Production on Thu Sep 12 18:14:13 2013 Copyright

After oracle modifies the character set, the database cannot be started to solve the recently modified character set experiment. The tragedy is that the database cannot be started after the modification. SQL> alter system set nls_language =

DBA classic interview questions (2) iii. backup and recovery class ======================================== ========================================================== ===== 1: backup classification logical backup: exp/imp physical backup: RMAN