orale tablespace&datafile oracle±í¿Õ¼ä
ÔÚÇ°ÃæѧϰOracleÊý¾Ý¿â»ù´¡¼Ü¹¹Ê±£¬ÒѾÁ˽âÁËOracleµÄ´æ´¢½á¹¹£¬Âß¼ÉÏ£¬OracleµÄÊý¾Ý´æ·ÅÔÚtablespacesÖУ¬ÎïÀíÉÏ´æ·ÅÔÚdatafilesÖС£Ò»¸ötablespaceÖ»ÄÜÊôÓÚÒ»¸öÊý¾Ý¿â(Ò»¸öÊý¾Ý¿â¿É°üÀ¨¶à¸ötablespace)£¬°üÀ¨ÁË1¸ö»ò¶à¸öÊý¾ÝÎļþ¡£Tablespace¿É½øÒ»²½·ÖΪsegments¡¢extentsºÍblocks¡£Ò»¸ödatafileÖ»ÊôÓÚÒ»¸öÊý¾Ý¿âµÄÒ»¸ötablespace¡£
TablespaceµÄ·ÖÀàÓÐ2ÖÖ£¬Ò»ÖÖ·ÖΪSYSTEM tablespaceºÍNon-SYSTEM tablespace¡£
SYSTEM tablespaceÊÇËæÊý¾Ý¿âµÄ´´½¨¶ø´´½¨µÄ£¬°üº¬ÁËÊý¾Ý×ÖµäºÍSYSTEM undo segment£»Non-SYSTEM tablespace°üÀ¨ÁË·ÖÅä¸øÓû§µÄ¿Õ¼ä±ãÓÚÊý¾Ý¿âµÄ¿Õ¼ä¹ÜÀí¡£
ÁíÒ»ÖÖ·ÖΪpermanent¡¢undo¡¢temporaryÈýÖÖtablespace¡£Ò»°ã²»¼ÓÌرð˵Ã÷ʱËù´´½¨µÄpermanent tablespace£¬±£´æÓÀ¾ÃÐÔ¶ÔÏó£»undo tablespaceÓÃÓÚ±£´æundo segmentsÒÔ±ãÓڻعö²Ù×÷£¬¶ø²»ÄÜ°üº¬ÆäËû¶ÔÏó£»temporary tablespaceÊÇÓÃÓÚ½øÐÐÅÅÐò²Ù×÷£¬Äܹ»±»¶à¸öÓû§¹²Ïí£¬²»ÄÜ°üº¬ÓÀ¾ÃÐÔ¶ÔÏó.
Temporary tablespaceÖÐÓÐÒ»¸ödefault temporary tablespace£¬Ö¸¶¨ÁËÒ»¸öÈ«¾ÖµÄĬÈÏÁÙʱ±í¿Õ¼ä£¬Èç¹ûûÓÐÕâ¸ö±í¿Õ¼ä£¬Ä¬ÈÏÇé¿öÏ£¬ÊÇʹÓÃSYSTEM tablespaceÀ´´æ´¢ÁÙʱÊý¾ÝµÄ£¬ÏÔÈ»£¬ÕâÊDz»ºÃµÄ£¬Ä¬ÈÏÁÙʱ±í¿Õ¼äÖ»ÓÐÒ»¸ö£¬¿ÉÒÔ´Ó±ídatabase_propertiesÖв鿴default temp tablespace£¬ÔÚеÄdefault temp tablespace±»´´½¨Ö®Ç°£¬ÊDz»Äܱ»droppedµÄ¡£
ºÍtablespaceÒÔ¼°datafileÏà¹ØµÄÊý¾Ý×ÖµäÓÐ:dba_tablespaces¡¢v$tablespace¡¢dba_data_files¡¢v$datafile¡¢dba_temp_files¡¢v$tempfile¡£
1¡¢´´½¨±í¿Õ¼ä
´´½¨±í¿Õ¼äµÄÍêÕûÃüÁî:
Create [undo] tablespace <ts_name>
datafile <file_spec1> [,<file_spec2>]
mininum extent <m> k|m
blocksize <n> [k]
logging clause
force logging
default storage_clause
online | offline
permanent | temporary
extent_manager_clause
segment_manager_clause
1)¡¢undoÖ¸¶¨ÏµÍ³½«´´½¨Ò»¸ö»Ø¹ö±í¿Õ¼ä
2£©¡¢tablespaceÖ¸¶¨±í¿Õ¼äÃû³Æ
3)¡¢datafileÖ¸¶¨Êý¾ÝÎļþµÄ·¾¶¡¢Ãû³Æ¡¢´óС¼°×ÔÔö³¤×´¿ö£º¾ßÌåÐÎÈç'E:\oracle\product\10.2.0\oradata\orcl\TEST.DBF' size 50M autoextend on next 10M maxsize 500M£¬Ò²¿ÉÒÔÖ¸¶¨onΪoff£¬¾ÍûÓкóÃæµÄµÝÔöºÍ×î´ó³ß´çÁË£¬Ò²¿ÉÒÔÔÚmaxsizeºóÃæÖ¸¶¨×î´ó³ß´çunlimited˵Ã÷±í¿Õ¼äÎÞÏÞ´ó¡£
4)¡¢mininum extent <m> k|mÖ¸³öÔÚ±í¿Õ¼äµÄextentµÄ×îСֵ£¬Õâ¸ö²ÎÊý¿É
Ïà¹ØÎĵµ£º
½ñÌìͬÊÂraiseÒ»¸öСÎÊÌ⣬ÔõôÔÚALL_VIEWSÊý¾Ý×Öµätext×ֶβéÕÒlrf×Ö·û´®£º
etl@DWTEST> select owner,view_name from all_views where instr(text,'lrf') > 0;
select owner,view_name from all_views where instr(text,'lrf') > 0
  ......
OracleÖÐÁÙʱ±í²úÉú¹ýÁ¿RedoµÄ˵Ã÷
×î½ü,ÔÚOracle9iÖÐÄãÓùýÁÙʱ±íÂð?
ËüÊÇ·ñ¸øÄã´øÀ´ÁËÐÔÄÜÌá¸ß?Äã×¢Òâ¹ýô?
--------------------------------------------------------------------------------
ºÃÁËÑÔ¹éÕý´«.
ÎÒÃÇÖªµÀÁÙʱ±íÔÚDML²Ù×÷ÖпÉÒÔ¼õÉÙredoµÄÉú³É,´Ó¶øÔÚ±£´æÖмä½á¹û¼¯Ê±¿ÉÒÔ´øÀ´½Ï´óµÄÐÔÄÜÌá¸ß.
¿ÉÊÇ,È ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´ÐУ¬
......
1¡¢²é¿´ORACLE×î´óÓαêÊý
C:\Documents and Settings\Administrator>sqlplus "sys/admin@test151 as sysdba" £¨sysÒÔdbaµÇ¼test151·þÎñ£©
SQL*Plus: Release 9.2.0.1.0 - Production on ÐÇÆÚËÄ 11ÔÂ 5 09:08:04 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights ......