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

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Ê÷ÖÐpriorµÄÓ÷¨

Êý¾Ý˵Ã÷Ò»ÇУº
create table dept(deptno number,deptname varchar2(20),mgrno number);
insert into dept values (1, '×ܹ«Ë¾', null);
insert into dept values (2, 'Õã½­·Ö¹«Ë¾', 1);
insert into dept values (3, 'º¼ÖÝ·Ö¹«Ë¾', 2);
commit;
select t.* from dept t;
      DEPTNO &n ......

dz̸OracleÊý¾Ý¿âSCNºÅ

OracleÊý¾Ý¿âSCNºÅÏê½â:
¡¡¡¡ÏµÍ³¼ì²éµãscn(v$database(checkpoint_change#))
¡¡¡¡Êý¾ÝÎļþ¼ì²éµã(v$datafile(checkpoint_change#))
¡¡¡¡Êý¾ÝÎļþÖÕÖ¹scn(v$datafile(last_change#))
¡¡¡¡Êý¾ÝÎļþÖдæ·ÅµÄ¼ì²éµã
¡¡¡¡Æô¶¯scn (v$datafile_header(checkpoint_change#)
¡¡¡¡1¡¢ÏµÍ³¼ì²éµãscn
¡¡¡¡µ±Ò»¸ö¼ì²éµã¶¯×÷Íê³ ......

ÔÚhibernateÖÐʵÏÖoracleµÄÖ÷¼ü×ÔÔö²ßÂÔ

ת×Ô£ºhttp://blog.csdn.net/scorpio3k/archive/2009/05/09/4162079.aspx
 ÔںܶàÇé¿öÏ£¬ÎÒÃÇʹÓÃHibernateÔÚÒѾ­½¨Á¢ºÃÊý¾Ý¿âµÄ»ù´¡ÉÏ¡£ÔÚoracleÖУ¬Èç¹ûÒѾ­½¨Á¢ºÃµÄÊý¾Ý¿âÖÐʹÓÃÁËsequence
,Ôò¿ÉÒÔ°´ÕÕÏÂÃæµÄ²½Öè°ÑËüÒýÈëµ½HibernateÖУº
   
   1¡¢ÔÚoracle Ê×ÏÈ´´½¨sequence ......

Oracle ´æ´¢¹ý³Ì ¶¨Òå ºÍ Óŵã

 
¶¨Ò壺
´æ´¢¹ý³Ì£¨Stored Procedure £©ÊÇÒ»×éΪÁËÍê³ÉÌØ¶¨¹¦ÄܵÄSQL Óï¾ä¼¯£¬¾­±àÒëºó´æ´¢ÔÚÊý¾Ý¿âÖС£Óû§Í¨¹ýÖ¸¶¨´æ´¢¹ý³ÌµÄÃû×Ö²¢¸ø³ö²ÎÊý£¨Èç¹û¸Ã´æ´¢¹ý³Ì´øÓвÎÊý£©À´Ö´ÐÐËü¡£´æ´¢¹ý³ÌÊÇÊý¾Ý¿âÖеÄÒ»¸öÖØÒª¶ÔÏó£¬ÈκÎÒ»¸öÉè¼ÆÁ¼ºÃµÄÊý¾Ý¿âÓ¦ÓóÌÐò¶¼Ó¦¸ÃÓõ½´æ´¢¹ý³Ì¡£ ´æ´¢¹ý³ÌÊÇÓÉÁ÷¿ØÖƺÍSQL Óï¾äÊéдµÄ¹ý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ