Oracle

This method enables synchronization of tables with two different versions of Oracle, and is more efficient than IMP statement-guided DMP. first, achieve the goal:To implement data synchronization from the source table (AAA) to the target table (BBB).

Primary database ip:192.168.2.100 Db:rdbms 11.2.0.4 Oracle_sid:test Global_name:test From the database ip:192.168.2.14 Db:rdbms 11.2.0.4 Oracle_sid:orcl Global_name:orcl 1 for test, ORCL Library to open archive2 Configure the TEST,ORCL library

--① System Change number--Gets the data time insertion time ORA_ROWSCN the SCN that returned the last modification of the row. Select Scn_to_timestamp (ORA_ROWSCN), tt.* from TT; --SCN and timestamp convert select TIMESTAMP_TO_SCN (sysdate) from

1. Start Sqlplus2. Please enter your username: Sqlplus/as sysdba3. Enter Password: direct return(Note: For SYS both lock and not lock can be locally certified log into SYSDBA)4. Connect to:Oracle Database 11g Enterprise Edition release

rownum It is possible to know that rownum only applies to less than or less than equals, and if it is equal to judgment, it can only be equal to 1 and cannot be compared more than.RowNum is the number that the Oracle system sequentially assigns to

###### Analysis log file LOGMNR ############## 1) in Init.ora, set utl_file_dir parameter 2) to restart the Oracle 3 Create directory file desc DBMS_LOGMNR _d; Dbms_logmnr_d.build; 4 Add log files add/remove log file Dhms_logmnr.add_logfile

1. Basic Grammar SELECT * from table [start and Condition1] connect by [prior] Id=parentid1 It is commonly used to find data that has a parent-child relationship, that is, a tree-structured data, and its return data can clearly differentiate

Oracle Read the comments list, first three by the number of points, and then sorted in reverse order of creation time, required pagination: The first way: SELECT * FROM (select b.*, DECODE (rownum, 1, 1, 2, 2, 3, 3, 4) rankFrom (SELECT a.*From

1. Stop Service First lsnrctl stop with command And then run Sqlplus/nolog Sql> Conn/as SYSDBA sql> shutdown 2, view the instance process and delete Find $ORACLE _base/-name $ORACLE

Oracle time and date operationsSysdate+ (5/24/60/60) Delays 5 seconds based on system time SYSDATE+5/24/60 delays 5 minutes based on system time SYSDATE+5/24 delays 5 hours based on system time SYSDATE+5 delays 5 days based on system time Add_months

original works, from the "Deep Blue Blog" blog, Welcome to reprint, please be sure to indicate the following source, otherwise held responsible for copyright liability. Blue blog:http://blog.csdn.net/huangyanlong/article/details/43926321. First

MDSYS.CS_SRS-----The table defines the name of the coordinate system and its ID values in Oracle spatial, which are all published by Open-gis. The currently defined coordinate system has reached 1018. Mdsys. Sdo_angle_units-----This table defines

This article only discusses the most common indexes in Oracle, that is, the B-tree index. The database version covered in this article is oracle8i.I. View the user index in the system tableIn Oracle, the system table is created automatically when

1, change the client character set: run regedit through Windows Run menu, modify registry Start-> Run-> rededit Under Registry Editor-> HKEY_LOCAL_MACHINE-> SOFTWARE->oracle->key_xe->right WINDOW DOUBLE CLICK Nls_la NG-> Change VALUE to

I. Permissions-related 1. Landing Sqlplus System/admin as SYSDBA; Administrator Login System Account Sqlplus Scott/tiger; Log on to regular user Scott 2. Managing Users Create user Wahaha; Under the Administrator account, create a user

Sequence (SEQUENCE) A sequence is a database object that can be used to generate a unique integer. The main code value is generated automatically by using a sequence. The value of a sequence is automatically generated by a special Oracle program, so

When you need to use these 2 times, first of all, simply: If you order the monthly product of March 15, the end of the month, then you should charge a 17-day fee, this time should determine whether the order time is greater than the beginning of the

If Oracle sets a certain time without access, the connection is automatically closed so that an IO exception occurs when Java accesses Oracle again.Workaround: Add the following configuration information to the spring configuration

  Recently, customers have proposed the use of Plsql developer tools in the application of the system, the database is frequently automatically disconnected, is not used in the case (at intervals) of the anomaly, but also a strange image, that is,

Oracle 11g introduces snapshot Standby, which allows Standby database to be opened in Read-write mode. When switching back to standby mode, all modifications in the Read-write mode are lost. It is implemented through the flashback database, but