ORACLEÊý¾Ý¿â×Ô¶¯±¸·ÝÈÎÎñ
For win:
1¡¢Ð½¨Ò»¸öÅú´¦ÀíÎļþb.bat£¬¸ÃÎļþĿ¼ÏÂÒªÓÐexp.exeÎļþ
Åú´¦ÀíÎļþÄÚÈÝ£º
exp userid=user/passfile=i:\db%date:~0,10%.dmp log=i:\db%date:~0,10%.log
2¡¢Ð½¨ÈÎÎñ¹ØÁªb.batÎļþ¼´¿É¡£
For linux:
1¡¢Çе½oracleÓû§ÏÂн¨Ò»¸öÎļþ£¬Èçb.sh £¬²¢¸³ÓÚ¿ÉÖ´ÐÐȨÏÞ chmod +x b.sh
tim=`date +%Y%m%d`
mday10=`date -d "10 days ago" +%Y%m%d`
unset USERNAME
/prod/proddb/9.2.0/bin/exp userid=wlpos/wlpos file=/prod/dmbackup/dmp/dat$tim.dmp buffer=2048000 >>/prod/dmbackup/log/log$tim.log 2>&1
/usr/bin/gzip /prod/dmbackup/dmp/dat$tim.dmp
/usr/bin/rcp /prod/dmbackup/dmp/dat$tim.dmp.gz backup51:/backup/rman/dmbackup/
/bin/rm -f /prod/dmbackup/dmp/dat$mday10*.dmp.gz
2¡¢Çе½rootÓû§ÏÂн¨Ò»¸öÎļþ£¬Èçback.sh £¬²¢¸³ÓÚ¿ÉÖ´ÐÐȨÏÞ chmod +x back.sh
su - oracle -c "/prod/b.sh"
3¡¢¶¨ÒåÈÎÎñ¶¨Ê±Ö´Ðб¸·Ý£ºcrontab -e
1 30 * * * /prod/back.sh
Ïà¹ØÎĵµ£º
ת×Ô£ºhttp://download.oracle.com/docs/cd/B13789_01/server.101/b10759/statements_6004.htm
Creating User-Defined Operators: Example
This example creates a very simple functional implementation of equality and then creates an operator that uses the function:
CREATE FUNCTION eq_f(a VARCHAR2, b VARCHA ......
¡¡Ò»¡¢OracleÊý¾Ý¿âÖ§³ÖµÄ´ó¶ÔÏóÊý¾ÝÀàÐÍ¡£
¡¡¡¡ÔÚOracleÊý¾Ý¿âÖÐΪÁ˸üºÃµÄ¹ÜÀí´óÈÝÁ¿µÄÊý¾Ý£¬×¨ÃÅ¿ª·¢ÁËһЩ¶ÔÓ¦µÄ´ó¶ÔÏóÊý¾ÝÀàÐÍ¡£¾ßÌåµÄÀ´Ëµ£¬ÓÐÈçϼ¸ÖÖ£º
¡¡¡¡Ò»ÊÇBLOBÊý¾ÝÀàÐÍ¡£ËüÊÇÓÃÀ´´æ´¢¿É±ä³¤¶ÈµÄ¶þ½øÖÆÊý¾Ý¡£ÓÉÓÚÆä´æ´¢µÄÊÇͨÓõĶþ½øÖÆÊý¾Ý£¬Îª´ËÔÚÊý¾Ý¿âÖ®¼ä»òÕßÔÚ¿Í»§¶ËÓë·þÎñÆ÷Ö®¼ä½øÐд«ÊäµÄʱºò£¬ ......
ʾÀýÒ»£ºdelete from emp;
ʵÀý¶þ£ºtruncate table emp;
µ±Ê¹ÓÃdeleteɾ³ýʱ£¬ËäȻɾ³ýÁ˱íÖеÄËùÓÐÊý¾Ý£¬µ«ÊÇûÓÐÊͷűíËùÕ¼µÄ¿Õ¼ä£¬Èç¹ûÓû§È·¶¨ÒªÉ¾³ý±íÖÐËùÓÐÊý¾Ý£¬Ê¹ÓÃʵÀý¶þÓï¾äËٶȸü¿ì¡£deleteÓï¾ä¿ÉÒÔ»ØÍË£¬µ«truncateÓï¾ä²Ù×÷²»ÄÜ»ØÍË£¬Ö´ÐеÄʱºòÒª¶à¼Ó×¢ÒâÕâÒ»µã¡£ ......
Ë÷Òý¾Û´Ø±í
create cluster emp_dept_cluster
(deptno number(2)) size 1024;
size 1024 ±íʾÿ¸ö¾Û´Ø¼üÖµ¹ØÁª´óÔ¼1024×Ö½ÚµÄÊý¾Ý,
oracle»áÔÚÓÃÕâ¸öÊý¾Ý¿â¿éÉÏͨ¹ýsize¼ÆËã×î¶à¿ÉÒԷŶàÉÙ¸ö´Ø
Èç¹û¿éÊÇ8KB,ÄÇôÕâ¸ö¿éÉÏ×î¶à·Å7¸ö¾Û´Ø¼ü
Ïò¾Û´ØÖзÅÊý¾Ý֮ǰ,ÐèÒªÏȶԾ۴ؽ¨Á¢Ë÷Òý.
create index emp_dept_cluster_id ......
Ò»¸öÏîÄ¿ÐèÒªDB2£¬ÒÔǰûÓùý£¬ÓÃÁËWINDOWS 2008ϵÄDB29.7 ºÃ¼¸ÖÜ£¬ËãÈëÃÅÁ˰ɣ¬ÏÂÃæÕâÎÄÕ¾͵±Ò»¸öORACLEʹÓÃÕßÑÛÀïµÄDB2µÄÓ¡Ïó°É£¬Ò²ÐíÓÐЩ¶«Î÷¿ÉÄÜÓÐÆ«²î£¬µ«ÊǾÍÊÇÎÒ×Ô¼ºµÄÓ¡Ïó£º
1¡¢Ìåϵ½á¹¹£¬DB2µÄʵÀýºÍÊý¾Ý¿â·Ö¿ªµÄ×ö·¨£¬ÎÒ¸öÈË»¹ÊDZȽÏϲ»¶µÄ£¬ÒòΪʵÀý¿ÉÒÔ´´½¨¶à¸ö£¬Êý¾Ý¿âµÄ»Ö¸´Ö±½Ó»Ö¸´µ½ÊµÀýϾͿÉÒÔÁË£¬Ïà¶ ......