oracle Êý¾Ý¿â±¸·Ý
È«Êý¾Ý¿â±¸·Ý½¨ÒéÓÃoracle×Ô´øµÄ expÃüÁî¡£
µ¼Ä³ÕűíµÄ»°£¬»òÕß±¸·Ýij¸öÓû§µÄÐÅÏ¢£¬¿ÉÒÔµ½
Tool-¡·export table µ¼±í
Tool-¡·export user object µ¼Óû§µÄÊý¾Ý¡£
-----------------------------------------------------------------------------------------
ÔÚoracleÖÐ,Ö´ÐÐsqlÎļþ,¿ÉÒÔдһ¸öÅú´¦ÀíÎļþ
sqlplus scott/tiger@orcl @c:\example.sql
Ö´ÐÐÅú´¦ÀíÎļþ¾ÍÐÐÁË
Ïà¹ØÎĵµ£º
.net Ô¶³ÌÁ¬½ÓOracleÊý¾Ý¿â¿´ÆðÀ´Í¦¼òµ¥µÄ£¬µ«Êµ¼Ê×öÆðÀ´»¹ÊÇÓöµ½²»ÉÙÎÊÌâ¡£°ÑÎÒ½ñÌìÕÛÌÚÕâ¸ö¶«Î÷µÄ¾Ñ鏸´ó¼Ò¹²Ïí°É¡£
¡¡¡¡·ÃÎÊ oracle Êý¾Ý¿âµÄ·½Ê½ºÜ¶à£¬ÎÒÓõÄÊÇ OleDbConnection£¬Õâ¸öûʲôºÃ˵µÄ£¬´úÂëÈçÏ£º
¡¡¡¡1. Á¬½Ó´úÂë
¡¡_OleDbConnection¡¡=¡¡new¡¡OleDbConnection(connectionString);
¡¡¡ ......
OracleÊý¾Ý¿âµ¼Èëµ¼³ö£¨1£©
Oracleµ¼Èëµ¼³ö¹Ù·½¶¨Òå
ÈçºÎ²é¿´ImpºÍExpÃüÁ
ǰÌ᣺°²×°OracleÊý¾Ý¿â»òÕ߿ͻ§¶Ë¡£
Ò»¡¢ IMPÃüÁî
1. ´ò¿ªÃüÁîÌáʾ·û¡£ÀýÈ磬£¨Windows XP£© ......
Êý¾Ý¿âѹÁ¦²âÊÔ
Ò»¡¢ÓÃorabm²âÊÔÊý¾Ý¿âCPU
Orabmͨ¹ýÔÚÓû§Ö¸¶¨µÄ²¢·¢ÏÂÔËÐÐÖ¸¶¨ÊýÁ¿µÄÊÂÎñÀ´²âÊÔϵͳÐÔÄÜ.ËüÖ÷Òª²âÊÔÊý¾Ý¿â·þÎñÆ÷µÄCPUÐÔÄܺÍÄÚ´æ¡£
orabmʵ¼ÊÉÏÊÇÒ»¶ÑsqlµÄ¼¯ºÏ¡£
orabm¿ÉÒÔÓÃÔÚlinux/windows/solarisÏÂʹÓá£
orabm²»Ò»¶¨ÐèÒªÔËÐÐÔÚÊý¾Ý¿âËùÔÚ·þÎñÆ÷ÉÏ£¬Ëü¿ÉÒÔÔËÐÐÔÚÈκΰ²×°ÁË9i¿Í»§¶ËµÄÖÕ¶ËÉÏ¡£Äã ......
sql*plus ÃüÁî
//Ö´Ðнű¾
@ºÍstart d:/a.txt;
//Ð޸Ľű¾
edit d:/a.txt;
//½«ÄÚÈÝÊäÈëµ½Îı¾ÖÐ
sloop d:/a.txt; //¿ªÊ¼¼Ç¼ÆÁÄ»ÄÚÈÝ
sloop off; //¼Ç¼½áÊø
//Á´½ÓµÇ¼Êý¾Ý¿â
connect system/919959 as sysdba/sysoper; //ȨÏÞ×î´ódba
connect sys/919959;
connect scott/ti ......