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

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


Ïà¹ØÎĵµ£º

oracle 10 em

Ò»¡¢Enterprise Manager 10g
ĬÈÏÇé¿öÏ£¬°²×°Oracleʱ£¬»á°²×°EM¡£ËüÊÇλÓÚÊý¾Ý¿â·þÎñÆ÷ÉϵÄHTTP·þÎñÆ÷¡£
£¨1£©Æô¶¯EM
Ҫȷ±£OracleDBConsole<SID>·þÎñÒѾ­Æô¶¯¡£
Æô¶¯·þÎñ£ºemctl start dbconsole
¹Ø±Õ·þÎñ£ºemctl stop dbconsole
·ÃÎÊEM£ºhttp://·þÎñÆ÷Ãû³Æ£º¶Ë¿ÚºÅ/em
¶Ë¿ÚºÅ¿ÉÔÚ$ORACLE_HOME/install/pro ......

ORACLE°²×°Ö®ºóµÇ½Éí·ÝÖ¤Ã÷²»ÕýÈ·

2009-01-02 10:02
µÇ½Éí·ÝÖ¤Ã÷²»ÕýÈ·
     OracleÊý¾Ý¿âÓÐÈýÖÖ±ê×¼µÄ±¸·Ý·½·¨£¬ËüÃÇ·Ö±ðΪµ¼³ö/µ¼È루EXPORT/IMPORT£©¡¢À䱸·Ý¡¢Èȱ¸·Ý¡£µ¼³ö±¸·ÝÊÇÒ»ÖÖÂß¼­±¸·Ý£¬À䱸·ÝºÍÈȱ¸·ÝÊÇÎïÀí±¸·Ý¡£
     Òª½øÐб¸·ÝºÍ»Ö¸´²Ý£¬±ØÐëÔÚÁ¬½Óµ½Oracle Manager Serverºó²ÅÄܽøÐС£Èç¹ûδ´ ......

Oracle Management ServerÅäÖÃ

Oracle Management ServerÅäÖò½ÖèÈçÏ£º
1¡¢Ê¹ÓÃenterprise manager configuration assistant½¨Á¢µµ°¸×ÊÁÏ¿â
   ÆäÖпÉÑ¡Ôñн¨Ò»¸öÊý¾Ý¿âʵÀý»òÕßÔÚÒÑÓÐÊý¾Ý¿âʵÀýÖÐн¨×ÊÁϿ⣨н¨±í¿Õ¼ä£©¡£
2¡¢Æô¶¯management server
3¡¢ÔËÐÐenterprise manage console£¬Ñ¡ÔñµÇ¼µ½management server
   µÇ ......

ÈçºÎ´ÓÍêºÃµÄÊý¾ÝÎļþ»Ö¸´oracleÊý¾Ý¿â

Ò»¡£ÓÐÊý¾ÝÎļþ¡¢¿ØÖÆÎļþºÍÈÕÖ¾ÎļþµÄ±¸·Ý1.·þÎñÆ÷ÖØ×°Á˲Ù×÷ϵͳ£¬oracleÒ²ÖØ×°ÁË¡£Èç¹ûÖØ×°µÄoracleºÍÒÔÇ°Ë𻵵ÄÊý¾Ý¿âÊÇһģһÑùµÄ½á¹¹£¬ÄÇô´ËʱµÄ»Ö¸´ÊDZȽϼòµ¥µÄ¡£
    1£©É¾³ýµôн¨Êý¾Ý¿âµÄËùÓÐÊý¾ÝÎļþ¡¢¿ØÖÆÎļþºÍÈÕÖ¾Îļþ¡£CopyÔ­Êý¾Ý¿âµÄÊý¾ÝÎļþ¡¢¿ØÖÆÎļþºÍÈÕÖ¾Îļþµ½¶ÔӦĿ¼Ï¡£
  ......

OracleÊý¾Ý¿âΪʲô±äÂýÁË£¿

±¾Îijö×Ô¡¶Íø¹ÜÔ±ÊÀ½ç¡·20002ÄêµÚ8ÆÚ“¹ÊÕÏÕï¶Ï”À¸Ä¿
Ó²¼þ»·¾³£º SUN250·þÎñÆ÷£¬1G CPU , 512M Ram , 18G SCSIÓ²ÅÌ
ϵͳ»·¾³£º SUN Solaris 2.7
·þÎñ»·¾³£º Oracle 8.1.6
ÖÜÎåÎÒ·¢ÏÖOracleÊý¾Ý¿âÔÚÖ´ÐгÌÐòʱµÄÏìÓ¦ÌرðÂý£¬Õû¸öÊý¾Ý¿â·þÎñËùÔÚµÄSUN Solaris 2.7ϵͳҲÊÇÕâÑù£¬ÎÞÂÛÔËÐÐʲô³ÌÐò¶¼±ÈÍù³£ÂýÁ˺ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ