΢Èí£º×ö×Ô¼ºµÄǨÒƹ¤¾ß£¬ÈÃOracleÈ¥×ż±°É£¡
¿ªÔ´¿çƽ̨±à³ÌÓïÑÔJava¼ÓÉÏ¿ªÔ´Êý¾Ý¿âMySQL£¡×ÔSunÊÕ¹ºMySQL¿ªÊ¼£¬±¾ÒÔΪSun½«´óÕ¹ºêͼ¡£È»SunȴûÓаÑÎÕ»ú»á£¬·´¶øûÓнûµÃס½ðÈÚΣ»úµÄ³å»÷¡£ÂäµÃ¸öÃæÁÙÊÕ¹ºµÄ¾ÖÃæ¡£»òÐíMySQLÖ®¸¸Richard StallmanÒ²¾ø¶ÔûÓÐÏëµ½£¬ÈÃSunÊÕ¹ºMySQL£¬È´ÊÇ°ÑMySQLÍÆÏòÁËÉîÔ¨¡£MySQLµÄºÎÈ¥ºÎ´Ó£¡
Ãæ¶ÔÕâ¸öÎÊÌ⣬MySQLÖ®¸¸Richard StallmanºÍÓû§½Ï¶àµÄÅ·ÃË×ø²»×¡ÁË¡£Richard Stallman·¢±íÉùÃ÷£ºMySQL±»²¢¹º ¿ªÔ´Êý¾Ý¿â½«µ¹ÍËÊ®Ä꣬²¢ÏòÅ·ÖÞίԱ»áµÄίԱNeelie Kroes£¬ÇëÇó²»ÒªÈÃOracleºÏ²¢MySQL¡£Å·ÃËÔòÒ»Ö±ÍƳÙÉóÅú¡£
Õⳡ·×Õù»ñÀûÊÇË£¿
Ê×ÏÈ£¬¿´×î½üµÄ±¨µÀ£ºÎ¢Èí·¢²¼MySQL to SQL ServerǨÒƹ¤¾ß CTP1.0 ¡£
΢ÈíЦÁË£¬ÕýËùν£¬Ö»Òª³úÍ·ÎèµÃºÃ£¬Ã»ÓÐǽ½ÇÍÚ²»µ¹£¨ÓÉÓÚûÓÐʹÓùýCTP1.0£¬Ôݲ»¶Ô΢ÈíµÄÕâ°Ñ³úÍ·½øÐÐÆÀ¼Û£©¡£¸üºÎ¿öÏÖÔÚMySQLµÄ´¦¾³ÓÖÊÇÈç´ËµÄÈÃÈ˵£ÓÇ£¬Óû§Á÷ʧÊDZØÈ»µÄ¡£Î¢Èí¿ªÊ³MySQLµÄÊг¡·Ý¶îµÄÕâÖÖ×ö·¨£¬ÕâÎÞÒÉÊǸøMySQLµÄµ±Í·Ò»°ô¡£OracleÄØ£¿ÎÒÏëËüÒ²Ïë·¢²¼Ò»¸öǨÒƹ¤¾ß°É¡£²»¹ýÏÔÈ»£¬OracleÖ»ÄÜ¿´×Å΢ÈíÇÀÓû§£¬×Ô¼ºÈ´²»ÄÜ×öÈκÎÊÂÇé¡£ÒòΪ£¬Ò»µ©OracleÒ²·¢²¼Ç¨Òƹ¤¾ß£¬ÄÇôŷÃ˵ÄÉóÅú£¬ÊÇÌú¶¨Í¨²»¹ýµÄ£¡Ö»ÄÜ´óÉùµÄºôÓõ£ºÒ»¶¨»á±£³ÖMySQLµÄ¶ÀÁ¢¡£¿ÉÊÇ×î½ü¼¸ÄêOracleµÄһϵÁÐÊÕ¹ºÊÖ·¨È´ÈÃÈ˲»¸ÒÏàÐÅ¡£
΢ÈíÔòЦºÇºÇµÄ˵£º×ö×Ô¼ºµÄǨÒƹ¤¾ß£¬ÈÃOracleÈ¥×ż±°É£¡
Ïà¹ØÎĵµ£º
extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î» --segment management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......
×÷Ϊһ¸öORACLE DBA,ÔÚ¹¤×÷Öлᾳ£´¦ÀíÓÉÓÚ×Ö·û¼¯²úÉúµÄһЩÎÊÌâ¡£µ«Êǵ±ÕæÕýÏëдһЩÕâ·½ÃæµÄ¶«Î÷ʱ£¬È´Í»È»ÓÖûÓÐÁËÍ·Ð÷¡£·¢ÁË°ëÌì´ô£¬»¹ÊǾö¶¨ÓÃÁ½¸ö×Ö·û¼¯·½ÃæµÄÀý×Ó×÷ΪÇÐÈëµã£¬µ¹²»Ê§ÎªÒ»¸öÍ·Ð÷£¬Ëµ²»¶¨ÔÚʵÑéµÄ¹ý³ÌÖУ¬ÎÊÌâ¾Í»áÒ»¸ö½Ó×ÅÒ»¸öµÄ¸¡ÏÖ³öÀ´¡£
ÏÖÔÚ£¬ÈÃÎÒÃÇÇÐÈëÕýÌâ¡£
ÎÒÓõÄÊý¾Ý¿âÊÇoracle10.2.0.3,Êý ......
create table test1 as select 1 id,'create table test2(id number,name varchar2(200));insert into test2 values(1,''a'');' sqltext from dual
2 union all select 2,'truncate table test2;' from dual
3 union all select 3,'insert into test2 select rownum,dbms_random.string(''l'', ......
Á·Ï°:
drop table Employee;
create table Employee(
id number primary key,
  ......
oracleÈÃid×Ô¶¯Ôö³¤£¨insertʱ²»ÓÃÊÖ¶¯²åÈëid£©µÄ°ì·¨£¬ÏñMysqlÖеÄauto_incrementÄÇÑù
´´½¨ÐòÁÐ
create sequence emp_seq
increment by 1
start with 1
nomaxvalue
nocycle
......