ÎÒÏëÔÚwebÖÐ ÓÃspool ´ÓoracleÖе¼³ö exel±í¸ñ ´úÂëдºÃÁË ´æÔڽű¾ µ«²»»áµ÷Óýű¾
ÓÃÁ˸ö±¿·½·¨ oraclecommend a=£¨¡° set colsep' '¡±£¬conn£© Ò»ÌõÒ»ÌõÖ´ÐÐ
ÓÃsql/plusÔËÐнű¾Ã»ÎÊÌ⣬µ«ÊÇÔÚÍøÒ³Öв»Ê¶±ðÎÒдµÄÓï¾ä Ϊʲô Ôõô°ì £¿ ÊDz»ÊÇÎÒµÃÔÙÌî¼Óij¸öÍ·Îļþ £¿
......
linuxÏÂÔõô²é¿´Oracle¶Ë¿ÚºÅ£¿
лл
netstat | grep ÊÔÊÔ
û»·¾³£¬Äã¼ÓÉϲÎÊýºÍgrepÄÚÈÝ
²é¿´ÏÂÕâÁ½¸öÎļþÀïÃæµÄportÊǶàÉÙ°¡
tnsnames.ora
listener.ora
Â¥Ö÷Ö¸µÄÊÇÄǸö¶Ë¿Ú£¿
$ORACLE_HOME\INSTALL\PORTLIST.INI
iSQL*Plus HTTP ¶Ë¿ÚºÅ =5560
Enterprise Manager C ......
ÏÖÓÐÒ»ÀÏC/Sϵͳ£¬¿Í»§¶ËÓÃVB×÷µÄ£¬²ÉÓÃAccessµÄ±¾µØÊý¾Ý¿â£¬µ«Êý¾ÝÔÚ±¾µØAccessÖд¦ÀíÍê³Éºó£¬×îÖÕÐèÒª½«AccessÊý¾ÝдÈëµ½OracleÖУ¬ÆäVB´úÂë´óÖÂÈçÏ£º
//´ò¿ª±¾µØÊý¾Ý
....
Set resLocal = RunSQLGetRS(CnnProjectDb, strSql)
//´ò¿ª·þÎñÆ÷Êý¾Ý
.... &nb ......
Oracle ÅÅÐò
ÎÒÏÖÔÚÓÐÒ»¸öÕâÑùµÄÎÊÌâ:
±ÈÈçÎÒÓÐÊý¾ÝÈçÏÂ:
10
1001
1002
1003
1004
20
2001
2002
2003
.....
ÎÒÒªÅÅÐò³ÉÈçϸñʽ:
1001
1002
1003
1004
10
2001
2002
2003
20
...
ÇëºÃÐĵĸ÷λ´óÏÅ£¬°ï°ïÎÒ¡£¡£¡£
ÔÚÏߵȺòÔÚÏŵĻظ´¡£¡£
......
ÈçÌâÄ¿, ÎÒÓÐÒ»¸ö±ðÈ˵ÄoracleÊý¾Ý¿âEXP³öÀ´µÄ.DMPÎļþ£¬
ÎÒ×Ô¼ºµ¼Èë,ʧ°Ü£¿´íÎóÐÅÏ¢----->>>
¶ÁÈ¡µ¼ÈëÎļþ ORA-31619: ת´¢Îļþ "c:\ora\PTRC_oracle_database.dmp" ÎÞЧ ʱ³öÏÖÎÊÌâ¡£
ÎÒÅóÓѵ¼Èë,¾Ý˵Ëû´´½¨ÁËÒ»¸ö³¬¼¶Óû§,·¢ÏÖÓкܶàÓû§ºÍ±í¿Õ¼ä.
²»ÖªµÀÕâÀïµÄÅóÓÑÓаì ......
¸÷λ¸ßÊÖ¡£¡£±¾ÈËÓöµ½Ò»¸öÎÊÌ⣬·Ç³£µÄ¹ÖÒ죺
ÎÒ¿ª·¢ÁËÒ»¸ö¾ºÅĵÄÍøÕ¾¡£ÔÚvs2005 ÉϲâÊÔÍêȫûÓÐÎÊÌâ¡£µ«ÊÇ·¢²¼³öÀ´µÄ´úÂëÔÚiis Öеķ¢²¼Ëý±¨³öÁËÊý¾Ý¿âÁ¬½Óʧ°Ü£¿
µ«ÊÇÎÒÕâÌ×Êý¾Ý¿âÁ¬½Ó£¬ÎÒÒÔǰÓùýÍêȫûÓÐÎÊÌâ°¡£¿£¿
¸÷λ´ó¸çÖ¸µãÒ»ÏÂСµÜ£º
Ê ......