Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

toad for oracle(µ¼Èëµ¼³öʵÀý)

Àý£º
create user his identified by his default tablespace users temporary tablespace temp;
grant connect,resource,dba to his;
create tablespace his
logging
datafile 'd:\oracle\product\10.2.0\oradata\zjxsh\his.ora' size 100M extent
management local segment space management auto;
exp his/ny@ny file=d:\0706ny full=y
exp his/his@xshis file=d:\0724xshis full=y
imp his/his@zjxshis file=d:\0724xshis.DMP fromuser=(his£¬chk£¬emr£¬fee£¬inv£¬med£¬opr£¬dig)touser=(his£¬chk£¬emr£¬fee£¬inv£¬med£¬opr£¬dig) ignore=y
imp his/his@zjxsh file=d:\0724xshis.DMP fromuser=his touser=his ignore=y
imp chk/chk@zjxsh file=d:\0724xshis.DMP fromuser=chk touser=chk ignore=y
imp emr/emr@zjxsh file=d:\0724xshis.DMP fromuser=emr touser=emr ignore=y
imp fee/fee@zjxsh file=d:\0724xshis.DMP fromuser=fee touser=fee ignore=y
imp inv/inv@zjxsh file=d:\0724xshis.DMP fromuser=inv touser=inv ignore=y
imp med/med@zjxsh file=d:\0724xshis.DMP fromuser=med touser=med ignore=y
imp opr/opr@zjxsh file=d:\0724xshis.DMP fromuser=opr touser=opr ignore=y
imp dig/dig@zjxsh file=d:\0724xshis.DMP fromuser=dig touser=dig ignore=y
imp mat/mat@zjxsh file=d:\0724xshis.DMP fromuser=mat touser=mat ignore=y
imp pas/pas@zjxsh file=d:\0724xshis.DMP fromuser=pas touser=pas ignore=y
create table name2 as select * from name1;
 insert into name3  select * from name2;(*±íʾ±í×ֶΣ¬°´Ë³Ðò²åÈë)
ÓÐʱºòÎÒÃÇ»áÓöµ½ÕâÑùµÄÇé¿ö£¬ÏÖÓеÄÊý¾Ý¿âÒª´ÓÒ»¸ö»úÆ÷תÒƵ½ÁíÍâÒ»¸ö»úÆ÷ÉÏ£¬Ò»°ãÎÒÃÇ»áʹÓõ¼³ö£¬µ¼Èë¡£µ«ÊÇÈç¹ûÊý¾Ý¿âµÄÊý¾Ý·Ç³£¶à£¬Êý¾ÝÎļþ³ß´çºÜ´ó£¬ÄÇôÔÚµ¼³öµ¼ÈëµÄ¹ý³Ì¾ÍºÜ¿ÉÄÜ»á³öÏÖÎÊÌ⣬²¢ÇÒÂþ³¤µÄ¹ý³ÌÒ²ÊÇÎÒÃÇÎÞ·¨ÈÝÈ̵ġ£ ÔÚÕâÖÖÇé¿öÏ£¬ÎÒÃÇ¿ÉÒÔ¼òµ¥µØʹÓòÙ×÷ϵͳµÄcopyÃüÁֱ½Ó½øÐÐÊý¾Ý¿âµÄתÒÆ¡£ÒÔÏÂʾÀý¾ùÔÚRedhat Fedora Core 1ÉϵÄOracle9.2.0.1ÖвÙ×÷£¬ÆäËü²Ù×÷ϵͳºÍOracle°æ±¾Í¬ÑùÊÊÓ᣼ÙÉèÎÒÃǵÄÊý¾Ý¿âÔÚ·þÎñÆ÷AÉÏ£¬$ORACLE_BASEÊÇ/oracle£¬$ORACLE_HOMEÊÇ /oracle/prodUCt/9.2.0¡£ÏÖÔÚÎÒÃÇÒª½«´ËÊý¾Ý¿âתÒƵ½·þÎñÆ÷BÉÏ£¬²¢ÇÒеÄ$ORACLE_BASEÊÇ/u01/oracle£¬$ ORACLE_HOMEÊÇ/u01/oracle/product/9.2.0¡£SIDÊÇoraLinux¡£
²Ù×÷²½ÖèÈçÏ£º


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

Oracleѧϰ±Ê¼Çժ¼6


  declare
  begin
   --SQLÓï¾ä
   --Ö±½ÓдµÄSQLÓï¾ä(DML/TCL)
   --¼ä½Óдexecute immediate <DDL/DCLÃüÁî×Ö·û´®>
   --select Óï¾ä
        <1>±ØÐë´øÓÐinto×Ó¾ä
      &n ......

MySQLºÍOracleµÄһЩ²Ù×÷Çø±ð

 ÓкܶàÓ¦ÓÃÏîÄ¿, ¸ÕÆð²½µÄʱºòÓÃMYSQLÊý¾Ý¿â»ù±¾ÉÏÄÜʵÏÖ¸÷ÖÖ¹¦ÄÜÐèÇó£¬Ëæ×ÅÓ¦ÓÃÓû§µÄÔö¶à£¬Êý¾ÝÁ¿µÄÔö¼Ó£¬MYSQL½¥½¥µØ³öÏÖ²»¿°ÖظºµÄÇé¿ö£ºÁ¬½ÓºÜÂýÉõÖÁå´»ú£¬ÓÚÊǾÍÓаÑÊý¾Ý´ÓMYSQLǨµ½ORACLEµÄÐèÇó£¬Ó¦ÓóÌÐòÒ²ÒªÏàÓ¦×öһЩÐ޸ġ£±¾ÈË×ܽá³öÒÔϼ¸µã×¢ÒâÊÂÏϣÍû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
1£® ×Ô¶¯Ôö³¤µÄÊý¾ ......

OracleʹÓõÄhintsµ÷Õû»úÖÆ

 
10gÊý¾Ý¿â½éÉÜ£º¿ÉÒÔʹÓøü¶àеÄoptimizer hintsÀ´¿ØÖÆÓÅ»¯ÐÐΪ¡£ÏÖÔÚÈÃÎÒÃÇ¿ìËÙ½âÎöÒ»ÏÂÕâЩǿ´óµÄÐÂhints:
spread_min_analysis

ʹÓÃÕâÒ»hint£¬Äã¿ÉÒÔºöÂÔһЩ¹ØÓÚÈçÏêϸµÄ¹ØϵÒÀÀµÍ¼·ÖÎöµÈµç×Ó±í¸ñµÄ±àÒëʱ¼äÓÅ»¯¹æÔò¡£ÆäËûµÄһЩÓÅ»¯£¬Èç´´½¨¹ýÂËÒÔÓÐÑ¡ÔñÐԵĶ¨Î»µç×Ó±í¸ñ·ÃÎʽṹ²¢ÏÞÖÆÐÞ¶©¹æÔòµÈ£¬µÃµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ