oracle±í¿Õ¼ä²Ù×÷
-½¨Á¢±í¿Õ¼ä(oracleÖеÄtablespace(±í¿Õ¼ä)¾ÍÏ൱ÓÚsqlserverµÄdatabase)
CREATE TABLESPACE data01
DATAFILE 'D:\oracle\ora92\oradata\db\DATA01.dbf' SIZE 200M
UNIFORM SIZE 128k;
#Ö¸¶¨Çø³ß´çΪ128k,Èç²»Ö¸¶¨£¬Çø³ß´çĬÈÏΪ64k
--½¨Á¢ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE temp_data
TEMPFILE 'D:\TEMP_DATA.dbf' SIZE 100M
--½¨Á¢Óû§
CREATE USER peter IDENTIFIED BY peter
DEFAULT TABLESPACE data01
TEMPORARY TABLESPACE temp_data;
--¸øÓû§ÊÚȨ
grant connect,resource,dba to peter;
-- ´Ó '½¨Á¢±í¿Õ¼ä' µ½ '½¨Á¢ÁÙʱ±í¿Õ¼ä' µ½ ’½¨Á¢Óû§‘ µ½ ’¸øÓû§ÊÚȨ’ £¬
-- µ½´Ë¾Í¿ÉÒÔÓý¨Á¢µÄÓû§½øÐеǽ£¬È»ºó½¨Á¢tableÁË
-- ²¢ÇÒÒÔij¸öÓû§µÄÉí·Ý½øÐеǽ£¬½øÐб¸·ÝÓ뻹ÔÁË
Ò»¡¢½¨Á¢±í¿Õ¼ä
CREATE TABLESPACE data01
DATAFILE '/oracle/oradata/db/DATA01.dbf'
SIZE 500M
UNIFORM SIZE 128k; #Ö¸¶¨Çø³ß´çΪ128k,Èç²»Ö¸¶¨£¬Çø³ß´çĬÈÏΪ64k
(×¢Ò⣬±ØÐëÏÈдdatafile²ÅÄÜдsizeºÍuniform size£¬ÒòΪֻÓÐÏÈÖ¸¶¨ÁËÎļþ²ÅÄܹ»Ö¸¶¨ÎļþµÄ´óС£¬ÕâÊÇÒ»¸öÒò¹û¹Øϵ)
¶þ¡¢½¨Á¢UNDO±í¿Õ¼ä
CREATE UNDO TABLESPACE UNDOTBS02
DATAFILE '/oracle/oradata/db/UNDOTBS02.dbf' SIZE 50M
#×¢Ò⣺ÔÚOPEN״̬ÏÂijЩʱ¿ÌÖ»ÄÜÓÃÒ»¸öUNDO±í¿Õ¼ä£¬Èç¹ûÒªÓÃн¨µÄ±í¿Õ¼ä£¬±ØÐëÇл»µ½¸Ã±í¿Õ¼ä:
ALTER SYSTEM SET undo_tablespace=UNDOTBS02;
Èý¡¢½¨Á¢ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE temp_data
TEMPFILE '/oracle/oradata/db/TEMP_DATA.dbf' SIZE 50M
ËÄ¡¢¸Ä±ä±í¿Õ¼ä״̬
1.ʹ±í¿Õ¼äÍÑ»ú
ALTER TABLESPACE game OFFLINE;
Èç¹ûÊÇÒâÍâɾ³ýÁËÊý¾ÝÎļþ£¬Ôò±ØÐë´øÓÐRECOVERÑ¡Ïî
ALTER TABLESPACE game OFFLINE FOR RECOVER;
2.ʹ±í¿Õ¼äÁª»ú
ALTER TABLESPACE game ONLINE;
3.ʹÊý¾ÝÎļþÍÑ»ú
ALTER DATABASE DATAFILE 3 OFFLINE;
4.ʹÊý¾ÝÎļþÁª»ú
ALTER DATABASE DATAFILE 3 ONLINE;
5.ʹ±í¿Õ¼äÖ»¶Á
ALTER TABLESPACE game READ ONLY;
6.ʹ±í¿Õ¼ä¿É¶Áд
ALTER TABLESPACE game READ WRITE;
Î塢ɾ³ý±í¿Õ¼ä£¨É¾³ýÁÙʱ±í¿Õ¼äÒ²ÊÇͬÑùµÄд·¨£©
DROP TABLESPACE data01 INCLUDING CONTENTS AND DATAFILES;
drop tablespace temp_data including contents and datafiles;(ɾ³ýÁÙʱ±í¿Õ¼ä)
Áù¡¢À©Õ¹±í¿Õ¼ä
Ê×ÏȲ鿴±í¿Õ¼äµÄÃû×ÖºÍËùÊôÎļþ
select tablespace_name, file_id, file_n
Ïà¹ØÎĵµ£º
×î½üÒ»¶Îʱ¼äһֱûд²©¿Í£¬²»ÊÇÀÁ£¬ÊÇѧÁËÌ«¶à¶«Î÷¡£ÒÔºóÂýÂý²¹ÉÏ¡£ 1. odbcÖÐÌí¼ÓoracleÊý¾ÝÔ´ odbcÖÐÌí¼ÓoracleÊý¾ÝÔ´Ê×ÒªÌõ¼þ£º°²×°oracle client¡£°²×°ÍêÖ®ºóÌí¼Ó£¬µ«ÊÇ»¹±ØÐëÔÚ°²×°Ä¿Â¼ÏÂͨ³£ÊÇC:\oracle\ora90\network\ADMIN\tnsnames.oraÖÐÌí¼ÓÒ»¸öÁ¬½Ó£¬Èçϸñʽ£º DXS =
(DESCRIPTION =
......
½ñÄêµÄOracleÈ«Çò´ó»áÓÚ10ÔÂ11ÈÕ£15ÈÕÔÚÃÀ¹ú¾É½ðɽµÄMosconeÖÐÐÄÒѾÀ¿ªÐòÄ»ÁË¡£
¡¡¡¡ Oracle¶ÔSun¹«Ë¾µÄ³¤Æڼƻ®ÎÞÒÉÊDZ¾´ÎOOW´ó»áµÄ½¹µã¡£µ«ÔÚ̸ÂÛÕâ¸ö»°Ìâ֮ǰ£¬ÎÒÃÇ×¼±¸ÁËÒ»×é´ó»áµÄÓÐȤÊý¾Ý£¬ÏÈÈôó¼Ò¶Ô±¾´Î´ó»áÓиöÕûÌåµÄÓ¡Ïó¡£
¡¡¡¡ÓйØÕû¸ö´ó»áµÄÊý×Ö£º
¡¡¡¡· ½ü4.3ÍòÈ˵½»á
¡¡¡¡· ΪÃÀ¹ ......
HWMÊÇoracleÖÐblockÓÐûÓÐʹÓõķֽçÏߣ¬Ëü»áËæ×ÅÊý¾ÝµÄinsert¶øÉÏÉý£¬µ«Ëü²¢²»»áËæÊý¾ÝµÄdelete¶øϽµ£¬Òò´ËÈ«±íɨÃèµÄʱ¼ä²¢²»ÒòÊý¾ÝµÄdelete¶ø¼õÉÙ£¬Ïà·´¿ÉÄÜÓÉÓÚ¿éÇå³ý·´¶øÈ«±íɨÃèʱ¼äÔö¼Ó£¬¿ÉÒÔÓÃÏÂÃæ·½·¨µÄÈÎÒ»Ò»ÖÖÀ´½µµÍHWM£º
µÚÒ»ÖÖ£ºshrink
ÊÊÓÃÓÚ10gÒÔºóµÄ°æ±¾£¬Ç°ÌáÊÇÕâ¸ö±í£¬Ë÷Òý£¬ÎﻯÊÓͼ»òÎﻯÊÓͼlogËùÔ ......
2009-01-02 10:02
µÇ½Éí·ÝÖ¤Ã÷²»ÕýÈ·
OracleÊý¾Ý¿âÓÐÈýÖÖ±ê×¼µÄ±¸·Ý·½·¨£¬ËüÃÇ·Ö±ðΪµ¼³ö/µ¼È루EXPORT/IMPORT£©¡¢À䱸·Ý¡¢Èȱ¸·Ý¡£µ¼³ö±¸·ÝÊÇÒ»ÖÖÂß¼±¸·Ý£¬À䱸·ÝºÍÈȱ¸·ÝÊÇÎïÀí±¸·Ý¡£
Òª½øÐб¸·ÝºÍ»Ö¸´²Ý£¬±ØÐëÔÚÁ¬½Óµ½Oracle Manager Serverºó²ÅÄܽøÐС£Èç¹ûδ´ ......
ÅäÖÃÒ»¸ö¹ÜÀí×ÊÁϿ⣬Æô¶¯£ºConfiguration and Migration tools/Enterprise Manager Configuration Assistant¡£ÔÚÅäÖòÙ×÷ÖÐÑ¡ÔñÅäÖñ¾µØµÄoracle management server/´´½¨Ò»¸öеÄ×ÊÁÏ¿âµµ°¸/µäÐÍ¡£ÏµÍ³½«»á´´½¨Ò»¸öÃûΪoemrepµÄÊý¾Ý¿â£¬±£´æ¹ÜÀíÐÅÏ¢£¬ÆäÖÐÄãÐèÒªÖ¸¶¨sysºÍsystemÕÊ ......