OracleÊý¾Ý¿âµÄµ¼Èëµ¼³ö
oracleÊý¾Ý¿âµÄµ¼ÈëÓëµ¼³öÊÇ×öΪһÃûʵʩ¹¤³Ìʦ»òά»¤¹¤³Ìʦÿ¾³£Òª×öµÄ¹¤×÷¡£µ±Êý¾Ý¿â½á¹¹ÐèÒª×ö±ä»¯µÄʱºò£¬ÎÒÃÇÒ»°ãÏȽ«Êý¾Ý×ö±¸·Ý£¬´ËʱÎÒÃÇÐèҪʹÓõ½OracleµÄµ¼³ö¹¦ÄÜ¡£µ±ÎÒÃÇÔÚ×öµ¼ÈëµÄʱºò³ö´í»òÕßÎÒÃǵÄÊý¾ÝÔâµ½´íÎóɾ³ýµÄʱºò£¬ÎÒÃÇÐèÒª»Ö¸´Êý¾Ý¿â£¬ÄÇÎÒÃÇÐèҪʹÓõ½µ¼ÈëµÄ¹¦ÄÜ¡£ÏÖÔÚÒ²Óкܶ๦ÄÜÄܹ»°ïÎÒÃÇ×öµ½ÕâÒ»µã£¬µ«ÎÒÃÇÒ²²»¿ÉÄÜʱʱ¿Ì¿Ì½«¹¤¾ß´øÔÚÉíÉÏ£¬ÔÚÉú²ú»úÉÏÃæ£¬ÎÒÃÇÒ»°ã²»»á°²×°Ò»Ð©¹ÜÀíÈí¼þ£¬¶øÊÇʹÓÃOracleËùÌṩµÄÃüÁîÐй¤¾ßÀ´½øÐÐÊý¾Ý¿âά»¤¡£
oracleÊý¾Ý¿âµÄµ¼³ö£º
exp manbu@WALK file=d:/manbu.dmp
ÆäÖÐ
exp£ºÊǵ¼³öµÄÃüÃû
manbu£ºÊý¾Ý¿âÓû§
@WALK£º±íʾÄĸöÊý¾Ý¿âµÄ
file£º±íʾµ¼³öµÄÊý¾Ý¿âÎļþµØÖ·¼°ÎļþÃû
Óû§¿ÉÒÔͨ¹ýexp -help²éѯexpµÄ²ÎÊý°ïÖúÐÅÏ¢
oracleÊý¾Ý¿âµÄµ¼È룺
imp zizz@WALK file=d:/manbu.dmp fromuser=manbu touser=zizz
ÆäÖУº
impÊǵ¼ÈëµÄÃüÃû
zizzΪÊý¾Ý¿âµÄijһ¸öÓû§
@WALK£º±íʾÄĸöÊý¾Ý¿â
file£º±íʾµ¼ÈëµÄÊý¾Ý¿âÎļþ
fromuser£º±íʾԴÊý¾Ý¿âµÄÓû§
touser£º±íʾµ¼ÈëµÄÊý¾Ý¸øË
Óû§¿ÉÒÔͨ¹ýimp -help²éѯimpµÄ²ÎÊý°ïÖúÐÅÏ¢
Ïà¹ØÎĵµ£º
COMMITÊÇÒ»¸ö·Ç³£¿ìµÄ²Ù×÷£¬µ±ÎÒÃÇ·¢²¼commitÃüÁîʱ£¬ÕæÕýÀ§Äѵ͝×÷ÒѾÍê³É£¬
ÔÚÊý¾Ý¿âÖÐÒѾִÐÐÁËÊý¾Ý¸ü¸Ä£¬ËùÒÔÒѾÍê³ÉÁË99%µÄÈÎÎñ£¬ÀýÈ磺ÏÂÁвÙ×÷ÒѾ²úÉú£º
1.ÔÚSGA(Buffer Cache)ÖÐÒѾÉú³ÉÁËundo¿é£»
2.ÔÚSGA(Buffer Cache)ÖÐÒѾÉú³ ......
OracleÈÕÆÚº¯Êýѧϰʱ£¬Ôڽ̳ÌÓм¸¸öʵÀýÈçÏ£º
Months_between(’01-sep-95’, ’11-jan-94’)
½á¹ûÊÇ£º19.6774194
Add_months ÔÚÖ¸¶¨µÄÔ·ÝÉÏÃæÔö¼ÓÏàÓ¦µÃÔ·Ý
ÀýÈ磺
Add_months(’11-jan-94’, 6)
½á¹ûÊÇ£º11-jul-94
Next_day ¼ÆËã¹æ¶¨Èͮ򵀼óÒ»¸öÌØ¶¨ÈÕÆÚ
ÀýÈ磺
Next_ ......
±¸·ÝµÄ·½·¨
ORACLEÊý¾Ý¿âÓÐÈýÖÖ±ê×¼µÄ±¸·Ý¡£µ¼³ö/µ¼Èë(EXPORT/IMPORT) ¡¢À䱸·Ý¡¢Èȱ¸·Ý¡£
µ¼³ö±¸·ÝÊÇÒ»ÖÖÂß¼±¸·Ý£¬ÕâÖÖ·½·¨°üÀ¨¶ÁȡһϵÁеÄÊý¾Ý¿âÈÕÖ¾£¬²¢Ð´ÈëÎļþÖУ¬ÕâЩÈÕÖ¾µÄ¶ÁÈ¡ÓëÆäËù´¦Î»ÖÃÎ޹ء£
À䱸·ÝºÍÈȱ¸·ÝÊÇÎïÀí±¸·Ý(Ò²³ÆµÍ¼¶±¸·Ý)£¬ËüÉæ¼°µ½ ......
Oracle
ÖеÄÈÕÆÚÀàÐͼ°ÆäÏà¹ØµÄº¯Êý
Oracle
ÌṩÁ˺ܶàµÄÄÚÖõÄÈÕÆÚÀàÐÍ£¬°üÀ¨Èçϼ¸ÖÖ£º
Date
Timestamp
Timestamp With Time Zone
Timestamp With Local Time Zone
Interval Year To Month
Interval Day To Second
DateÀàÐÍÓÃÓÚ´æ´¢ÈÕÆÚ£¬¾«È·µ½Ã룬¿ÉÄÜͨ¹ýÉèÖÃNLS_DATE_FORMAT»òÕßTO_CHAR·½·¨À´¸ñʽ»¯ÈÕÆÚµÄÊ ......