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/*

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

Recently, when inserting data, I encountered the BUG of "ORA-01461: Can only assign values to the LOGN values of the inserted LOGN columns ". The data type in oracle is varchar2 (4000 byte). The inserted data cannot exceed 4000. Changes to varchar2 (

1 Overview (In a session) when the transaction starts: When the database encounters the first DML (UPDATE/INSERT/DELETE/MERGE) statement. (In a session) when the transaction ends: the transaction ends at the first COMMIT/ROLLBACK/DDL/GRANT/REVOKE.

Insert multiple tables.Most insert operations are for a single table. However, oracle supports insert statements for multiple tables. In terms of data warehouse extraction, transfer and loading (ETL, Extract Transform and Load) routines, you will

We know that Oracle 10 Gb introduces the recyclebin concept. When we delete a table without specifying purge, the system only renames the table to the name starting with BIN $, modify related data in the data dictionary.In the Administrator's Guide,

The customer requested that the historical data in the database of the two projects on the current network be cleaned up recently, so he sorted out the section usage in the next application, mainly to view the table section. The script used is as

TRANSLATE ('Char ', 'From _ string', 'to _ string ')       The return value of TRANSLATE replaces each character in from_string with the string after the corresponding character in to_string. TRANSLATE Is a superset of the functions provided by

  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

  Oracle 11.2.0.3 impdp error:   Gg2:/u01/backup> impdp dave/dave directory = backup dumpfile = pdba. dmp logfile = table. log tables = pdba table_exists_action = replace;   Import: Release 11.2.0.3.0-Production onWed Nov 16 12:35:19

If you do not enable index monitor, you can determine whether the index has been used. If you want to know whether an index has been used, the traditional method is to enable index monitor. However, this method has two shortcomings: (1) it will

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 replaces a specific string keyword in clob: replace, dbms_lob.instr Step 1: Determine whether clob contains a specific string: for example, "/admin/ewebeditor/uploadfile/" Keyword: dbms_lob.20.code: [SQL] select st. id, st. content from

Oracle's X $ table series-X $ KSMSP has the following meanings: [K] ernal [S] torage [M] emory Management [S] GA Hea [P] each row represents a chunk in the shared pool. Let's take a look at the structure of x $ ksmsp.: SQL> desc x$ksmsp Name

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

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]

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,

Oracle functions and triggers today write about Oracle functions and triggers, define and use stored procedures, functions, and triggers in the database, this improves the efficiency of database access. The database functions include declaration,

A brief description of oracle expdp impdp using the Data Pump expdp. impdp can import and export data on the server side, which is highly efficient without setting the environment variable NLS_LANG, by default, the database will go to the character