²âÊÔÁ½ÖÖoracleÊý¾Ý¿âµ¼³ö·½Ê½µÄʱ¼äЧÂÊ
×òÌì×öÁËÒ»¸öÊý¾Ý¿âµ¼³öµÄʵÑ飬Ö÷ÒªÓÃÀ´²âÊÔexpÃüÁîµÄЧÂÊ
´´½¨Ò»¸öÎļþ CalExpTime.bat£¬ÄÚÈÝÈçÏ£º
echo %time% >time.log
exp user/psw file=exp1.dmp
echo %time% >>time.log
echo %time% >>time.log
exp user/psw file=exp2.dmp direct=y
echo %time% >>time.log
Ë«»÷ÔËÐиÃÅú´¦ÀíÎļþ¡£
×îºóÉú³ÉµÄtime.logÎļþÄÚÈÝÈçÏ£º
22:24:12.82
23:12:12.20
23:12:12.23
23:34:12.12
¿É¼û
µÚÒ»·Ýµ¼³öÃüÁîexp user/psw file=exp1.dmp
ºÄʱΪ£º£¨23:12:12.20-22:24:12.82£©=Ô¼48minute
µÚÒ»·Ýµ¼³öÃüÁîexp user/psw file=exp2.dmp direct=y
ºÄʱΪ£º£¨23:34:12.12-23:12:12.23£©=Ô¼22minute
µçÄÔÅäÖãºCUP P7350 Ë«ºË2.0GHZ£»
ÄÚ´æ 2G
OS Windows XP SP3
Êý¾ÝÎļþ´óС£ºexp1.dmp:8725M
exp2.dmp 8775M
ÓÉ´Ë¿ÉÒԵóö½áÂÛ£¬ÔÚʹÓÃexpÃüÁîµÄʱºò£¬¼ÓÉÏdirect=y£¬¿ÉÒÔ´ó´óÌá¸ßµ¼³öËٶȡ£
Ïà¹ØÎĵµ£º
ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name Type Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y &nb ......
ÔÚoracleÖд洢¹ý³Ì»òÕßÊÓͼµÈ¶ÔÏó´´½¨Ê±£¬Èç¹ûÉæ¼°µ½ÁíÍâÒ»¸öÓû§µÄ±í£¬¼´Ê¹ÄãÒѾgrant dbaÁË£¬Ò²²»ÐУ¬±ØÐëÏÔʽµØ¸³Óè²éѯȨÏÞ¡£·ñÔò£¬Äã»á·¢ÏÖÔÚpl/sqlÖпÉÒÔÖ´ÐÐÓï¾ä£¬µ«ÊÇÒ»µ©·Åµ½create Öо͸æËßÄãȨÏÞ²»×ã¡£
grant select any table to user ......
1). ÉèÖõ±Ç°sessionÊÇ·ñ¶ÔÐ޸ĵÄÊý¾Ý½øÐÐ×Ô¶¯Ìá½» :SET AUTO[COMMIT] {ON|OFF|IMM[EDIATE]| n}
SQL> set autocommit off
2)£®ÔÚÓÃstartÃüÁîÖ´ÐÐÒ»¸ösql½Å±¾Ê±£¬ÊÇ·ñÏÔʾ½Å±¾ÖÐÕýÔÚÖ´ÐеÄSQLÓï¾ä :SET ECHO {ON|OFF}
SQL> set echo on
3).ÊÇ·ñÏÔʾµ±Ç°sqlÓï¾ä²éѯ»òÐ޸ĵÄÐÐÊý
SQL> SET FEED[BACK] {6|n|O ......
INSERT INTO hydlsrs@remote_£ú£úh
SELECT * from hydlsrs where zzh='2'
hydlsrsΪ±íÃû¡¡£Àremote_zzhΪ¿âÃû
select * from hydlsrsΪÁí1¿âÖбíÃû£¬
²»Í¬¿âÖÐÏàͬ±í½á¹¹£¬¿ÉÒÔ¿ç¿â²åÈë¡£ÓÃÓÚ
2µØµ¹Èë±íÄÚÈÝ¡£ ......
£¨1£©[Q]ÈçºÎ²åÈëµ¥ÒýºÅµ½Êý¾Ý¿â±íÖÐ
[A]¿ÉÒÔÓÃASCIIÂë´¦Àí£¬ÆäËüÌØÊâ×Ö·ûÈç&Ò²Ò»Ñù£¬Èç
insert into t values('i'||chr(39)||'m'); -- chr(39)´ú±í×Ö·û'
»òÕßÓÃÁ½¸öµ¥ÒýºÅ±íʾһ¸ö
or insert into t values('I''m'); -- Á½¸ö''¿ÉÒÔ±íʾһ¸ö'
£¨2£©[Q]Ëæ»ú³éÈ¡Ç°NÌõ¼Ç¼µÄÎÊÌâ
[A]8iÒÔÉÏ°æ± ......