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

oracleÓйصÄ4¸öÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÈçÌâ:
1.OracleµÄȱʡÊý¾ÝÎļþ¸öÊý?²»Í¬µÄ°æ±¾ÊÇÒ»ÑùÂ𣿶¼ÊÇ30Âð£¿
2.expdpºÍimpdpµÄ²Ù×÷ȨÏÞ£¬ÊÇexp_full_database/imp_full_databaseÂð£¿
3.ÁÙʱ±í¿Õ¼äÓÐʲôÓã¿
4.н¨Êý¾Ý¿â,Èç¹û×¢²á±íûÓÐ...oracle/HOMExxxÕâ¸öÏÐèÒªÊÖ¶¯¼ÓÂ𣿲»¼ÓÓÐʲôӰÏ죿
»ù´¡ÖªÊ¶ ºÃºÃÕÆÎÕ ´ø¸öµÊ×ÓµÈÈ˻ظ´

1, ²»Í¬°æ±¾µÄȱʡÎļþ¸öÊý¿Ï¶¨²»Í¬£¬ÒòÎªËæ×Ű汾µÄÌá¸ß£¬oracle»áÐÂÔöһЩ¸¨ÖúµÄtablespace£¬Ò²¾Í»áÔö¼ÓһЩÊý¾ÝÎļþ£¬ÁíÍ⣬30Õâ¸öÊý×ÖÂ¥Ö÷ÔõôµÃµ½µÄ£¿ºÃÏñûÄÇô¶à¡£
2£¬²»ÊìϤ£»
3£¬ÅÅÐòʱ»áÓõ½ÁÙʱ±í¿Õ¼ä
4£¬³ý·ÇÄãÊÖ¹¤É¾³ý£¬Ò»°ã×¢²á±í¶¼ÓжÔӦѡÏ

ÒýÓÃ
1, ²»Í¬°æ±¾µÄȱʡÎļþ¸öÊý¿Ï¶¨²»Í¬£¬ÒòÎªËæ×Ű汾µÄÌá¸ß£¬oracle»áÐÂÔöһЩ¸¨ÖúµÄtablespace£¬Ò²¾Í»áÔö¼ÓһЩÊý¾ÝÎļþ£¬ÁíÍ⣬30Õâ¸öÊý×ÖÂ¥Ö÷ÔõôµÃµ½µÄ£¿ºÃÏñûÄÇô¶à¡£
4£¬³ý·ÇÄãÊÖ¹¤É¾³ý£¬Ò»°ã×¢²á±í¶¼ÓжÔӦѡÏ

  1.¼ÇµÃ²»ÊǺÜÇå³þÁË£¡²»ÖªÊÇ10g»¹ÊÇ11g£¬Ä¬ÈϵÄÊý¾ÝÎļþ¸öÊýÊÇ30£¬µ±È»Ëæ×ÅÒµÎñµÄÔö³¤£¬¿ÉÒÔÔÚ¿ØÖÆÎļþÖУ¬»¹¿ÉÒÔÐÞ¸Ä×î´óÊý¾ÝÎļþµÄ¸öÊý¡£
  4.²»ÊÇɾ³ý£¬ÊÇÎÒ´´½¨µÄÊý¾Ý¿âÍêºó£¬×¢²á±íÖÐûÓÐÕâ¸ö¶ÔÓ¦Ï


×Ô¼º¶¥Ï£¡

1.OracleµÄȱʡÊý¾ÝÎļþ¸öÊý?²»Í¬µÄ°æ±¾ÊÇÒ»ÑùÂ𣿶¼ÊÇ30Âð£¿
2.expdpºÍimpdpµÄ²Ù×÷ȨÏÞ£¬ÊÇexp_full_database/imp_full_databaseÂð£¿
3.ÁÙʱ±í¿Õ¼äÓÐʲôÓã¿
4.н¨Êý¾Ý¿â,Èç¹û×¢²á±íûÓÐ...oracle/HOMExxxÕâ¸öÏÐèÒªÊÖ¶¯¼ÓÂ𣿲»¼ÓÓÐʲôӰÏ죿

tangren ÒѾ­»Ø´ðÁËÄãµÄÎÊÌâÁËѽ

Ö§³Ö tangren

·¹ý ·¢Ò»ÏÂ

¶¥Ò»ÏÂ
 oracle QQȺºÅ£º54775466
  »¶Ó­Õâ·½Ã


Ïà¹ØÎÊ´ð£º

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

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

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

ÒýÓÃ
oracle ......

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

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

oracleµÄ°²×°ºÍʹÓúÃÄѰ¡ - Java / Java EE

oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿Ô­À´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......

Oracle ¸ßÊÖ½ø - Java / Java EE

SELECT * from (SELECT A.*, ROWNUM RN from (SELECT * from t_out_logon) A WHERE ROWNUM <= 30)WHERE RN >= 21
SELECT A.* from (SELECT t.*,rownum rn from t_out_logon t WHERE ROWNUM <= 30) A WHERE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ