Oracle

  Create table xcp as (select * from B _za_bzdzkxx ); Select * from xcp; Select count (1) from xcp; -- 22001 Select count (1) from xcp t where t. dzbh like '20140901'; -- 510521% Delete from xcp t where t. dzbh like '20140901 '; Select count (1)

  In December 2, I deleted the database by mistake. The boss was so upset that I would recover the database within 30 minutes. In a hurry, I wrote a stored procedure, this method is applicable when the table is deleted on the day of restoration

Author: runming 2012-2-1 QQ: 226399587 http://blog.csdn.net/runming918 Difference between Purge and drop:The new flashback drop feature provided by Oracle 10g provides the flashback drop feature to speed up recovery of user error operations. In

Oracle OER 7451 in Load Indicator: Error Code = OSD-04500: illegal option specified descriptionOperating System: win7 64-bitOracle: 11gR2 32-bit However, the following errors occur continuously in the alert log:Mon Feb 06 14:38:22 2012Oer7451 in

The output of this command shows that the duplicate command of Oracle RMAN is executed internally and has a deeper understanding of cloning.For demonstration of the previous steps, see:Http://andylhz2009.blog.51cto.com/728703/771481 C: \ oracle \

1. Introduction to shared pool: The location, parts, and functions of the Shared Pool; Ii. Set and view the shared pool size: In 9i, we use the Shared_pool_size parameter to set the size of the Shared Pool. Let's talk about the setting in 10 Gb. In 9

PrefaceRecently, the company's technology and R & D have been asking me about how to set memory parameters to optimize oracle performance. So I took the time to sort out this document for reference. Purpose We hope to organize this document to give

1. Create oracle users and tablespaces in Windows-- Create a data table spaceCreate tablespace oras_data -- Name of the tablespaceLoggingDatafile 'd: \ oracle \ product \ 10.1.0 \ oradata \ oras_data.dbf '-- storage of the tablespace file spaceSize 3

I used the amdu tool a few days ago to restore a database of oracle 11 GB for the customer. Later I carefully searched for the information and found that the tool can be used on 10 Gb, but I need to install it myself. After the OCR disk of ASM is

The following error is reported when running sqlplus in cmd in win7.SP2-1503: Unable to initialize Oracle call interfaceSP2-1503: Unable to initialize Oracle tuning SP2-0152Solution:Right-click sqlplus.exe In the oracle \ product \ 10.2.0 \ db_2 \

-- Common oracle system tables/*Start with dba .....Dba_users database user informationDba_segments table segment informationDba_extents data zone informationDba_objects database object informationDba_tablespaces database tablespace

SQL/PLUS Run CommandAppend text;Replace text Change/old text/new textDELETE command DEL n --- Delete rowDelete buffer clear buffer -- delete all contents of the BUFFERAdd a statement INPUT textDisplay the content in the buffer LIST [n/LAST] list

# Log on to the Database Host using an oracle user (ssh or telnet)$ Ssh oracle @ Database Host IP# Log on to the database as sysdba$ Sqlplus "/as sysdba"SQL * Plus: Release 10.2.0.4.0-Production on Mon Oct 10 15:53:45 2011Copyright (c) 1982,200 7,

The deduplication technology can provide a larger backup capacity for longer data retention, continuous verification of backup data, improve the level of data recovery services, and facilitate data disaster tolerance. Duplicate data may be in the

Restrictions on oracle user logon failures"FAILED_LOGIN_ATTEMPTS" is used to configure the maximum number of consecutive password input errors. If this value is exceeded, the account is locked. 1. Run the following command to query the value of

Scenario: Concurrent request A reduces inventory items not submitted query inventory not changed request B first judge whether inventory is sufficient A not submitted, inventory is sufficient and execution is also set up to reduce inventory. in fact,

After the tablespace is deleted, the total number of "ORA-01219" errors reported after oracle is restarted is resolved as follows:1. running input: sqlplus/nolog 2. log On as sysdba with the "connect sys/password" as sysdba 3. run alter database

Sort BY Chinese pinyin initials and obtain the Chinese pinyin initials. Introduction: sort BY Chinese Initials, strokes, and radicals. [NLSSORT]: 1) SELECT * FROM T_TABLE order by nlssort (NAME, 'nls _ SORT = SCHINESE_PINYIN_M '); 2) SELECT * FROM T_

Sometimes Oracle databases cannot use indexes. There are many reasons for this phenomenon. How can we locate it? This article mainly introduces this part.First, determine the optimization mode in which the database runs. The corresponding parameter

Create or replace trigger emp -- before indicates the trigger before the operation -- after indicates the trigger after the operation -- up to 12 triggers can be created for each table -- before inset www.2cto.com -- before insert for each row --