OracleÊý¾Ý¿â
ɾ³ýÊý¾Ý¿â£º
1¡¢Í£Ö¹Êý¾Ý¿â·þÎñ
2¡¢É¾³ýʵÀý oradim –delete –sid liluf
3¡¢É¾³ýÊý¾Ý¿âÎļþ
ÐÂÔöÊý¾Ý¿â£º
1¡¢ ½¨Á¢Êý¾Ý¿â¡¢ÅäÖüàÌý¡¢½¨Á¢Óû§
2¡¢ ÓÃÃüÁîÆô¶¯Êý¾Ý¿â
×¢:×¢²á±íregedit HKEY_LOCAL_MACHINE-----SOFTWARE------ORACLE----HOMEO
²ÎÊýÖУºORA_LMIS_AUTOSTART=TRUE ±íʾ£ºÆô¶¯/¹Ø±Õ·þÎñʱÆô¶¯Êý¾Ý¿â
ORA_LMIS_AUTOSTART=FALSE ±íʾ£ºÆô¶¯/¹Ø±Õ·þÎñʱ²»Æô¶¯Êý¾Ý¿â
3¡¢ Æô¶¯·þÎñ
oradim -startup -sid lmis -starttype srvc
Èç¹ûÊÇ oradim -startup -sid lmis ϵͳ»á±¨´í
ORA-01031: insufficient privileges
µ«ÊDz»Ó°Ïì·þÎñµÄÆô¶¯
4¡¢ Æô¶¯Êý¾Ý¿â
1£© C:\Documents and Settings\liuf>sqlplus /nolog
2£© SQL> conn sys/liuf@lmis_liuf as sysdba
3£© SQL> select * from dual;
select * from dual
*
ERROR λÓÚµÚ 1 ÐÐ:
ORA-01034: ORACLE not available
ÓÉÓÚ²ÎÊýORA_LMIS_AUTOSTART=FALSE£¬ËùÒÔ·þÎñÆô¶¯£¬Êý¾Ý¿âûÓÐÆô¶¯
4£© SQL> startup
5¡¢ ¹Ø±ÕÊý¾Ý¿â
SQL> shutdown abort
Ö¸¶¨ÈÎÎñ¼Æ»®±¸·ÝÊý¾Ý¿â- - Oracle Tips 23
1¡¢±àдµ¼³öÅú´¦ÀíÎļþ£¨*.BAT£©
Eg: EXP liuf/**@lmis_local buffer=50000000 FILE=d:\lmissd0830.dmp LOG=d:\lmissd0830.log ōwner=liuf feedback=1000000
2¡¢Öƶ¨ÈÎÎñ¼Æ»®
¿ØÖÆÃæ°å->ÈÎÎñ¼Æ»®->Ìí¼ÓÈÎÎñ¼Æ»®£ºÌí¼ÓдºÃµÄµ¼³öÅú´¦ÀíÎļþ
3¡¢Ö¸¶¨±¸·ÝÖÜÆÚ
4¡¢ÊäÈëÆôÓÃÓû§Ãû¼°ÃÜÂë
×¢£º±ØÐëÊÇ»úÆ÷µÄÓû§ÃûºÍÃÜÂë
˵Ã÷£ºÃ¿´Î±¸·ÝµÄDMPÎļþ¶¼ÊÇÉϴεĸ²¸Ç£¬¶ø²»ÊÇDMPÎļþµÄÔö¼Ó¡£
Ô¶³Ìά»¤¹¤¾ß£PcAnyWhere - - Oracle Tips 22
Ïà¹ØÎĵµ£º
Oracle 10g×î¼ÑÁé»îÌåϵ½á¹¹£¨Optimal Flexible Architecture£¬¼òдΪOFA£©£¬ÊÇÖ¸OracleÈí¼þºÍÊý¾Ý¿âÎļþ¼°Ä¿Â¼µÄÃüÃûÔ¼¶¨ºÍ´æ´¢Î»ÖùæÔò£¬¿ÉÒÔ½«ËüÏëÏñΪһ×éºÃµÄϰ¹ß£¬ËüʹÓû§¿ÉÒÔºÜÈÝÒ×µØÕÒµ½ÓëOracleÊý¾Ý¿âÏà¹ØµÄÎļþ¼¯ºÏ¡£
ʹÓÃ×î¼ÑÁé»îÌåϵ½á¹¹£¬Äܹ»¼ò»¯Êý¾Ý¿âϵͳµÄ¹ÜÀí¹¤×÷£¬Ê¹Êý¾Ý¿â¹ÜÀíÔ±¸ü¼ÓÈÝÒ׵ض¨ ......
ÔÚSQLÓï¾äÓÅ»¯¹ý³ÌÖУ¬¾³£»áÓõ½hint,
ÒÔÏÂÊÇÔÚSQLÓÅ»¯¹ý³ÌÖг£¼ûOracleÖÐ"HINT"µÄ30¸öÓ÷¨1. /*+ALL_ROWS*/
±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯.
ÀýÈç:
SELECT /*+ALL+_ROWS*/ EMP_NO,EMP_NAM,DAT_IN from BSEMPMS WHERE EMP_NO='SCOTT';
2. /*+FIRST_ROWS*/
±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ ......
ÎÒÃÇÒª×öµ½²»µ«»áдSQL,»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQL,ÒÔÏÂΪ±ÊÕßѧϰ¡¢ÕªÂ¼¡¢²¢»ã×ܲ¿·Ö×ÊÁÏÓë´ó¼Ò·ÖÏí£¡
£¨1£© Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLEµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£ ......
Oracle,MySQL,MSSQL ServerºÍAccessÊý¾Ý¿âµÄͳ¼Æº¯Êý
ÎÒÃÇÔÚ±à³ÌÖг£ÓõÄͳ¼Æº¯ÊýÓмÆÊý,ÇóºÍ,Çó×î´óÖµ,Çó×îСֵ,Ç󯽾ù,·½²îºÍ±ê×¼²î.
·½²î(Variance)
·½²îÊDZê׼ƫ²îµÄƽ·½¡£×éÖеÄÖµ£¬ÓëËüÃÇÆ½¾ùÖµÖ®¼äÆ«Àë³Ì¶ÈµÄ¶ÈÁ¿¡£
±ê׼ƫ²î(Standard Deviation)
Ò»¸ö²ÎÊý£¬Ö¸³öÒ»ÖÖ·½Ê½£¬Ò»¸ö¸ÅÂʺ¯ÊýÒÔÕâÖÖ·½Ê½·Ö²¼ÔÚÆ½¾ùÖµ¸ ......
1,<>
2,µ¥¶ÀµÄ>,<,(ÓÐʱ»áÓõ½£¬ÓÐʱ²»»á)
3,like "%_" °Ù·ÖºÅÔÚǰ.
4,±íû·ÖÎö.
5,µ¥¶ÀÒýÓø´ºÏË÷ÒýÀï·ÇµÚһλÖõÄË÷ÒýÁÐ.
6,×Ö·ûÐÍ×Ö¶ÎΪÊý×ÖʱÔÚwhereÌõ¼þÀï²»Ìí¼ÓÒýºÅ.
7,¶ÔË÷ÒýÁнøÐÐÔËËã.ÐèÒª½¨Á¢º¯ÊýË÷Òý.
8,not in ,not exist.
9,µ±±äÁ¿²ÉÓõÄÊÇtimes±äÁ¿£¬¶ø±íµÄ×ֶβÉÓõÄÊÇdate±äÁ¿Ê±.»òÏà· ......