¹ØÓÚÔ¶³Ì°²×°oracleÓë´íÎóµÄ´¦Àí
Linuxϵͳɾ³ýoracle 10g£¨°üÀ¨Èí¼þºÍʵÀý£©
Èí¼þ»·¾³£ºLinuxϵͳ¡¡Oracle 10.0.1.0
Éæ¼°Óû§£ºroot oracle
ɾ³ýoracleÈí¼þºÍʵÀý²½Ö裺
1¡¢oracleÓû§µÇ½sqlplusÍ£Ö¹Êý¾Ý¿â£ºshutdown
2¡¢oracleÓû§Í£Ö¹¼àÌý·þÎñ£ºlsnrctl stop£¨Èç¹û¼àÌý·þÎñÆô¶¯µÄ»°£©
3¡¢rootÓû§
ɾ³ý/tmpÏÂora*Îļþ
ɾ³ý/optÏÂOR*Îļþ
ɾ³ý/etcÏÂoraInst.locºÍoratabÎļþ
£¨ÕâÁ½¸öÎļþÊÇ°²×°oracleʱִÐÐ$ORACLE_HOME/root.sh½Å±¾²úÉúµÄ£©
ɾ³ý/usr/local/binÏÂcoraenv¡¢dbhome¡¢oraenv
£¨ÕâÈý¸öÎļþÊÇ°²×°oracleʱִÐÐ$ORACLE_BASE/oraInventory/orainstRoot.sh½Å±¾²úÉúµÄ£©
ɾ³ý$ORACLE_BASEÏÂadmin¡¢flash_recovery_area¡¢oradata¡¢oraInventory
£¨¼ÇסÕâÀﲻҪɾ³ýoracleÓû§Ä¬ÈÏĿ¼£¬Ï´ÎÖØа²×°oracleÈí¼þʱ»¹ÒªÊ¹ÓÃoracleÓû§ÄØ£©
Ìرð×¢ÒâµÄÊDz»ÒªÉ¾³ý$ORACLE_BASEÏÂoracleÓû§Ä¬ÈÏĿ¼£¬Ï´ÎÖØа²×°oracleÈí¼þʱ»¹ÒªÊ¹ÓÃoracleÓû§¡£
ɾ³ýoracleʵÀý£¬²»É¾³ýoracleÈí¼þ
1¡¢oracleÓû§Ö´ÐÐ$ORACLE_HOME/bin/dbca£¬É¾³ýʵÀý
2¡¢²é¿´$ORACLE_BASEĿ¼ÏÂadmin¡¢oradataĿ¼ÊÇ·ñ»¹´æÔÚÎļþ£¬Èç¹û´æÔÚrmÒ»ÏÂɾ³ý¼´¿É¡£Èç¹ûÓöµ½“ÔÎÄÎļþÕýÔÚ±»Ê¹ÓõĻ°”£¬Í£Ö¹·þÎñÔÙɾ³ý¡£
&&&&&&&&&&&&&&&&&&&&&&
ÓÃXmanagerÁ¬½ÓÔ¶³Ì·þÎñÆ÷¶Ë×ÀÃæ°²×°oracle¿ÉÄܻᱨ´í.
Èç¹ûÐèҪͼÐΰ²×°,ÐèÒªµÄ½â¾ö·½·¨£º°²×°ÒÔÏÂÁ½¸ö°ü
[root@dbatest1 tmp]# rpm -ivh xorg-x11-deprecated-libs-6.9.0-1.112.16.14asp.i386.rpm
warning: xorg-x11-deprecated-libs-6.9.0-1.112.16.14asp.i386.rpm: Header V3 DSA signature: NOKEY, key ID 9b3c94f4
Preparing... ########################################### [100%]
1:xorg-x11-deprecated-lib########################################### [100%]
[root@dbatest1 tmp]# rpm -ivh libXp-1.0.0-8.1.el5.i386.rpm
warning: libXp-1.0.0-8.1.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186
Preparing... ###########################
Ïà¹ØÎĵµ£º
Oracle´æ´¢¹ý³Ì°üº¬Èý²¿·Ö£º¹ý³ÌÉùÃ÷£¬Ö´Ðйý³Ì²¿·Ö£¬´æ´¢¹ý³ÌÒì³£¡£
Oracle´æ´¢¹ý³Ì¿ÉÒÔÓÐÎÞ²ÎÊý´æ´¢¹ý³ÌºÍ´ø²ÎÊý´æ´¢¹ý³Ì¡£
Ò»¡¢Î޲γÌÐò¹ý³ÌÓï·¨
1 create or replace procedure NoParPro
2 as ;
3 begin
4 ;
5 exception &nb ......
author£ºskate
time£º2010-05-31
Ë÷ÒýÒ³¿éËéƬ£¨Index Leaf Block Fragmentation£©
ÕâƪÎÄÕ½«»á»Ø´ðÈçÏÂÎÊÌ⣺
ʲôÊÇË÷ÒýÒ³¿éËéƬ£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
ʲôÊÇ°ë¿ÕË÷ÒýËéƬ£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
oracleµÄ±ê×¼Ë÷Òý½á¹¹ÊÇB×tree½á¹¹£¬Ò»¸öB×tree½á¹¹ÓÉÈýÖÖblock×é³É
¸ù¿é(root block):ÔÚB×treeÀïÓÐÇÒÖ ......
oracle×Ö·û´®·Ö¸îºÍÌáÈ¡
·Ö¸î
create or replace function Get_StrArrayLength
(
av_str varchar2, --Òª·Ö¸îµÄ×Ö·û´®
av_split varchar2 --·Ö¸ô·ûºÅ
)
return number
is
lv_str varchar2(1000);
lv_length number;
begin
lv_str:=ltrim(rtrim(av_str));
&nb ......
ת:ORACLE
¶à±í¹ØÁª UPDATE Óï¾ä
ÔÌû£ºhttp://www.cnblogs.com/miley/archive/2010/04/15/1712617.html
ΪÁË
·½±ãÆð¼û
,½¨Á¢ÁËÒÔϼòµ¥Ä£ÐÍ
,ºÍ¹¹ÔìÁ˲¿·Ö²âÊÔÊý¾Ý
:
ÔÚij¸öÒµ
ÎñÊÜÀí×Óϵͳ
BSSÖУ¬
--¿Í»§×Ê
Áϱí
create table customers
(
& ......
select round(sum(case when o.close_date is null then 1 else 0 end)/count(*),3)*100||'%' SCALE from order o
˵Ã÷£ºÊ¹ÓÃsum¶ÔÒ»¶¨Ìõ¼þµÄÊý¾ÝÇóºÍºó£¬Óë×ÜÊý½øÐбȽϡ£
||'%' ΪÒԵİٷֺÅÐÎʽÊä³ö½á¹û(Àý£º2%) ......