¹ØÓÚoracleµÄ±í¿Õ¼ä£¬·ÖÇø±í£¬ÒÔ¼°Ë÷ÒýµÄ×ܽá
http://episode.javaeye.com/blog/183016
±í¿Õ¼ä£º
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ÐУ¬ÎÒÃǽ«Ã¿¸ö·ÖÇø±£´æµ½µ¥¶ÀµÄ±í¿Õ¼äÖУ
Ïà¹ØÎĵµ£º
£¨1£©ÒÔSYSÉí·ÝµÇ½
conn sys/sysem_pwd as sysdba;
£¨2£©´´½¨amlyÓû§
create user amly identified by 9imly;
£¨3£©´´½¨±í¿Õ¼ä
create tablespace ts_amly datafile 'd:\amlyfile\test.dbf' size 100M;
£¨4£©½«±í¿Õ¼ä·ÖÅ䏸Óû§
alter user amly default tablespace ts_amly;
£¨5£©¸øÓû§ÊÚȨ
grant create sess ......
Oracle ÏòÒ»¸ö±íÖвåÈëÊý¾ÝµÄÁ½ÖÖ·½Ê½£º
Conventional Insert Operations£º´«Í³²åÈë»áÓÅÏÈʹÓøßˮλ֮Ï£¬»á±£Ö¤Êý¾ÝÓ¦ÓÃÍêÕûÐÔ£º¸ßˮλ֮ÏÂÊÇÖ¸£ºÉ¾³ýÖ®ºóµÄÊ£Óà¿Õ¼ä£¬¸ßˮλ֮ÉÏÊÇÖ¸£º´ÓÀ´Ã»ÓÐÓùýµÄ´¦Å®¿é¡£
Direct-path Insert Operatio ......
left join ºÍ left outer join µÄÇø±ð
ͨË׵Ľ²£º
A left join B µÄÁ¬½ÓµÄ¼Ç¼ÊýÓëA±íµÄ¼Ç¼Êýͬ
A right join B µÄÁ¬½Ó ......
ÏÞÖÆ¿ØÖÆÎļþµÄ´óС
a.)²éѯ¿É¸´Óò¿·ÖµÄ±£´æÌìÊý(²»ÄÜÖ±½Ó¿ØÖÆ´óС,±£´æÌìÊýÔ½´óÊý¾ÝÔ½¶à)
SELECT name,value from v$parameter WHERE name = 'control_file_record_keep_time';
b.)ÉèÖÿɸ´Óò¿·Ö±£´æÊ±¼ä
ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME = 14;
......