oracle link
Á©Ì¨²»Í¬µÄÊý¾Ý¿â·þÎñÆ÷£¬´Óһ̨Êý¾Ý¿â·þÎñÆ÷µÄÒ»¸öÓû§¶ÁÈ¡Áíһ̨Êý¾Ý¿â·þÎñÆ÷ϵÄij¸öÓû§µÄÊý¾Ý£¬Õâ¸öʱºò¿ÉÒÔʹÓÃdblink¡£
ÆäʵdblinkºÍÊý¾Ý¿âÖеÄview²î²»¶à£¬½¨dblinkµÄʱºòÐèÒªÖªµÀ´ý¶ÁÈ¡Êý¾Ý¿âµÄipµØÖ·£¬ssidÒÔ¼°Êý¾Ý¿âÓû§ÃûºÍÃÜÂë¡£
´´½¨¿ÉÒÔ²ÉÓÃÁ½ÖÖ·½Ê½£º
1¡¢ÒѾÅäÖñ¾µØ·þÎñ
create public database
link fwq12 connect to fzept
identified by neu using 'fjept' CREATE DATABASE LINKÊý¾Ý¿âÁ´½ÓÃûCONNECT TO Óû§Ãû IDENTIFIED BY ÃÜÂë USING ‘±¾µØÅäÖõÄÊý¾ÝµÄʵÀýÃû’;
2¡¢Î´ÅäÖñ¾µØ·þÎñ
create database link linkfwq
connect to fzept identified by neu
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.142.202.12)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = fjept)
)
)';
host£½Êý¾Ý¿âµÄipµØÖ·£¬service_name£½Êý¾Ý¿âµÄssid¡£
ÆäʵÁ½ÖÖ·½·¨ÅäÖÃdblinkÊDz¶àµÄ£¬ÎÒ¸öÈ˸оõ»¹ÊǵڶþÖÖ·½·¨±È½ÏºÃ£¬ÕâÑù²»Êܱ¾µØ·þÎñµÄÓ°Ïì¡£
Êý¾Ý¿âÁ¬½Ó×Ö·û´®¿ÉÒÔÓÃNET8 EASY CONFIG»òÕßÖ±½ÓÐÞ¸ÄTNSNAMES.ORAÀﶨÒå.
Êý¾Ý¿â²ÎÊýglobal_name=trueʱҪÇóÊý¾Ý¿âÁ´½ÓÃû³Æ¸úÔ¶¶ËÊý¾Ý¿âÃû³ÆÒ»Ñù
Êý¾Ý¿âÈ«¾ÖÃû³Æ¿ÉÒÔÓÃÒÔÏÂÃüÁî²é³ö
SELECT * from GLOBAL_NAME;
²éѯԶ¶ËÊý¾Ý¿âÀïµÄ±í
SELECT …… from ±íÃû@Êý¾Ý¿âÁ´½ÓÃû;
²éѯ¡¢É¾³ýºÍ²åÈëÊý¾ÝºÍ²Ù×÷±¾µØµÄÊý¾Ý¿âÊÇÒ»ÑùµÄ£¬Ö»²»¹ý±íÃûÐèҪд³É“±íÃû@dblink·þÎñÆ÷”¶øÒÑ¡£
¸½´ø˵ÏÂͬÒå´Ê´´½¨:
&nb
Ïà¹ØÎĵµ£º
import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* ´Ë´¦²åÈëÀàÐÍ˵Ã÷¡£
* ´´½¨ÈÕÆÚ£º(2001/11/30 14:55 ......
1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
²ÎÊý1 IN NUMBER,
²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿ÖУ¬±ØÐëÓÐÒ»Ì ......
BLOBת»»ÎªCLOBµÄº¯Êý£¨oracleÖÐÖ´ÐУ©
CREATE OR REPLACE FUNCTION BlobToClob(blob_in IN BLOB) RETURN CLOB AS
v_clob CLOB;
v_varchar VARCHAR2(32767);
v_start PLS_INTEGER := 1;
v_buffer PLS_INTEGER := 32767;
BEGIN
DBMS_LOB.CRE ......
ORACLE ·ÖÇø±í PARTITION table
http://blog.chinaunix.net/u/6889/showart_315897.html
1.1 ·ÖÇø±íPARTITION table
ÔÚORACLEÀïÈç¹ûÓöµ½Ìرð´óµÄ±í£¬¿ÉÒÔʹÓ÷ÖÇøµÄ±íÀ´¸Ä±äÆäÓ¦ÓóÌÐòµÄÐÔÄÜ¡£
1.1.1 ·ÖÇø±íµÄ½¨Á¢£º
ij¹«Ë¾µÄÿÄê²úÉú¾Þ´óµÄÏúÊۼǼ£¬DBAÏò¹«Ë¾½¨Òéÿ¼¾¶ÈµÄÊý¾Ý·ÅÔÚÒ»¸ö·ÖÇøÄÚ£¬ÒÔÏÂʾ·¶µÄÊǸù«Ë¾1 ......
oracle ±í½á¹¹µÄÐÞ¸Ä
½ñÌì×ܽáϹØÓÚ±íµÄÐÞ¸Ä,·ÀÖ¹ÒÔºóÍü¼Ç,ºÃ¼ÇÐÔ²»ÈçÀñÊÍ·Âð!!!
¸ü¸Ä±íµÄ½á¹¹
1.±à¼±íµÄ×Ö¶Î
ÐÞ¸ÄÒ»¸öÁеÄÊý¾ÝÀàÐÍ(Ò»°ãÏÞÓÚÐ޸ij¤¶È£¬ÐÞ¸ÄΪһ¸ö²»Í¬ÀàÐÍʱÓÐÖî¶àÏÞÖÆ):
Óï·¨:
ALTER TABLE ±íÃû MODIFY(ÁÐÃû Êý¾ÝÀàÐÍ);
eg1:
alter table ......