oracle ¶¨Ê±±¸·Ý
µÚÒ»²½£º н¨Îļþ“¶¨Ê±±¸·Ý.bat”£¬ ÎļþÄÚÈÝÈçÏ£º
set tempvalue=databaseName_%date:~0,10%
set directory_temp=d:\BackUp\%tempvalue%
set file_dmp=%directory_temp%\%tempvalue%.dmp
set file_log=%directory_temp%\%tempvalue%.log
set winrarPath="C:\Program Files\WinRAR\WinRAR.exe"
set file_rar=%directory_temp%.rar
md %directory_temp%
exp username/password@serverName file=%file_dmp% log=%file_log% owner=user1,user2,user3
%winrarPath% a %file_rar% %directory_temp%
rmdir /s /q %directory_temp%
¶ÔÉÏÃæµÄ´úÂë×÷¼òҪ˵Ã÷£º
1. set name=value £º ÉèÖõ±Ç°»·¾³±äÁ¿
2. %date:~0,10% £º È¡µ±Ç°ÏµÍ³ÈÕÆÚ£¬Èç“2009£10£21”
3. winrarPath £º Äú¼ÆËã»úÉÏ WinRar µÄ°²×°Â·¾¶
4. exp username/password@serverName file=%file_dmp% log=%file_log% owner=user1,user2,user3 £º Õâ¸ö²»ÓÃÎÒ¶à×ö˵Ã÷£¬ Ó¦¸Ã¶¼ÖªµÀ£¬ Õâ¾ÍÊÇ oracle µÄµ¼³öÃüÁ Èç¹ûÓ⻶®µÄ²Î¿¼£ºhttp://blog.csdn.net/hemingwang0902/archive/2009/10/21/4710725.aspx £¨oracle ÖÐEXP¡¢IMP ÃüÁîÏê½â £©
µÚ¶þ²½£ºÐ½¨Ò»¸ö¶¨Ê±ÈÎÎñ£¬ ¾ßÌå²Ù×÷ÈçÏ£º
1. ¿ªÊ¼=> ËùÓгÌÐò=> ¸½¼þ=> ϵͳ¹¤¾ß=> ÈÎÎñ¼Æ»®==> Ìí¼ÓÈÎÎñ¼Æ»®
2. °´ÕÕ“ÈÎÎñ¼Æ»®Ïòµ¼”Ìáʾ£¬´´½¨Ò»¸ö¶¨Ê±Ö´ÐÐ´Ë bat Îļþ£¨¶¨Ê±±¸·Ý.bat£©¼´¿É
ÔÚ´Ë´¦×÷Ò»¸öССµÄ²¹³ä˵Ã÷£º Ö»ÓÐÔÚÆô¶¯ÁË“Task Scheduler”·þÎñµÄÇé¿öÏ£¬¶¨Ê±ÈÎÎñ²Å»á±»Ö´ÐС£
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ÔÚÍøÉÏËÑË÷ÁË°ëÌ죬Ö÷ÒªÔÒòÊÇoci.dllÊÇ64λµÄ,¶øPL/SQL developerÖ»ÓÐ32λµÄ,ÔÚʹÓÃ64λoci.dllÎļþʱ³ö´í.
ÔÚÍøÉÏÕÒÁ˺ܶà×ÊÁÏ,×î·½±ãµÄ½â¾ö·½°¸ÈçÏÂ:
1.µ½oracle¹ÙÍøÏÂÔØOracle InstantClient,ÎÒϵÄÊÇinstantclient-basiclite-win32-10.2.0.4.zip,°ÑËü½âѹËõµ½
oracle°²×°Ä¿Â¼productÏÂ,ÆäÖл¹ÓÐÒ»¸öĿ¼Ϊ10.2.0. ......
¡¾AUTOTRACE¡¿SQLÓÅ»¯µÄÖØÒª¹¤¾ß--AUTOTRACE
Ìáµ½SQLÓÅ»¯£¬²»Äܲ»ÌáAUTOTRACEµÄÇ¿´ó¹¦ÄÜ¡£Ê¹ÓÃÆðÀ´·Ç³£±ã½Ý£¬²»¹ýÔÚÊÇʹÓÃ֮ǰ£¬ÐèÒª×öһЩÅäÖõŤ×÷¡£¼òÒªµÄÃèÊöÒ»ÏÂÕâ¸ö¹ý³Ì£¬¹©Ã»ÓÐʹÓùýµÄÅóÓѲο¼¡£
1.ʹÓÃsysÓû§Ö´ÐÐplustrce½Å±¾
sys@ora10g> @?/sqlplus/admin/plustrce
sys@ora10g> drop role plustrace ......
ORACLEÖÐ×ֶεÄÊý¾ÝÀàÐÍ
×Ö·ûÐÍ char ·¶Î§ ×î´ó2000¸ö×Ö½Ú ¶¨³¤
char(10) 'ÕÅÈý' ºóÌí¿Õ¸ñ6¸ö°Ñ10¸ö×Ö½Ú²¹Âú 'ÕÅÈý &nb ......
µÍ³É±¾»ñÈ¡OracleÏà¹ØÈÏÖ¤£¬È«Ãæ¿ìËÙÕÆÎÕOracle¼¼Êõ
ÔÚÆóҵȺÌåÖУ¬È«Çò500Ç¿£¬ÓÐ98%ÔÚʹÓÃOracle¼¼Êõ£»È«ÇòÊ®´óÒøÐоù²ÉÓÃÁËOracleÓ¦ÓÃϵͳ£¬ÔÚÖйú£¬ÅÅÃûÇ°20λµÄÒøÐж¼ÔÚʹÓÃOracle¼¼Êõ£»ÔÚͨÐÅÁìÓò£¬È«Çò20¼Ò¶¥¼¶Í¨ÐŹ«Ë¾È«²¿¶¼ÔÚʹÓÃOracleÓ¦ÓòúÆ·¡£ÔÚÖйú£¬ËùÓеĵçÐÅÓªÔËÉ ......