顯示具有 資料庫 標籤的文章。 顯示所有文章
顯示具有 資料庫 標籤的文章。 顯示所有文章

2017年8月1日 星期二

[Oracle]ORA-02019:未找到遠程數據庫之解決方式

請注意使用 DBLINK 時,INIT.ORA中 GLOBAL_NAME 的設置:
如果爲 ture , 請使用DBLINK的全稱,可在 all_db_links 中查到,
如果爲 FALSE, 不必使用全稱,當出現
“ORA-02019:未找到遠程數據庫的連接說明”時,請使用全稱,如:
select * from test@ABC.US.ORACLE.COM

select * from all_db_links 可以查到dblink的全稱

2016年11月3日 星期四

[Oracle]oracle 9i,10G,11G,各版本下載資源

11g,10g,9i的安裝檔在官網都無法現在了,但是我們有神奇的迅雷,用下面這些位址,直接用迅雷下載,可以從別人那裡獲取資源
所以,也是可以下載的哈。公司有oracle授權帳號的可以忽略。
這裡包括了10.2.0.5的patch還有11.2.0.3的patch安裝檔

Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk1.zip
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk2.zip
http://download.oracle.com/otn/nt/oracle9i/9201/92010NT_Disk3.zip
Oracle9i Database Release 2 Enterprise/Standard/Personal/Client Edition for Windows XP 2003/Windows Server 2003 (64-bit)
http://download.oracle.com/otn/nt/oracle9i/9202/92021Win64_Disk1.zip
http://download.oracle.com/otn/nt/oracle9i/9202/92021Win64_Disk2.zip
Oracle9i Database Release 2 Enterprise/Standard Edition for Intel Linux
http://download.oracle.com/otn/linux/oracle9i/9204/ship_9204_linux_disk1.cpio.gz
http://download.oracle.com/otn/linux/oracle9i/9204/ship_9204_linux_disk2.cpio.gz
http://download.oracle.com/otn/linux/oracle9i/9204/ship_9204_linux_disk3.cpio.gz
Oracle9i Database Release 2 (9.2.0.4) Enterprise/Standard Edition for Linux x86-64
http://download.oracle.com/otn/linux/oracle9i/9204/amd64_db_9204_Disk1.cpio.gz
http://download.oracle.com/otn/linux/oracle9i/9204/amd64_db_9204_Disk2.cpio.gz
http://download.oracle.com/otn/linux/oracle9i/9204/amd64_db_9204_Disk3.cpio.gz
Oracle9i Database Release 2 Enterprise/Standard Edition for AIX – Based 4.3.3 Systems (64-bit)
http://download.oracle.com/otn/aix/oracle9i/9201/server_9201_AIX64_Disk1.cpio.gz
http://download.oracle.com/otn/aix/oracle9i/9201/server_9201_AIX64_Disk2.cpio.gz
http://download.oracle.com/otn/aix/oracle9i/9201/server_9201_AIX64_Disk3.cpio.gz
http://download.oracle.com/otn/aix/oracle9i/9201/server_9201_AIX64_Disk4.cpio.gz
Oracle9i Database Release 2 Enterprise/Standard Edition for AIX- Based 5L Systems
http://download.oracle.com/otn/aix/oracle9i/9201/A99331-01.zip
http://download.oracle.com/otn/aix/oracle9i/9201/A99331-02.zip
http://download.oracle.com/otn/aix/oracle9i/9201/A99331-03.zip
http://download.oracle.com/otn/aix/oracle9i/9201/A99331-04.zip
Oracle9i Database Release 2 Enterprise/Standard Edition for Sun SPARC Solaris (32-bit)
http://download.oracle.com/otn/solaris/oracle9i/9201/92010Sol_Disk1.cpio.gz
http://download.oracle.com/otn/solaris/oracle9i/9201/92010Sol_Disk2.cpio.gz
http://download.oracle.com/otn/solaris/oracle9i/9201/92010Sol_Disk3.cpio.gz
Oracle9i Database Release 2 Enterprise/Standard Edition for Sun SPARC Solaris (64-bit)
http://download.oracle.com/otn/solaris/oracle9i64/9201/solaris64_9.2.0.1.0.Disk1.cpio.gz
http://download.oracle.com/otn/solaris/oracle9i64/9201/solaris64_9.2.0.1.0.Disk2.cpio.gz
http://download.oracle.com/otn/solaris/oracle9i64/9201/solaris64_9.2.0.1.0.Disk3.cpio.gz
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_clusterware_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_gateways_win32.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (x64)
http://download.oracle.com/otn/nt/oracle10g/10201/102010_win64_x64_database.zip
http://download.oracle.com/otn/nt/oracle10g/10201/102010_win64_x64_client.zip
http://download.oracle.com/otn/nt/oracle10g/10201/102010_win64_x64_clusterware.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86
http://download.oracle.com/otn/linux/oracle10g/10201/10201_database_linux32.zip
http://download.oracle.com/otn/linux/oracle10g/10201/10201_client_linux32.zip
http://download.oracle.com/otn/linux/oracle10g/10201/10201_gateways_linux32.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86-64
http://download.oracle.com/otn/linux/oracle10g/10201/10201_database_linux_x86_64.cpio.gz
http://download.oracle.com/otn/linux/oracle10g/10201/10201_client_linux_x86_64.cpio.gz
http://download.oracle.com/otn/linux/oracle10g/10201/10201_clusterware_linux_x86_64.cpio.gz
http://download.oracle.com/otn/linux/oracle10g/10201/10201_gateways_linux_x86_64.cpio.gz
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for AIX5L
http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_database.cpio.gz
http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_client.cpio.gz
http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_cluster.cpio.gz
http://download.oracle.com/otn/aix/oracle10g/10201/10gr2_aix5l64_gateways.cpio.gz
Oracle Database 10g Release 2 (10.2.0.2) Enterprise/Standard Edition for Solaris Operating System (x86)
http://download.oracle.com/otn/solaris/oracle10g/10202/10202_database_solx86.zip
http://download.oracle.com/otn/solaris/oracle10g/10202/10202_client_solx86.zip
http://download.oracle.com/otn/solaris/oracle10g/10202/10202_clusterware_solx86.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Solaris Operating System (x86-64)
http://download.oracle.com/otn/solaris/oracle10g/10201/x8664/10201_database_solx86_64.zip
http://download.oracle.com/otn/solaris/oracle10g/10201/x8664/10201_client_solx86_64.zip
http://download.oracle.com/otn/solaris/oracle10g/10201/x8664/10201_clusterware_solx86_64.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for HP-UX PA-RISC
http://download.oracle.com/otn/hp/oracle10g/10201/10201_database.zip
http://download.oracle.com/otn/hp/oracle10g/10201/10201_clusterware.zip
http://download.oracle.com/otn/hp/oracle10g/10201/10201_client.zip
Oracle Database 10g Release 2 (10.2.0.1) Enterprise/Standard Edition for HP-UX Itanium
http://download.oracle.com/otn/hp/oracle10g/10201/itanium/10gr2_database_hpi.zip
http://download.oracle.com/otn/hp/oracle10g/10201/itanium/10gr2_client_hpi.zip
http://download.oracle.com/otn/hp/oracle10g/10201/itanium/10gr2_clusterware_hpi.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Solaris Operating System (SPARC) (64-bit)
http://download.oracle.com/otn/solaris/oracle10g/10201/sol64/10gr2_db_sol.cpio.gz
http://download.oracle.com/otn/solaris/oracle10g/10201/sol64/10gr2_client_sol.cpio.gz
http://download.oracle.com/otn/solaris/oracle10g/10201/sol64/10gr2_cluster_sol.cpio.gz
Oracle Database 10g Release 2 (10.2.0.4.0) for MAC OS X on Intel x86-64
http://download.oracle.com/otn/mac/oracle10g/10204/x86_64/db.zip
http://download.oracle.com/otn/mac/oracle10g/10204/x86_64/client.zip
Oracle Database 10g Release 2 (10.2.0.4.0) Enterprise/Standard Edition for Microsoft Windows Vista x64 and Microsoft Windows Server 2008 x64
http://download.oracle.com/otn/nt/oracle10g/10204/10204_vista_w2k8_x64_production_db.zip
http://download.oracle.com/otn/nt/oracle10g/10204/10204_vista_w2k8_x64_production_client.zip
http://download.oracle.com/otn/nt/oracle10g/10204/10204_vista_w2k8_x64_production_crs.zip
Oracle Database 11g Release 2 (11.2.0.1.0) for Microsoft Windows (64-bit)
http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_database_1of2.zip
http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_database_2of2.zip
http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_client.zip
http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_grid.zip
Oracle Database 11g Release 2 (11.2.0.1.0) for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_1of2.zip
http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_2of2.zip
http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_client.zip
no grid
Oracle Database 11g Release 2 (11.2.0.1.0) for Linux x86
http://download.oracle.com/otn/linux/oracle11g/R2/linux_11gR2_database_1of2.zip
http://download.oracle.com/otn/linux/oracle11g/R2/linux_11gR2_database_2of2.zip
http://download.oracle.com/otn/linux/oracle11g/R2/linux_11gR2_client.zip
http://download.oracle.com/otn/linux/oracle11g/R2/linux_11gR2_grid.zip
Oracle Database 11g Release 2 (11.2.0.1.0) for Linux x86-64
http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_1of2.zip
http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_2of2.zip
http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_client.zip
http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_grid.zip
Oracle Database 11g Release 2 (11.2.0.1.0) for Solaris Operating System (SPARC) (64-bit)
http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.sparc64_11gR2_database_1of2.zip
http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.sparc64_11gR2_database_2of2.zip
http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.sparc64_11gR2_client.zip
http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.sparc64_11gR2_client32.zip
http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.sparc64_11gR2_grid.zip
Oracle Database 11g Release 2 (11.2.0.1.0) for Solaris Operating System (x86-64)
http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.x64_11gR2_database_1of2.zip
http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.x64_11gR2_database_2of2.zip
http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.x64_11gR2_client.zip
http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.x86_11gR2_client.zip
http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.x64_11gR2_grid.zip
Oracle Database 11g Release 2 (11.2.0.1.0) for HP-UX Itanium
http://download.oracle.com/otn/hp/oracle11g/R2/hpia64_11gR2_database_1of2.zip
http://download.oracle.com/otn/hp/oracle11g/R2/hpia64_11gR2_database_2of2.zip
http://download.oracle.com/otn/hp/oracle11g/R2/hpia64_11gR2_client.zip
http://download.oracle.com/otn/hp/oracle11g/R2/hpia64_11gR2_client32.zip
http://download.oracle.com/otn/hp/oracle11g/R2/hpia64_11gR2_grid.zip
Oracle Database 11g Release 2 (11.2.0.1.0) for HP-UX PA-RISC (64-bit)
http://download.oracle.com/otn/hp/oracle11g/R2/hpux.parisc64_11gR2_database_1of2.zip
http://download.oracle.com/otn/hp/oracle11g/R2/hpux.parisc64_11gR2_database_2of2.zip
http://download.oracle.com/otn/hp/oracle11g/R2/hpux.parisc64_11gR2_client.zip
http://download.oracle.com/otn/hp/oracle11g/R2/hpux.parisc32_11gR2_client.zip
http://download.oracle.com/otn/hp/oracle11g/R2/hpux.parisc64_11gR2_grid.zip
Oracle Database 11g Release 2 (11.2.0.1.0) for AIX (PPC64)
http://download.oracle.com/otn/aix/oracle11g/R2/aix.ppc64_11gR2_database_1of2.zip
http://download.oracle.com/otn/aix/oracle11g/R2/aix.ppc64_11gR2_database_2of2.zip
http://download.oracle.com/otn/aix/oracle11g/R2/aix.ppc64_11gR2_client.zip
http://download.oracle.com/otn/aix/oracle11g/R2/aix.ppc32_11gR2_client.zip
http://download.oracle.com/otn/aix/oracle11g/R2/aix.ppc64_11gR2_grid.zip
patchs
ftp://updates.oracle.com/4547809/p4547809_92080_AIX64-5L.zip
ftp://updates.oracle.com/4547809/p4547809_92080_HP64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_HPUX-IA64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_LINUX.zip
ftp://updates.oracle.com/4547809/p4547809_92080_Linux-IA64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_Linux-x86-64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_MVS.zip
ftp://updates.oracle.com/4547809/p4547809_92080_SOLARIS.zip
ftp://updates.oracle.com/4547809/p4547809_92080_SOLARIS64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_WINNT.zip
ftp://updates.oracle.com/4547809/p4547809_92080_WINNT64.zip
其他版本的相关Bug号,可以根据以上规则来查找自己需要的补丁:
9.2.0.4 = 3095277 
9.2.0.5 = 3501955
9.2.0.6 = 3948480
9.2.0.7 = 4163445
9.2.0.8 = 4547809
10.1.0.3 = 3761843
10.1.0.4 = 4163362
10.1.0.5 = 4505133
10.2.0.2 = 4547817
10.2.0.3 = 5337014
oracle 10.2.0.2 patch 
ftp://updates.oracle.com/4547817/p4547817_10202_AIX64-5L.zip
ftp://updates.oracle.com/4547817/p4547817_10202_HP64.zip
ftp://updates.oracle.com/4547817/p4547817_10202_HPUX-IA64.zip
ftp://updates.oracle.com/4547817/p4547817_10202_LINUX.zip
ftp://updates.oracle.com/4547817/p4547817_10202_Linux-IA64.zip
ftp://updates.oracle.com/4547817/p4547817_10202_Linux-x86-64.zip
ftp://updates.oracle.com/4547817/p4547817_10202_MVS.zip
ftp://updates.oracle.com/4547817/p4547817_10202_SOLARIS.zip
ftp://updates.oracle.com/4547817/p4547817_10202_SOLARIS64.zip
ftp://updates.oracle.com/4547817/p4547817_10202_WINNT.zip
ftp://updates.oracle.com/4547817/p4547817_10202_WINNT64.zip
oracle 10.2.0.3 patch
ftp://updates.oracle.com/5337014/p5337014_10203_AIX5L.zip
ftp://updates.oracle.com/5337014/p5337014_10203_HPUX-IA64.zip
ftp://updates.oracle.com/5337014/p5337014_10203_LINUX.zip
ftp://updates.oracle.com/5337014/p5337014_10203_Linux-x86-64.zip
ftp://updates.oracle.com/5337014/p5337014_10203_Linux-x86.zip
ftp://updates.oracle.com/5337014/p5337014_10203_Win32.zip
ftp://updates.oracle.com/5337014/p5337014_10203_Win64.zip
oracle 10.2.0.4 patch:
ftp://updates.oracle.com/6810189/p6810189_10204_AIX5L.zip
ftp://updates.oracle.com/6810189/p6810189_10204_HPUX-IA64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_HPUX-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_LINUX.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Win32.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Win64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Solaris-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Solarisx86.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Solaris86-64.zip
oracle 10.2.0.5 patch:
ftp://updates.oracle.com/8202632/p8202632_10205_AIX64-5L_1of2.zip
ftp://updates.oracle.com/8202632/p8202632_10205_AIX64-5L_2of2.zip
ftp://updates.oracle.com/8202632/p8202632_10205_HPUX-64_1of2.zip
ftp://updates.oracle.com/8202632/p8202632_10205_HPUX-64_2of2.zip
ftp://updates.oracle.com/8202632/p8202632_10205_HPUX-IA64_1of2.zip
ftp://updates.oracle.com/8202632/p8202632_10205_HPUX-IA64_2of2.zip
ftp://updates.oracle.com/8202632/p8202632_10205_Linux-x86-64.zip
ftp://updates.oracle.com/8202632/p8202632_10205_Linux-x86.zip
ftp://updates.oracle.com/8202632/p8202632_10205_MSWIN-x86-64.zip
ftp://updates.oracle.com/8202632/p8202632_10205_WINNT.zip
oracle 11.2.0.3 patch
Linux x86/x64 :
https://updates.oracle.com/Orion/Services/download/p10404530_112030_Linux-x86-64_1of7.zip?aru=14125322&patch_file=p10404530_112030_Linux-x86-64_1of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_Linux-x86-64_2of7.zip?aru=14125322&patch_file=p10404530_112030_Linux-x86-64_2of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_Linux-x86-64_3of7.zip?aru=14125322&patch_file=p10404530_112030_Linux-x86-64_3of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_Linux-x86-64_4of7.zip?aru=14125322&patch_file=p10404530_112030_Linux-x86-64_4of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_Linux-x86-64_5of7.zip?aru=14125322&patch_file=p10404530_112030_Linux-x86-64_5of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_Linux-x86-64_6of7.zip?aru=14125322&patch_file=p10404530_112030_Linux-x86-64_6of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_Linux-x86-64_7of7.zip?aru=14125322&patch_file=p10404530_112030_Linux-x86-64_7of7.zip
Windows x86/x64:
https://updates.oracle.com/Orion/Services/download/p10404530_112030_MSWIN-x86-64_1of7.zip?aru=14255124&patch_file=p10404530_112030_MSWIN-x86-64_1of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_MSWIN-x86-64_2of7.zip?aru=14255124&patch_file=p10404530_112030_MSWIN-x86-64_2of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_MSWIN-x86-64_3of7.zip?aru=14255124&patch_file=p10404530_112030_MSWIN-x86-64_3of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_MSWIN-x86-64_4of7.zip?aru=14255124&patch_file=p10404530_112030_MSWIN-x86-64_4of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_MSWIN-x86-64_5of7.zip?aru=14255124&patch_file=p10404530_112030_MSWIN-x86-64_5of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_MSWIN-x86-64_6of7.zip?aru=14255124&patch_file=p10404530_112030_MSWIN-x86-64_6of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_MSWIN-x86-64_7of7.zip?aru=14255124&patch_file=p10404530_112030_MSWIN-x86-64_7of7.zip aix :https://updates.oracle.com/Orion/Services/download/p10404530_112030_AIX64-5L_1of7.zip?aru=14218078&patch_file=p10404530_112030_AIX64-5L_1of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_AIX64-5L_2of7.zip?aru=14218078&patch_file=p10404530_112030_AIX64-5L_2of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_AIX64-5L_3of7.zip?aru=14218078&patch_file=p10404530_112030_AIX64-5L_3of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_AIX64-5L_4of7.zip?aru=14218078&patch_file=p10404530_112030_AIX64-5L_4of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_AIX64-5L_5of7.zip?aru=14218078&patch_file=p10404530_112030_AIX64-5L_5of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_AIX64-5L_6of7.zip?aru=14218078&patch_file=p10404530_112030_AIX64-5L_6of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_AIX64-5L_7of7.zip?aru=14218078&patch_file=p10404530_112030_AIX64-5L_7of7.zip
hp IA64:
https://updates.oracle.com/Orion/Services/download/p10404530_112030_HPUX-IA64_1of7.zip?aru=14218063&patch_file=p10404530_112030_HPUX-IA64_1of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_HPUX-IA64_2of7.zip?aru=14218063&patch_file=p10404530_112030_HPUX-IA64_2of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_HPUX-IA64_3of7.zip?aru=14218063&patch_file=p10404530_112030_HPUX-IA64_3of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_HPUX-IA64_4of7.zip?aru=14218063&patch_file=p10404530_112030_HPUX-IA64_4of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_HPUX-IA64_5of7.zip?aru=14218063&patch_file=p10404530_112030_HPUX-IA64_5of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_HPUX-IA64_6of7.zip?aru=14218063&patch_file=p10404530_112030_HPUX-IA64_6of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_HPUX-IA64_7of7.zip?aru=14218063&patch_file=p10404530_112030_HPUX-IA64_7of7.zip
HP PA-RISC 64: 
https://updates.oracle.com/Orion/Services/download/p10404530_112030_HP64_1of6.zip?aru=14582072&patch_file=p10404530_112030_HP64_1of6.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_HP64_2of6.zip?aru=14582072&patch_file=p10404530_112030_HP64_2of6.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_HP64_3of6.zip?aru=14582072&patch_file=p10404530_112030_HP64_3of6.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_HP64_4of6.zip?aru=14582072&patch_file=p10404530_112030_HP64_4of6.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_HP64_5of6.zip?aru=14582072&patch_file=p10404530_112030_HP64_5of6.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_HP64_6of6.zip?aru=14582072&patch_file=p10404530_112030_HP64_6of6.zip
Solaris x64:https://updates.oracle.com/Orion/Services/download/p10404530_112030_Solaris86-64_1of6.zip?aru=14152240&patch_file=p10404530_112030_Solaris86-64_1of6.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_Solaris86-64_2of6.zip?aru=14152240&patch_file=p10404530_112030_Solaris86-64_2of6.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_Solaris86-64_3of6.zip?aru=14152240&patch_file=p10404530_112030_Solaris86-64_3of6.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_Solaris86-64_4of6.zip?aru=14152240&patch_file=p10404530_112030_Solaris86-64_4of6.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_Solaris86-64_5of6.zip?aru=14152240&patch_file=p10404530_112030_Solaris86-64_5of6.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_Solaris86-64_6of6.zip?aru=14152240&patch_file=p10404530_112030_Solaris86-64_6of6.zip
Solaris x86:
https://updates.oracle.com/Orion/Services/download/p10404530_112030_Solarisx86_1of2.zip?aru=14152437&patch_file=p10404530_112030_Solarisx86_1of2.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_Solarisx86_2of2.zip?aru=14152437&patch_file=p10404530_112030_Solarisx86_2of2.zip
Solaris SPARC X64:
https://updates.oracle.com/Orion/Services/download/p10404530_112030_SOLARIS64_1of7.zip?aru=14152117&patch_file=p10404530_112030_SOLARIS64_1of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_SOLARIS64_2of7.zip?aru=14152117&patch_file=p10404530_112030_SOLARIS64_2of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_SOLARIS64_3of7.zip?aru=14152117&patch_file=p10404530_112030_SOLARIS64_3of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_SOLARIS64_4of7.zip?aru=14152117&patch_file=p10404530_112030_SOLARIS64_4of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_SOLARIS64_5of7.zip?aru=14152117&patch_file=p10404530_112030_SOLARIS64_5of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_SOLARIS64_6of7.zip?aru=14152117&patch_file=p10404530_112030_SOLARIS64_6of7.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_SOLARIS64_7of7.zip?aru=14152117&patch_file=p10404530_112030_SOLARIS64_7of7.zip
Solaris SPARC x86:
https://updates.oracle.com/Orion/Services/download/p10404530_112030_SOLARIS_1of2.zip?aru=14152484&patch_file=p10404530_112030_SOLARIS_1of2.zip
https://updates.oracle.com/Orion/Services/download/p10404530_112030_SOLARIS_2of2.zip?aru=14152484&patch_file=p10404530_112030_SOLARIS_2of2.zip

原文出自:http://semiter.blog.51cto.com/1234477/1251332

2013年12月18日 星期三

[Oracle]UNIQUE CONSTRAINT和PRIMARY KEY有何不同

PRIMARY KEY裡的任何一個欄位均不得為空值
UNIQUE CONSTRAINT允許其中的欄位有空值,但是欄位的組合仍必須為唯一

英文說明

WHAT IS THE DIFFERENCE BETWEEN A UNIQUE CONSTRAINT AND A PRIMARY KEY?

Primary KeyUnique Constraint
None of the fields that are part of the primary key can contain a null value.Some of the fields that are part of the unique constraint can contain null values as long as the combination of values is unique.
Oracle does not permit you to create both a primary key and unique constraint with the same columns.