oracle ³õʼ»¯²ÎÊýÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
os windows 2003
dbms oracle 10g
ʹÓà host copy g:\oracle\product\10.2.0\db_1\srvm\admin\init.ora g:\oracle\product\10.2.0\db_1\database\initsky.ora
´´½¨ÁËÒ»¸öĬÈϵÄpfile Îļþ
È»ºó ʹÓÃsysµÇ½Êý¾Ý¿â
create spfile='spfilesky.ora' from pfile='g:\oracle\product\10.2.0\db_1\database\initsky.ora';
´´½¨¶¯Ì¬²ÎÊýÎļþʱ±¨´í
µÚÒ»ÐгöÏÖ´íÎó
ora-01078:´¦Àíϵͳ²ÎÊýʧ°Ü
ora-32003:´¦Àí²ÎÊý'distributed_transactions'ʱ³ö´í
lrm-00101:umknown parameter name 'distributed_transactions'
¸ÃÔõô°ì
лл ½â¾öÁË£¡£¡
Ïà¹ØÎÊ´ð£º
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test
as
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......