Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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
  »¶Ó­Õâ·½Ã


Ïà¹ØÎÊ´ð£º

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

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

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

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log 
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......

¹ØÓÚOracle´¥·¢Æ÷µÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

Ö÷ÒªÏëʵÏÖ£ºÔÚÿÌìµÄ0µã֮ǰ×Ô¶¯½«Êý¾Ý²åÈëÊý¾Ý¿â£¬Ï£Íû´ó¼ÒÖ¸µã£¡
×Ô¶¯²åÈë?Êý¾ÝÔ´ÄÄÀïÀ´µÄ,²åÈ뵽ʲôµØ·½
´¥·¢Æ÷?
Ó¦¸ÃÓÃJOB

Êý¾ÝÔ´ÔÝʱÏëµÄÊǹ̶¨Êý¾Ý£¬²åÈëµ½Ò»Õűí

ÄǾÍÊÇÓÃJOB¶¨Ê±Ö´ÐÐ,´ÓÎļþµ¼ÈëÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ