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

oracle jobºÅʹÓÃ

µ±ÓÃsubmit½¨JOBʱ£¬JOBIDÓÉϵͳ×Ô´øSEQUENCE£ºsys.JOBSEQÉú³É¡£
Èç¹ûÒ»¶Îʱ¼äºóJOBID¹ý´ó£¬¿ÉÒÔDROP SEQUENCE sys.JOBSEQ;ÔÙÖØ½¨
create sequence JOBSEQ
minvalue 1
maxvalue 999999999999
start with 1
increment by 1
cache 20;
À´ÖØÐ¿ªÊ¼JOBID¡£
¿ÉÒÔÓÃÏÂÃæÓï¾ä¸üÐÂÒѾ­½¨Á¢µÄJOBID£º
UPDATE sys.Job$
SET job=5 WHERE job=62;
COMMIT;
¿ÉÒÔÓÃisubmitÀ´Ö¸¶¨JOBID½¨JOB


Ïà¹ØÎĵµ£º

PostgreSQLºÍOracleÓ÷¨ÉϵÄÒ»Ð©Çø±ð

£¨1 £© ×¢ÒâÔö¼ÓÔ¼ÊøÊ±µÄд·¨£¬ºÍORACLE ÂÔÓв»Í¬
Oracle £º
ALTER TABLE SCHEMA.PREFIX_INFO ADD (
CONSTRAINT PK_PREFIX_INFO PRIMARY KEY (INFO_ID));
PostgresQL £º
alter table schema.prefix_info add constraint prefix_info_pkey primary key(info_id);
£¨2 £©ÏµÍ³Ä¬ÈϵÄ×î´óÖµÓëORACLE ²»Í¬
Oracle £ ......

OracleÄÚÖýÇÉ«connectÓëresourceµÄȨÏÞ

Ê×ÏÈÓÃÒ»¸öÃüÁÓèuserÓû§connect½ÇÉ«ºÍresource½ÇÉ«£º
grant connect,resource to user;
ÔËÐгɹ¦ºóÓû§°üÀ¨µÄȨÏÞ:
CONNECT½ÇÉ«£º --ÊÇÊÚÓè×îÖÕÓû§µÄµäÐÍȨÀû£¬×î»ù±¾µÄ
ALTER SESSION --Ð޸ĻỰ
CREATE CLUSTER --½¨Á¢¾Û´Ø
CREATE DATABASE LINK --½¨Á¢Êý¾Ý¿âÁ´½Ó
CREATE SEQUENCE --½¨Á¢ÐòÁÐ
CREAT ......

Oracle DBA Á½ÈÕËٳɿγÌ

http://www.oracle.com/technology/global/cn/obe/2day_dba/index.html
¿Î³ÌÁбí
1
¹ÜÀíÊý¾Ý¿âµÄÒªËØÊÇʲô£¨Ã»Óб¾Õ¶ÔÓ¦µÄ¸½¼Ó×ÊÁÏ£©
2
°²×° Oracle ºÍ¹¹½¨Êý¾Ý¿â
3
Oracle Enterprise Manager Êý¾Ý¿â¿ØÖÆÈëÃÅ
4
ÅäÖÃÍøÂç»·¾³
5
¹ÜÀí Oracle Àý³Ì
6
¹ÜÀíÊý¾Ý¿â´æ´¢½á¹¹
7
¹ÜÀíÓû§ºÍ°²È«ÐÔ
8
¹ÜÀíģʽ¶ ......

Oracle 11g 10g ÎÞ·¨Æô¶¯EmµÄ½â¾ö°ì·¨¡£

½â¾öOracle EMÎÞ·¨Æô¶¯
ORACLE 11g, EM ÎÞ·¨Æô¶¯µÄÎÊÌ⣬¿ÉÄÜÊÇIP¸ü¸ÄÁ˵ÄÔ­Òò£¬ËùÒÔÎÒʹÓÃÁËEMCAÃüÁîÖØÐÂÅäÖÃÁËÒ»ÏÂORACLE EM£¬¾ßÌå¹ý³ÌÈçÏ£º
I:\Documents and Settings\geshaoqing>emca -config dbcontrol db -repos recreate
EMCA ¿ªÊ¼ÓÚ 2007-10-12 11:16:40
EM Configuration Assistant 10.2.0.1.0 Õýʽ ......

LinuxÏÂOracle×Ô¶¯±¸·Ý½Å±¾

LinuxÏÂOracle×Ô¶¯±¸·Ý½Å±¾
http://freeglad.javaeye.com/blog/586444
½Å±¾Îļþ£º
backup.sh
rq=`date '+%Y%m%d%H%M'`
su - oracle -c "exp zjhk/zjhk_123 owner=zjhk file=/home/oracle/zjhk_$rq.dmp"
cronÊÇÒ»¸ölinuxÏµĶ¨Ê±Ö´Ðй¤¾ß£¬¿ÉÒÔÔÚÎÞÐèÈ˹¤¸ÉÔ¤µÄÇé¿öÏÂÔËÐÐ×÷Òµ¡£ÓÉÓÚCron ÊÇLinuxµÄÄÚÖ÷þÎñ£¬µ«Ëü²»×Ô¶ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ