Oracle

Oracle.ManagedDataAccess.dllEven for 64-bit systems, register a 32-bit version.#if INTERACTIVE#[email protected] "C:\oracle\odp.net\managed\common\Oracle.ManagedDataAccess.dll"#endifOpen Oracle.ManagedDataAccess.ClientOpen

1. The most efficient way to delete duplicate records (because ROWID is used)Example:DELETE from emp E where E.rowid > (SELECT MIN (x.rowid) from emp X where x.emp_no = E.emp_no);2. In the SQL statement that contains the subquery, pay special

1. Rebuilding the host's Oracle User Group Unified Specification UID GID to ensure shared storage hooks or other requirements for permission specificationUserdel-501 Oracle#ID oracleuid= (Oracle) gid= (oinstall) group = (Oinstall), 501 (DBA)2.

This morning the user called to say that the system sort of problem, a closer look, the problem seems to be in ROWNUM this function.In Oracle the ROWNUM function is to assign the order of the query results in sequence, so a lot of people use this

Close the database as Sysdbashutdown Abort Clear Oracle SoftwareSu--RF * rm-rf/etc/ora* 4 (Tikanga) changed to version 5 vi/etc/pam.d/Login Line at the end of the deletion session required pam_limits.so vi/etc/security/for Oracle2047163841

Sometimes it takes a table join query in two databases to use the database link.The role of database link is to build databases and database connections.1. First look at how to create using the Pl\sql tool.Locate the database links right-click

1. View processes and Sessions parametersSql> Show parameter processesNAME TYPE VALUEDb_writer_processes Integer 1Gcs_server_processes integer 0Job_queue_processes Integer 10Log_archive_max_processes Integer 2Processes integer 50Sql> Show Parameter

Oracle database to realize the self-growth of ID, need to create a sequence and trigger to implement, a little bit of trouble, but also can be resolved.Directly on the address, first, http://www.wlcrane.com/article.aspx?arid=86This post looks good,

Flashback TipsThe following tips and restrictions apply to using flashback features. Flashback tips–performance For better performance, generate statistics on all tables involved in a Flashback Query DBMS_STATS by using the package, and Ke EP

An exact numeric data type that uses integer data. bigint from  -2^63  ( -9223372036854775808)   to  2^63-1  (9223372036854775807) Integer data for   (all numbers). The storage size is  8  bytes. int from  -2^31  ( -2,147,483,648)   to  2^31 

Reproduced:To_date () with 24-hour notation and MM-minute display:One, when using Oracle's to_date function to do date conversion, many Java programmers may use the "YYYY-MM-DD HH:mm:ss" format as a format for conversion, but in Oracle will cause an

Here's a way to use the APPEND hint to make it possible to insert billions of data within 10 minutes.--Create tableCREATE TABLE Tmp_test_chas_lee(F01 VARCHAR2 (20),F02 Number (TEN) is not NULL,f03 VARCHAR2 (21),f04 VARCHAR2 (21),F05 number,F06

The database field types commonly used by Oracle are as follows: Field type Chinese description Restriction conditions Other instructions CHAR Fixed-length strings Max Length bytes

Thinking back just entered the job, a server was hung up, so is in "distress" have the opportunity to learn. In the dead of night, I want to recall the creation of an Oracle instance. One method, DBCA, a graphical interface, but relies on software

Checking for oracle home incompatibilities failed, incompatibilities An error is reported during Oracle software installation: Error cause: This error is mainly caused by the last installation failure of oracle, but the directory files left

Process of obtaining the memory lock in the shared pool through hard parsing of OracleOCP 1. Obtain the library cache Latch. (1) The text of the SQL statement is not found in the name handle of the parent cursor: select * from gyj_t1 where id = 1;

Solve the problem that an empty Oracle11g table cannot be exported. The deferred_segment_creation parameter is added to Oracle11g. The default value is true when the database is created, which means delayed loading. When no data exists in the table,

Summary of Oracle Database Import and Export (same version) Today, I have nothing to worry about, so I started a database for fun. By the way, I will summarize it. 0. log on to the database as the cmd command Administrator Sqlplus/as sysdba 1. cmd

ORA-00214: controlfile '/u01/app/oracle/oradata/[sid]/control01.ctl 'version inconsistent with file'/u01/app/oracle/oradata/[sid]/control03.ctl ', oraclecontrolfile Sample error: SQL> startupORACLE instance started. Total System Global Area 285212672

Rownum, row_number (), and rownumrow_number in oracle This section briefly introduces how to use rownum and row_number () in oracle and provides an example. Reference: http://www.cnblogs.com/zjrstar/archive/2006/08/31/491090.html First, we will