Oracle

There is a need to do this in your job: compare the table structure of two tables to see if they are the same, and find out the difference. Compare the data in two tables and find out the difference data?Analysis: Due to the more fields in the table

If you are an architect, in addition to the selection of technology in the database selection, more important may be cost-effective choice, and Oracle is now ranked first in the database, so the price of Oracle is necessary to understand.Several

Haha, just said the last one, idle bored and got a test.Environment:Os:redhat 5.8Db:oracle 10.2.0.5 Raw DeviceWe should develop the habit of often backing up OCR and Votedisk. However, OCR and Votedisk are not backed up and can be rebuilt. Just like

1. Configure an OGG environment with pump on the source side and trail on the target side1.1 Parameter fileExtract process ett parameters:EXTRACT ettUSERID System, PASSWORD OracleExttrail./dirdat/trTABLE Gguser.huangliqiang, where (ID = 100);Data

************************************************************************* * * * Original:blog.csdn.net/clark_xu Xu Changliang's Column************************************************************************The first step is to close the library

Environment:Win7 64bit Ultimate Oracle 11gRequired Software and:Oracle 64bit ClientHttp://www.oracle.com/technetwork/topics/winx64soft-089540.htmlPL/SQL DEVhttp://www.plsqldev.com/Configuring Tnsnames.ora file Instances#tnsnames.

Archive recovery when the database reported the following error:Rman-08591:warning:invalid Archived Log Deletion policyTo view the Ora error explanation:[[email protected] ~]$ oerr rman 85918591,  3,  "Warning: invalid archived log deletion policy"//

--Create sequence Create sequence Innerid minvalue 1 maxvalue 99999999999999 start with 1 increment by 1 cache order;2.--innerid.currval refers to the current sequence--innerid.nextval refers to the next sequenceCREATE TABLE admin (ID varchar2 (),

1 Example of differential increment experiment1.1 Differential Incremental backupTo demonstrate the effect of an incremental backup, we made some changes to the database after performing a 0 level backup.Perform a 1-level differential incremental

Description of the phenomenon:Statistics Server Test No problem, just the last time to configure the system a bit of a problem, so re-install, configuration good Safety strategy (recently on how to configure a new Server , the first time to

Oracle multiple rows to a column, as follows:Select To_char (Wmsys.wm_concat (t.candi_supplier_id)) from PS. T_ps_bu_award_supplier T;With the WMSYS.WM_CONCAT function provided by Oracle 10g, the effect of row to column can be completed.One column

Path-third-party Oracle service providerValueThe main business of traditional third-party Oracle service providers exist, such as system migration, upgrade, fault handling, performance optimization and some very basic business requirements. But this

/** *  Execute Stored procedure (currently only supports returning one cursor)  never null *  *  @param  sql *              executed statements  *  @param  index *              subscript of the current cursor  *  @param  obj  *            

Many friends in the development project not everyone with a database, but a separate host as the development of the database server, so that our developers need to connect him. Although there are many online about the need to install the Oracle

Oracle Log ViewA Path to Oracle logs:Login: Sqlplus "/as sysdba"View Path:sql> select * from V$logfile;Sql> select * from V$logfile; (#日志文件路径)Two What the Oracle log file contains: (The number of logs may be slightly different)Control01.ctl example01

Things to keep in mind when using EXPDP and IMPDP data pumps:Exp and IMP are client tool programs that can be used either on the client or on the server side.EXPDP and IMPDP are server-side utilities that can only be used on the Oracle server and

--Create tablecreate table T_eb_sys_dn_sequence_config (sequence_id VARCHAR2 () default sys_guid () not NULL, SEQ Uence_name VARCHAR2 () not NULL, Sequence_desc VARCHAR2 ($), Sequence_len INTEGER default 4 NOT NULL, RE Set_type INTEGER default 2

C HR , ASCIIsyntax : CHR (string),ASCII (String)function: Returns a character that has an equivalent value in the database character set and X. CHR and ASCII are a pair of inverse functions. After the conversion of CHR character after the ASCII

GConf Error resolution for LinuxProblem:After the CentOS system created the user Oracle, the user logged into the system, the page loading error, resulting in re-entry to the CentOS system after the appearance:GConf error:failed to contact

Use of dbms_ SQL in oracle 1. Run the query using dbms_ SQL Use dbms_ SQL to execute the select statement in the order of open cursor --> parse --> define column --> execute --> fetch rows --> close cursor; 1. Create a team table structure, as shown