ORACLE µÄ²¹¶¡ÏÂÔØµØÖ· (ת)
oracle²¹¶¡ÏÂÔØ
¹Ø¼ü×Ö: oracle
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£¨9i×îÖÕ£©
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
10.2.0.4 = 6810189
ÏÂÔØ²¹¶¡Ê±£¬¿É½øÈëcmd£¬Ê¹ÓÃftpÃüÁîÖ±½ÓµÇÂ¼ÍøÕ¾ÏÂÔØ¡£Ïàͬ°æ±¾£¬Õë¶Ô²»Í¬µÄ²Ù×÷ϵͳ£¬»áÓв»
ͬµÄ²¹¶¡¡£Ã¿¸ö²¹¶¡´óСԼÔÚ500MB~1.3GBÖ®¼ä¡£ÏÂÃæÒÔoracle 10.2.0.2 ²¹¶¡ÎªÀý£º
ftp updates.oracle.com
user metalib_user ÊäÈëÃÜÂë
cd 4547817
dir
p4547817_10202_AIX64-5L.zip
p4547817_10202_HP64.zip
p4547817_10202_HPUX-IA64.zip
p4547817_10202_LINUX.zip
p4547817_10202_Linux-IA64.zip
p4547817_10202_Linux-x86-64.zip
p4547817_10202_MVS.zip
p4547817_10202_SOLARIS.zip
p4547817_10202_SOLARIS64.zip
p4547817_10202_WINNT.zip
p4547817_10202_WINNT64.zip
ʹÓÃmgetÃüÁîÏÂÔØ¼´¿É¡£
½áºÏѸÀ×,¿ÉÒÔÈ¡µÃʰ빦±¶µÄЧ¹û,Á´½ÓÈçÏ£º
oracle 9206 patchset:
ftp://updates.oracle.com/3948480/p3948480_9206_AIX64-5L.zip
ftp://updates.oracle.com/3948480/p3948480_9206_HP64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_HPUX-IA64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_LINUX.zip
ftp://updates.oracle.com/3948480/p3948480_9206_Linux-x86-64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_MVS.zip
ftp://updates.oracle.com/3948480/p3948480_9206_SOLARIS.zip
ftp://updates.oracle.com/3948480/p3948480_9206_SOLARIS64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_TRU64.zip
ftp://updates.oracle.com/3948480/p3948480_9206_WINNT.zip
ftp://updates.oracle.com/3948480/p3948480_9206_WINNT64.zip
oracle 9207patch set:
ftp://updates.oracle.com/4163445/p4163445_92070_AIX64-5L.zip
ftp://updates.oracle.com/4163445/p4163445_92070_HP64.zip
ftp://updates.oracle.com/4163445/p4163445_92070_HPUX-IA64.zip
ftp://updates.oracle.com/4163445/p4163445_92070_LINUX.zip
ftp://updates.oracle.com/4163445/p4163445_92070_Linux-IA64.zip
ftp://updates.oracle.com/4163445/p4163445_
Ïà¹ØÎĵµ£º
£¨Ò»£©Data blocks £¬Extents£¬Segment
Õâ¾ÍÊÇËûÃÇÖ®¼äµÄÂß¼½á¹¹¡£
ÏÈ¿´Data blocks£¨Ò²½ÐÂß¼¿é£¬oracle¿é£¬Ò³£©°É£¬oracle´æ´¢Êý¾Ý¶¼ÊÇÔÚÕâЩÊý¾Ý¿éÖУ¬Ò»¸öÊý¾Ý¿éÊÇ´ÅÅÌÉÏÊý¾Ý¿âÎïÀí¿Õ¼äһϵÁÐÎïÀí×Ö½ÚµÄ×é³É¡£
±ÈData blocks¸ü¸ßÒ»²ãµÄÂß¼Êý¾Ý¿é¿Õ¼äÊÇe ......
ÓÉÓÚ¹«Ë¾ÒµÎñÔö³¤½Ï¿ì£¬Êý¾Ý¿âoracleѹÁ¦Ô½À´Ô½´ó£¬¹«Ë¾¿¼ÂÇÔÚÓ¦Ó÷þÎñÆ÷ Websphere ºÍ Êý¾Ý¿âoracleÖ®¼äÔö¼Ó timestenÊý¾Ý¿âÀ´ÊµÏÖÊý¾ÝµÄ¶Áд·ÖÀ룬ÁíÍâÓÉÓÚtimestenÊÇÄÚ´æÊý¾Ý¿â£¬ËùÒÔ²éѯËÙ¶ÈÉÏÒªÓÅÓÚ oracle Êý¾Ý¿â£¬Á½¸öÊý¾Ý¿âËäÈ»¶¼ÊÇoracle¹«Ë¾µÄ²úÆ·£¬µ«ÊÇÔںܶàsqlµÄд·¨ÉÏÊDz»ÏàͬµÄ£¬Ï ......
1¡¢ÐÞ¸ÄOracle×î´óÁ¬½ÓÊýµÄ·½·¨
a¡¢ÒÔsysdbaÉí·ÝµÇ½PL/SQL »òÕß Worksheet
b¡¢²éѯĿǰÁ¬½ÓÊý
show parameter processes;
c¡¢¸ü¸ÄϵͳÁ¬½ÓÊý
alter system set processes=1000 scope=spfile;
......
SELECT sde.st_area(zone) from sde.test1 ORDER BY name;//
SELECT shape from schools ORDER BY name;
SELECT objectid, sde.st_astext(SDE.ST_POINTfromSHAPE(shape,0)) AS points from schools;
SELECT name, sde.st_x (zone) "The X coordinate" from test ; //ÕýÈ·Ö´ÐÐ
SELECT name, sde.st_x (shape) "The ......
---sqlµÄº¯ÊýµÄʹÓÃ(Oracle)
---dualµÄʹÓãºÑÆÔª±í£ºÃ»ÓбíÐèÒª²éѯµÄʱºò ¿ÉÒÔÓÃËü
---select 'Hello World' from dual; ---½á¹û£ºH ......