Oracle ³£ÓÃÃæÊÔÌâ
1. ½âÊÍÀ䱸·ÝºÍÈȱ¸·ÝµÄ²»Í¬µãÒÔ¼°¸÷×ÔµÄÓŵã
½â´ð£ºÈȱ¸·ÝÕë¶Ô¹éµµÄ£Ê½µÄÊý¾Ý¿â£¬ÔÚÊý¾Ý¿âÈԾɴ¦ÓÚ¹¤×÷״̬ʱ½øÐб¸·Ý¡£¶øÀ䱸·ÝÖ¸ÔÚÊý¾Ý¿â¹Ø±Õºó£¬½øÐб¸·Ý£¬ÊÊÓÃÓÚËùÓÐģʽµÄ
Êý¾Ý¿â¡£Èȱ¸·ÝµÄÓŵãÔÚÓÚµ±±¸·Ýʱ£¬Êý¾Ý¿âÈԾɿÉÒÔ±»Ê¹Óò¢ÇÒ¿ÉÒÔ½«Êý¾Ý¿â»Ö¸´µ½ÈÎÒâÒ»¸öʱ¼äµã¡£À䱸·ÝµÄÓŵãÔÚÓÚËüµÄ±¸·ÝºÍ»Ö¸´
²Ù×÷Ï൱¼òµ¥£¬²¢ÇÒÓÉÓÚÀ䱸·ÝµÄÊý¾Ý¿â¿ÉÒÔ¹¤×÷Ôڷǹ鵵ģʽÏÂ,Êý¾Ý¿âÐÔÄÜ»á±È¹éµµÄ£Ê½ÉԺᣣ¨ÒòΪ²»±Ø½«archive logдÈëÓ²ÅÌ£©
2. Äã±ØÐëÀûÓñ¸·Ý»Ö¸´Êý¾Ý¿â£¬µ«ÊÇÄãûÓпØÖÆÎļþ£¬¸ÃÈçºÎ½â¾öÎÊÌâÄØ£¿
½â´ð£ºÖؽ¨¿ØÖÆÎļþ£¬Óôøbackup control file ×Ó¾äµÄrecover ÃüÁî»Ö¸´Êý¾Ý¿â¡£
3. ÈçºÎת»»init.oraµ½spfile?
½â´ð£ºÊ¹ÓÃcreate spfile from pfile ÃüÁî
.
4. ½âÊÍdata block , extent ºÍ segmentµÄÇø±ð£¨ÕâÀィÒéÓÃÓ¢ÎÄÊõÓ
½â´ð£ºdata blockÊÇÊý¾Ý¿âÖÐ×îСµÄÂß¼´æ´¢µ¥Ôª¡£µ±Êý¾Ý¿âµÄ¶ÔÏóÐèÒª¸ü¶àµÄÎïÀí´æ´¢¿Õ¼äʱ£¬Á¬ÐøµÄdata block¾Í×é³ÉÁËextent . Ò»
¸öÊý¾Ý¿â¶ÔÏóÓµÓеÄËùÓÐextents±»³ÆΪ¸Ã¶ÔÏóµÄsegment.
5. ¸ø³öÁ½¸ö¼ì²é±í½á¹¹µÄ·½·¨
½â´ð£º1¡¢DESCRIBEÃüÁî
2¡¢ DBMS_METADATA.GET_DDL °ü
6. ÔõÑù²é¿´Êý¾Ý¿âÒýÇæµÄ±¨´í
½â´ð£ºalert log.
7. ±È½ÏtruncateºÍdelete ÃüÁî
½â´ð£ºÁ½Õ߶¼¿ÉÒÔÓÃÀ´É¾³ý±íÖÐËùÓеļǼ¡£Çø±ðÔÚÓÚ£ºtruncateÊÇDDL²Ù×÷£¬ËüÒƶ¯HWK£¬²»ÐèÒª rollback segment .¶øDeleteÊÇDML²Ù×÷
, ÐèÒªrollback segment ÇÒ»¨·Ñ½Ï³¤Ê±¼ä.
8. ʹÓÃË÷ÒýµÄÀíÓÉ
½â´ð£º¿ìËÙ·ÃÎʱíÖеÄdata block
9. ¸ø³öÔÚSTAR SCHEMAÖеÄÁ½ÖÖ±í¼°ËüÃÇ·Ö±ðº¬ÓеÄÊý¾Ý
½â´ð£ºFact tables ºÍdimension tables. fact table °üº¬´óÁ¿µÄÖ÷ÒªµÄÐÅÏ¢¶ø dimension tables ´æ·Å¶Ôfact table ijЩÊôÐÔÃèÊöµÄ
ÐÅÏ¢
10. FACT TableÉÏÐèÒª½¨Á¢ºÎÖÖË÷Òý£¿
½â´ð£ºÎ»Í¼Ë÷Òý£¨bitmap index£©
11. ¸ø³öÁ½ÖÖÏà¹ØÔ¼Êø?
½â´ð£ºÖ÷¼üºÍÍâ¼ü
12. ÈçºÎÔÚ²»Ó°Ïì×Ó±íµÄÇ°ÌáÏ£¬Öؽ¨Ò»¸öĸ±í
½â´ð£º×Ó±íµÄÍâ¼üÇ¿ÖÆʵЧ£¬Öؽ¨Ä¸±í£¬¼¤»îÍâ¼ü
13. ½âÊ͹鵵ºÍ·Ç¹éµµÄ£Ê½Ö®¼äµÄ²»Í¬ºÍËüÃǸ÷×ÔµÄÓÅȱµã
½â´ð£º¹éµµÄ£Ê½ÊÇÖ¸Äã¿ÉÒÔ±¸·ÝËùÓеÄÊý¾Ý¿â transactions²¢»Ö¸´µ½ÈÎÒâÒ»¸öʱ¼äµã¡£·Ç¹éµµÄ£Ê½ÔòÏà·´£¬²»Äָܻ´µ½ÈÎÒâÒ»¸öʱ¼äµ
Ïà¹ØÎĵµ£º
£¨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³£ÓÃÃüÁî
Ò»¡¢ORACLEµÄÆô¶¯ºÍ¹Ø±Õ
1¡¢ÔÚµ¥»ú»·¾³ÏÂ
ÒªÏëÆô¶¯»ò¹Ø±ÕORACLEϵͳ±ØÐëÊ×ÏÈÇл»µ½ORACLEÓû§£¬ÈçÏÂ
su - oracle
a¡¢Æô¶¯ORACLEϵͳ
oracle>svrmgrl
SVRMGR>connect internal
SVRMGR>startup
SVRMGR>quit
b¡¢¹Ø±ÕORACLEϵͳ
oracle>svrmgrl
SVRMGR>connect internal
SVRMGR& ......
ÊÓͼ
´´½¨ÐÂ±í£ºcreate table emp2 as select * from emp;
create view empv20 as select empno,ename,job,hiredate,deptno from emp where deptno=20 with check option;
Óï·¨£ºcreate or replace view ÊÓͼÃû³Æ as ×Ó²éѯ£¨ÐÞ¸ÄÖ®ºóµÄ×Ó²éѯ£©
Ìæ»»ÊÓͼ(ÐÞ¸Ä)
create or replace view empv20 as select empno,ename, ......
µÚÒ»´ÎÔÚLinuxÉÏ°²×°OracleµÄʱºòÅöµ½Õâ¸öÎÊÌ⣬ºÇºÇ¡£Ö®Ç°ÔÚLinuxÉÏ°²×°Oracleʱ£¬Ò»°ã¶¼Ê¹ÓÃRedHatϵÁеÄLinux£¬ÔÚ°²×°¹ý³ÌÖУ¬ÐèÒª×ö´óÁ¿µÄ°²×°Ç°Öù¤×÷£¬Èç°²×°RPM°ü£¬´´½¨×éºÍÓû§£¬ÐÞ¸ÄÄں˲ÎÊý£¬Ð޸Ļ·¾³±äÁ¿µÈ¡£Õâ´ÎʹÓõÄÊÇRedFlagµÄAsianux 3£¬¶øÇÒ×Ô´øOracleµÄ°²×°¸¨Öú¹¤¾ßOrana ......
linuxÏÂoracleµÄ×Ô¶¯±¸·Ý
http://hohai2002.blog.163.com/blog/static/1628166912010323103227543/
±¸·Ý
ÉÏ´«root_cronµ½rootĿ¼
ʹÓÃcrontab ÅäÖÃÎļþ
crontab -u root /root/root_cron
ʹÓÃcrontab -l ¼ì²é
#Îļþ root_cron
01 00 * * * /etc/root_exp.sh
#Îļþroot_exp.sh
su - oracle -c /oracle/db ......