Oracle

In the http://stackoverflow.com/questions/277744/jdbc-oracle-arrayindexoutofboundsexception to find such a sentence: In Oracle Metalink (Oracle's support Site-note ID 736273.1) I found that's a bug in JDBC adapter (version 10.2.0.0 .0 to 11.1.0.7.0)

IMPDP smtj2012/password @localhost/devdb directory=dump_dir dumpfile=bkmmtdb_smtj20130417120001.dmp REMAP_SCHEMA=SMTJ: smtj2012 remap_tablespace=smtj:smtj2012 Data Pump IMPDP Parameters:1.remap_datafile This option is used to convert the source

In Oracle, there are times when you need to update another table with one table. The following are examples of implementations: 1. Create a table test_a CREATE TABLE Test_a (ID Number (19),Name VARCHAR2 (20),Age Number (3)) 2. Insert some data

Oracle's optimizer has two optimizations, namely, rule-based optimization (rule-based optimization, short rbo) and cost based optimization (cost-based optimization, referred to as CBO), In Oracle8 and later versions, the Oracle Strong column

1. Calculation method of table occupancy space size Select s.segment_name, DECODE (sum (BYTES), NULL, 0, sum (BYTES)/1024/1024) MbytesFrom Dba_segments SWhere s.segment_name = ' mtl_material_transactions '-table nameand S.segment_type = '

=============================== query Table space usage =============================== Select UPPER (f.tablespace_name) "Table space name", D.TOT_GROOTTE_MB "Table space size (M)", D.tot_grootte_mb-f.total_bytes "used Space (M)", To_char (ROUND

Select A.A1--Table space name, C.C2--type, c.c3--District management, b.b2/1024/1024--table space size K, (B.B2-A.A2)/1024/1024--Used k,a.a2/1024/1024 --Unused K,substr ((B.B2-A.A2)/b.b2 * 100, 1, 5) | | % '--utilization from (select Tablespace_name

implementation steps: 1. Change init parameter resource_limit to true; restart the database; 2. Change the "Idle connection Time" of profile profiles for user profiles; 3. In the database query session state is "Snipe", through the operating

Oracle database is favored by more and more enterprises because of its high reliability, security and compatibility. How to keep Oracle databases in good performance is a concern for many database administrators and may be considered in the

Transferred from http://layznet.javaeye.com/blog/592873 When you write a stored procedure before, the exception handling is:...EXCEPTIONWhen others THENROLLBACK;End ...This type of writing when the stored procedure throws an exception, we do not

Guide: The last few days are used package to complete the streams configuration, but in the management of OEM will feel more intuitive, of course, all the relevant package very understanding, it is almost. In the 9i OEM, it looks like the streams

Today found the Dream Oracle 9207 Windows upgrade patch, upgrade the times in the client machine abnormal, the original is the MSDTC service did not stop, reported a lot of garbled, temporarily stop DTS service upgrade normal. After the upgrade exp

Checking Kernel Parameters Checking for semmsl=250;    Found semmsl=250. Passed Checking for semmns=32000;    Found semmns=32000. Passed Checking for semopm=100;    Found semopm=32. Failed Checking for semmni=128;    Found semmni=128.

Use of the--oracle trunc () function /************** Date ********************/ 1.select trunc (sysdate) from dual--2011-3-18 today's date is 2011-3-18 2.select trunc (sysdate, ' mm ') from dual--2011-3-1 returns the first day of the month. 3.select

Substr An intercept string function in Oracle. The syntax is as follows: substr (String, start_position, [length]) Parameter analysis: String String value Start_position Intercepts the initial position of the string,

Export command: Exp /@[] owner= file= Explain: Data export to use the EXP command, directly run cmd, enter the actual data can be. If the database is not a local database, use the Oracle Net Configuration Assistant to configure the local net

There are several reasons for ORA-01034 and ORA-27101 errors: 1. The main Oracle current service is not available, shared memory realm does not exist, because Oracle is not started or does not start properly, share memory is not assigned to the

1.TRUNC (for dates)The date value that the Trunc function truncates for the specified element.Its specific syntax format is as follows:TRUNC (Date[,fmt]) which Date value FMT date format, which is truncated by the specified element format.

Turn from: http://xo-tobacoo.iteye.com/blog/182791 Summarized below. Using the merge is much faster than the traditional judgment before choosing to insert or update. 1) Main functionProvides conditional updating and inserting of data into a

Create or Replace package Aa_pkg_monitor_business_sql is Procedure Pro_monitor_drop_policy (Object_schema in varchar2);Procedure Pro_monitor_add_policy (Object_schema in varchar2); Procedure Pro_monitor_drop_main;Procedure