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

ÔÚORACLEºÍsql serverÖмòµ¥±¸·ÝtableµÄ·½·¨

Èç¹ûtemp_t1²»´æÔÚ£¬
oracle:
create table temp_t1
as
select * from t1
sql server:
select * into temp_t1 from t1
Èç¹ûtemp_t1´æÔÚ£¬
oracle:
insert into table temp_t1
select * from t1
sql server:
insert into table temp_t1
select * from t1


Ïà¹ØÎĵµ£º

OracleÊý¾Ý¿âÖÐË÷ÒýµÄά»¤

±¾ÎÄÖ»ÌÖÂÛOracleÖÐ×î³£¼ûµÄË÷Òý£¬¼´ÊÇB-treeË÷Òý¡£±¾ÎÄÖÐÉæ¼°µÄÊý¾Ý¿â°æ±¾ÊÇOracle8i¡£
¡¡¡¡Ò». ²é¿´ÏµÍ³±íÖеÄÓû§Ë÷Òý
¡¡¡¡ÔÚOracleÖУ¬SYSTEM±íÊǰ²×°Êý¾Ý¿âʱ×Ô¶¯½¨Á¢µÄ£¬Ëü°üº¬Êý¾Ý¿âµÄÈ«²¿Êý¾Ý×ֵ䣬´æ´¢¹ý³Ì¡¢°ü¡¢º¯ÊýºÍ´¥·¢Æ÷µÄ¶¨ÒåÒÔ¼°ÏµÍ³»Ø¹ö¶Î¡£
¡¡¡¡Ò»°ãÀ´Ëµ£¬Ó¦¸Ã¾¡Á¿±ÜÃâÔÚSYSTEM±íÖд洢·ÇSYSTEMÓû§µÄ ......

Oracle ASM´æ´¢·½Ê½Ç³Îö


AU
ASMµÄ×îС·ÖÅäµ¥Ôª£¬Ä¬ÈÏÊÇ1M£¬¿ÉÒÔÔÚ´´½¨diskgroupʱָ¶¨¡£ÔÚdiskgroupÖеÄÿ¸öÅ̶¼±»ÇзÖΪºÜ¶à¸öAU£¬¿ÉÒÔÊÇ1, 2, 4, 8, 16, 32, or 64MB¡£
File Extent
ÓÉÒ»¸ö»ò¶à¸öAU×é³É£¬Ò»¸öfile extent×ÜÊÇÔÚÒ»¿é´ÅÅÌÉÏ£¨²»¿ç´ÅÅÌ·ÖÅäAU£©£¬ÕâÀïµÄfile extentºÍÊý¾Ý¿âÖеÄextentÊDz»Í¬µÄ£¬ÎÒÃÇ¿ÉÒÔÕâÑùÀí½â£¬ÕâÀïµÄfile ex ......

ORACLEÉó¼Æ

1¡¢Ê²Ã´ÊÇÉó¼Æ
É󼯣¨Audit)ÓÃÓÚ¼àÊÓÓû§ËùÖ´ÐеÄÊý¾Ý¿â²Ù×÷£¬²¢ÇÒOracle»á½«É󼯏ú×Ù½á¹û´æ·Åµ½OSÎļþ£¨Ä¬ÈÏλÖÃΪ$ORACLE_BASE/admin/$ORACLE_SID/adump/£©»òÊý¾Ý¿â£¨´æ´¢ÔÚsystem±í¿Õ¼äÖÐµÄ SYS.AUD$±íÖУ¬¿Éͨ¹ýÊÓͼdba_audit_trail²é¿´£©ÖС£Ä¬ÈÏÇé¿öÏÂÉó¼ÆÊÇûÓпªÆôµÄ¡£
²»¹ÜÄãÊÇ·ñ´ò¿ªÊý¾Ý¿âµÄÉ󼯹¦ÄÜ£¬ÒÔÏÂÕâЩ ......

oracle×ܽá

²éѯ£ºselectÓï¾ä£¬¶à±í²éѯ£¬group by ·Ö×飬having ¶Ô·Ö×éºóµÄÿһ¸ö×é½øÐйýÂË£¬order by ÅÅÐò¡£(selectÓï¾ä¶à±í²éѯÕâ¸ö×îÖØÒª)
DMLÓï¾ä£ºinsert into emp() values(),insert into emp (select * from emp2),
    delete from emp where...
    update emp set sal =.. where ..
rollback;»Ö¸´ ......

SQLÓï¾äЧÂÊÎÊÌâµÄ¼¸µã×ܽá

1. SQLÓÅ»¯µÄÔ­ÔòÊÇ£º
  ½«Ò»´Î²Ù×÷ÐèÒª¶ÁÈ¡µÄBLOCKÊý¼õµ½×îµÍ,¼´ÔÚ×î¶ÌµÄʱ¼ä´ïµ½×î´óµÄÊý¾ÝÍÌÍÂÁ¿¡£  
  µ÷Õû²»Á¼SQLͨ³£¿ÉÒÔ´ÓÒÔϼ¸µãÇÐÈ룺  
  ¼ì²é²»Á¼µÄSQL£¬¿¼ÂÇÆäд·¨ÊÇ·ñ»¹ÓпÉÓÅ»¯ÄÚÈÝ  
  ¼ì²é×Ó²éѯ   ¿¼ÂÇSQL×Ó²éѯÊÇ·ñ¿ÉÒÔÓüòµ¥Á¬½Óµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ