Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ORACLE´Ó9201Éý¼¶µ½9208ÎÊÌâ

ORACLE´Ó9201Éý¼¶µ½9208Ö®ºó
»·¾³±äÁ¿ÖÐORACLE_HOMEûÓÐÉèÖà ÊÖ¹¤Ìí¼Óºó
ϵͳ·þÎñÀïËùÓÐORACLE·þÎñ¶¼Æð²»À´
ÃüÁîÐÐÀïÊäÈë EXP»òÕßLSNRCTL±¨ÌáʾÎÞ·¨¶¨Î»³ÌÐòÊäÈëµã lxhlcmod ÓÚ¶¯Ì¬Á´½Ó¿â oranls9.dllÉÏ
ÇëÎÊÊÇʲôÎÊÌâ°¡  ¼±  лл´ó¼ÒÁË

ÒýÓÃ
ÄãµÄÉý¼¶Êdzɹ¦Íê³ÉÁËÂð£¿
²¹¶¡ÊÇÌáʾÉý¼¶³É¹¦


SQL code:
--¹ØÕìÌý
connect /as sysdba;
lsnrctl stop;
--¹Ø±ÕÊý¾Ý¿â
sqlplus /nolog;
sql> connect /as sysdba;
sql> shutdown immediate;
--Æô¶¯Êý¾Ý¿â
sql> startup;
--Æô¶¯ÕìÌý
lsnrctl start;


ÒýÓÃ
SQL code--¹ØÕìÌýconnect/as sysdba;
lsnrctl stop;--¹Ø±ÕÊý¾Ý¿âsqlplus/nolog;
sql> connect/as sysdba;
sql>shutdown immediate;--Æô¶¯Êý¾Ý¿âsql> startup;--Æô¶¯ÕìÌýlsnrctl start;
ÊÇÔÚWINDOWSÏ嵀 £¬ÏÖÔÚÊÇËùÓÐORACLEµÄ·þÎñ¶¼´ò²»¿ª£¬¶øÇÒconn /as sysdba±¨CONN²»ÊÇÄÚ²¿»òÕßÍⲿÃüÁҲ²»ÊÇ¿ÉÔËÐеijÌÐò£¬LSNRCTL,SQLPLUS /NOLOG¶¼±¨ÎÞ·¨¶¨Î»³ÌÐòÊäÈëµã lxhlcmod ÓÚ¶¯Ì¬Á´½Ó¿â oranls9.dllÉÏ

ÇóÖú°¡  ÇóÖú

Ê×ÏÈÒªÔÚ$ORACLE_HOMEĿ¼Ï£¬²ÅÄÜÖ´ÐдËһϵÁÐÃüÁî¡£

È磺D:\oracle\ora92\bin

ÒýÓÃ
Ê×ÏÈÒªÔÚ$ORACLE_HOMEĿ¼Ï£¬²ÅÄÜÖ´ÐдËһϵÁÐÃüÁî¡£

È磺D:\oracle\ora92\bin
ÔÚBINĿ¼ÏÂÃæ CONN /AS SYSDBA Ò²Ê


Ïà¹ØÎÊ´ð£º

VBÁ¬½ÓORACLEµÄÎÊÌâ

VBÓÐûÓÐÀàËÆÏñJDBCµÄ·½·¨»òÕßÊÇÖмä¼þÁ¬½ÓORACLEÊý¾Ý¿â£¬ÍøÉϵĸ÷ÖÖÀý×Ó¶¼ÐèÒª°²×°¿Í»§¶Ë£¬»òÕßÊÇÅäÊý¾ÝÔ´¡£
ûÓÐÆäËû·½·¨£¬Äã±ØÐëÒª°²×°Çý¶¯µÄ

ORACLEÊý¾Ý¿âÊÇ»ùÓÚ°²È«ÐԵĿ¼ÂÇ,¿Í»§¶Ë¶¼ÐèÒª°²×°,ºÃÏóûÓбðµÄ ......

--oracle ´¥·¢Æ÷£¬×ª sqlserver ÎÊÌâ

--oracle ´¥·¢Æ÷£¬×ª sqlserver ÎÊÌâ
CREATE OR REPLACE TRIGGER TG_BU_TSTK_IMPORTITEM
BEFORE UPDATE ON TSTK_IMPORTITEM
FOR EACH ROW
DECLARE
VAR_LIBGOODCOUNT NUMERIC(12,2);
BEGIN ......

oracleÓÐʲôÈí¼þ¿ÉÒÔ¼à¿ØoracleÊý¾Ý¿âÖ´ÐÐ

oracleÓÐʲôÈí¼þ¿ÉÒÔ¼à¿ØoracleÊý¾Ý¿âÖ´ÐУ¬¿ÉÒԲ鿴˭ÔÚÔËÐнű¾£¬²é¿´ÐÔÄÜÖ®ÀàµÄÈí¼þ£¬ÇëÓÐÓùýµÄ´ó¼Ò½éÉÜÏ£¬Ð»Ð»£¬³õѧÕߺܶ಻¶®Çë¶àÖ¸½Ì£¬Ð»Ð»£¡

²é¿´ÐÔÄÜÖ®ÀàµÄÈí¼þ

Spotlight:ʵʱµÄÒÔͼÐεÄÐÎ ......

Á¬½ÓOracleÊý¾Ý¿â,À§ÈÅ

ÔÚEclipseÀï±àдµÄÒ»¸öJAVA³ÌÐò,Á¬½ÓÊý¾Ý¿â,È´×ÜÁ¬²»ÉÏ,³ÌÐòΪ:
import java.sql.*;
public class as {
public static void main(String args[])throws Exception
{
Class.forName("oracle. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ