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

ÔõÑùÇåÀíORACLEÖÐûÓõÄÊý¾Ý À´ÊÍ·ÅÓ²Å̿ռ䣿

    ͬ־ÃÇ£¬ÎÒÏÖÔÚÓиö´ÓÉú²ú»úÉÏCOPYÏÂÀ´µÄDB,ÎÒÏÐÕ¼µÃ¿Õ¼äÌ«´ó£¬Ó¦¸Ãɾ³ýµãʲô²»ÐèÒªµÄ¶«Î÷ÄØ£¿

    ²Ù×÷ϵͳ£ºLinux
              Oracle 120G


    ×îºÃ´øÃüÁлл 
Çå¿ÕTEMPÊý¾Ý,»á¼õÉÙ²»ÉÙ¿Õ¼ä

  »¹ÓÐÄØ ±ÈÈçÔõôÊÍ·Åflash_recovery_areaÀïËùÕ¼µÄÓ²Å̿ռ䣿


ÒýÓÃ
ͬ־ÃÇ£¬ÎÒÏÖÔÚÓиö´ÓÉú²ú»úÉÏCOPYÏÂÀ´µÄDB,ÎÒÏÐÕ¼µÃ¿Õ¼äÌ«´ó£¬Ó¦¸Ãɾ³ýµãʲô²»ÐèÒªµÄ¶«Î÷ÄØ£¿

    ²Ù×÷ϵͳ£ºLinux
              Oracle 120G


    ×îºÃ´øÃüÁлл


dropµô²»ÐèÒªµÄ±í¿Õ¼äºÍÊý¾ÝÎļþ

  ÔõÑùÓÃÃüÁîlog_archive_dest_1                  string      location=/u01/archive  ɾ³ýµô/u01/archive/ϵÄÈÕÖ¾£¿



Ïà¹ØÎÊ´ð£º

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ