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

¹ØÓÚoracleµÄ±í¿Õ¼ä£¬·ÖÇø±í£¬ÒÔ¼°Ë÷ÒýµÄ×ܽá


±í¿Õ¼ä£º
OracleµÄUNDOTBS01.DBFÎļþÌ«´óµÄ½â¾ö°ì·¨
1¡¢.½ûÖ¹undo tablespace×Ô¶¯Ôö³¤
alter   database   datafile   'full_path\undotbs01.dbf'   autoextend   off;
2.-- ´´½¨Ò»¸öеÄС¿Õ¼äµÄundo tablespace
create undo tablespace undotBS2 datafile 'full_path\UNDOTBS02.DBF'  size 100m;
                                                                
-- ÉèÖÃеıí¿Õ¼äΪϵͳundo_tablespace
alter system set undo_tablespace=undotBS2;
-- Drop ¾ÉµÄ±í¿Õ¼ä
drop tablespace undotbs1 including contents;
--²é¿´ËùÓбí¿Õ¼äµÄÇé¿ö
select * from dba_tablespaces
--´´½¨±í¿Õ¼ä
create tablespace  HRPM0
    datafile '/oradata/misdb/HRPM0.DBF' size 5m  autoextend   on next  10m maxsize unlimited
--ɾ³ý±í¿Õ¼ä
DROP TABLESPACE data01 INCLUDING CONTENTS AND DATAFILES;
--Ð޸ıí¿Õ¼ä´óС
     alter database datafile '/path/NADDate05.dbf' resize 100M   
·ÖÇø±í£º
µ±±íÖеÄÊý¾ÝÁ¿²»¶ÏÔö´ó£¬²éѯÊý¾ÝµÄËٶȾͻá±äÂý£¬Ó¦ÓóÌÐòµÄÐÔÄܾͻáϽµ£¬Õâʱ¾ÍÓ¦¸Ã¿¼ÂÇ¶Ô±í½øÐзÖÇø¡£±í½øÐзÖÇøºó£¬Âß¼­ÉϱíÈÔÈ»ÊÇÒ»ÕÅÍêÕûµÄ±í£¬Ö»Êǽ«±íÖеÄÊý¾ÝÔÚÎïÀíÉÏ´æ·Åµ½¶à¸ö±í¿Õ¼ä(ÎïÀíÎļþÉÏ)£¬ÕâÑù²éѯÊý¾Ýʱ£¬²»ÖÁÓÚÿ´Î¶¼É¨ÃèÕûÕÅ±í¡£
    OracleÖÐÌṩÁËÒÔϼ¸ÖÖ±í·ÖÇø£º
Ò»¡¢·¶Î§·ÖÇø£ºÕâÖÖÀàÐ͵ķÖÇøÊÇʹÓÃÁеÄÒ»×éÖµ£¬Í¨³£½«¸ÃÁгÉΪ·ÖÇø¼ü¡£
ʾÀý1£º¼ÙÉèÓÐÒ»¸öCUSTOMER±í£¬±íÖÐÓÐÊý¾Ý200000ÐУ¬ÎÒÃǽ«´Ë±íͨ¹ýCUSTOMER_ID½øÐзÖÇø£¬Ã¿¸ö·ÖÇø´æ´¢100000ÐУ¬ÎÒÃǽ«Ã¿¸ö·ÖÇø±£´æµ½µ¥¶ÀµÄ±í¿Õ¼äÖУ¬ÕâÑùÊý¾ÝÎļþ¾Í¿ÉÒÔ¿çÔ½¶à¸öÎïÀí´ÅÅÌ¡£ÏÂÃæÊÇ´´½¨±íºÍ·ÖÇøµÄ´úÂ룬ÈçÏ£º
CREATE TABLE CUSTOMER
(
  CUSTOMER_ID NUMBER NOT NULL PRIMARY KEY,
  FIRST_NAME V


Ïà¹ØÎĵµ£º

Oracle ASM Ïê½â


 
ASM:Automatic Storage Management, ÊÇOracle Ö÷ÍÆµÄÒ»ÖÖÃæÏòOracleµÄ´æ´¢½â¾ö·½°¸£¬ ASM ºÍ RDBMS ·Ç³£ÏàËÆ£¬ASM Ò²ÊÇÓÉʵÀýºÍÎļþ×é³É£¬ Ò²¿ÉÒÔͨ¹ýsqlplus ¹¤¾ßÀ´Î¬»¤¡£ 
1. ASM ÊµÀýÓÉSGA ºÍºǫ́½ø³Ì×é³É¡£
1.1 SGA  ......

Oracle³õѧÕß±ØÖªµÄ100¸öÒÉÎÊ

1. Oracle°²×°Íê³ÉºóµÄԭʼ¿ÚÁ
¡¡internal/oracle
¡¡¡¡sys/change_on_install
¡¡¡¡system/manager
¡¡¡¡scott/tiger
¡¡¡¡sysman/oem_temp
2. ORACLE9IAS WEB CACHEµÄԭʼĬÈÏÓû§ºÍÃÜÂ룿
administrator/administrator
3. oracle 8.0.5ÈçºÎ½¨Á¢Êý¾Ý¿â£¿
ÓÃorainst¡£¼ÙÈçÓÐmotif½çÃæ£¬Äܹ»ÓÃorainst /m¡ ......

ORACLE ÖÐROWNUMÓ÷¨×ܽá!


¶ÔÓÚ Oracle µÄ rownum ÎÊÌ⣬ºÜ¶à×ÊÁ϶¼Ëµ²»Ö§³Ö>,>=,=,between...and£¬Ö»ÄÜÓÃÒÔÉÏ·ûºÅ(<¡¢<=¡¢!=)£¬²¢·Ç˵ÓÃ>,>=,=,between..and ʱ»áÌáʾSQLÓï·¨´íÎ󣬶øÊǾ­³£ÊDz鲻³öÒ»Ìõ¼Ç¼À´£¬»¹»á³öÏÖËÆºõÊÇĪÃûÆäÃîµÄ½á¹ûÀ´£¬ÆäʵÄúÖ»ÒªÀí½âºÃÁËÕâ¸ö rownum αÁеÄÒâÒå¾Í²»Ó¦¸Ã¸Ðµ½¾ªÆæ£¬Í¬ÑùÊÇαÁУ¬rownum ......

Oracleѧϰ±Ê¼Ç

ȨÏÞ¹ÜÀí
Oracle 9i
3¸öĬÈÏÓû§
sys(³¬¼¶¹ÜÀíÔ±)       ĬÈÏÃÜÂ룺change_on_install
system£¨ÆÕͨ¹ÜÀíÔ±£©
ĬÈÏÃÜÂ룺manager
scott£¨ÆÕͨÓû§£©       ĬÈÏÃÜÂ룺tiger
Oracle 10g
sys£¨ÃÜÂëÔÚ°²×°Ê±ÉèÖã©
system£¨ÃÜÂëÔÚ°²×°Ê±ÉèÖã©
scott(ĬÈÏËø¶¨£¬ÏëÓõýâËø)
Æô¶¯Windo ......

Oracle RAC °²×°Îĵµ


Ò». ÓйØRACµÄÏà¹Ø¸ÅÄî
RAC:È«³ÆÊÇReal Application Cluster¡£RAC²¢·ÇÊǸöм¼Êõ£¬ÆäǰÉí½ÐOPS(Oracle Parallel Server)£¬´Ó9i¿ªÊ¼²Å¸ÄÃû½ÐRAC,oracle Data GuardÔÚ9i֮ǰ½Ð×öStandby
¸ÃÌåϵʵÏÖÁ˶à¸öʵÀýͬʱ·ÃÎʺ͹ÜÀíͬһÊý¾Ý¿â£¬¶à¸öʵÀý¿ÉÒÔ´æÔÚÓÚ²»Í¬½Úµã£¬Ò²¿ÉÒÔÔÚÏàͬµÄ½Ú ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ