Oracle±í¿Õ¼äµÄ¹ÜÀí
Oracle±í¿Õ¼äµÄ¹ÜÀí
1.´´½¨±í¿Õ¼ä
//´´½¨ÁÙʱ±í¿Õ¼ä
create temporary tablespace test_temp
tempfile 'E:\oracle\product\10.2.0\oradata\testserver\test_temp01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
//´´½¨Êý¾Ý±í¿Õ¼ä
create tablespace test_data
logging
datafile 'E:\oracle\product\10.2.0\oradata\testserver\test_data01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
2.¸øÓû§Ö¸¶¨±í¿Õ¼ä
//´´½¨Óû§²¢Ö¸¶¨±í¿Õ¼ä
create user testserver_user identified by testserver_user
default tablespace test_data
temporary tablespace test_temp;
//¸øÓû§ÊÚÓèȨÏÞ
grant connect,resource to testserver_user;
3.±í¿Õ¼äǨÒÆ
·½·¨1£º
alter table tb_name move tablespace tbs_name;
À´¶Ô±í×ö¿Õ¼äǨÒÆʱֻÄÜÒƶ¯·Çlob×Ö¶ÎÒÔÍâµÄÊý¾Ý£¬¶øÈç¹ûÎÒÃÇҪͬʱÒƶ¯lobÏà¹Ø×ֶεÄÊý¾Ý£¬ÎÒÃǾͱØÐèÓÃÈçϵĺ¬ÓÐÌØÊâ²ÎÊý¾ÝµÄÎľäÀ´Íê³É£¬Ëü¾ÍÊÇ£º
alter table tb_name move tablespace tbs_name lob(col_lob1,col_lob2) store as(tablesapce tbs_name);
·½·¨2£ºÀûÓÃȱʡ±í¿Õ¼ä
ȱʡÇé¿öÏ£¬µ¼ÈëÊÔͼÔÚÓëµ¼³öÏàͬµÄ±í¿Õ¼äÖд´½¨¶ÔÏó¡£Èç¹ûÓû§²»¾ßÓÐÄǸö±í¿Õ¼äµÄȨÏÞ£¬»òÕßÄǸö±í¿Õ¼ä²»´æÔÚʱ£¬OracleÔÚÓû§ÕÊ»§µÄȱʡ±í¿Õ¼äÖд´½¨Êý¾Ý¿â¶ÔÏó¡£ÕâЩÌØÐÔ¿ÉÒÔÓÃÓÚʹÓõ¼³öÓëµ¼ÈëÔÚ±í¿Õ¼äÖ®¼äÒƶ¯Êý¾Ý¿â¶ÔÏó¡£
ҪΪUSER_A½«TABLESPACE_AµÄËùÓжÔÏóÒƶ¯µ½TABLESPACE_B£¬Ó¦×ñÑÒÔϲ½Ö裺
£¨1£© ΪUSER_Aµ¼³öTABLESPACE_AÖеÄËùÓжÔÏó¡£
£¨2£© Ö´ÐÐREVOKE UNLIMITED TABLESPACE ON TABLESPACE_A from USER_A;ÒÔÊÕ»ØÈκÎÊÚÓèÓû§ÕÊ»§µ
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
Oracle×îÐÂÈÏÖ¤Ìâ¿â×ÊÁÏÏÂÔØ
Actualtests Oracle 1Z0-200 V11.07.08
Actualtests Oracle 1Z0-211 V11.10.08
Actualtests Oracle 1Z0-212 V11.07.08
Actualtests Oracle 1Z0-213 V11.07.08
Actualtests Oracle 1Z0-101 V11.07.08
Actualtests Oracle 1Z0-132 V11.07.08
Actualtests Oracle 1Z0-140 V11.21.08
Actual ......
ÎÊÌâÃèÊö
=======
ÔÚÊÔͼÆô¶¯Êý¾Ý¿âµÄʱºò,Oracle±¨¸æÏÂÁдíÎó£º
ERROR:
ORA-27101 Shared memory realm does not exist
ORA-01034 ORACLE not available
»ù±¾½âÊÍ
=======
Error: ORA-27101
Text: shared memory realm does not exist
-------------------------------------------
Ca ......
http://blog.csdn.net/junmail/archive/2009/07/29/4392264.aspx
¾Û¼¯(cluster)ÊÇ´æ´¢±íÊý¾ÝµÄ¿ÉÑ¡ÔñµÄ·½·¨¡£Ò»¸ö¾Û¼¯ÊÇÒ»×é±í£¬½«¾ßÓÐͬһ¹«¹²ÁÐÖµµÄÐд洢ÔÚÒ»Æ𣬲¢ÇÒËüÃǾ³£Ò»ÆðʹÓá£ÕâЩ¹«¹²Áй¹³É¾Û¼¯Âë¡£
¾³£±»Í¬Ê±·ÃÎʵıíÔÚÎïÀíλÖÃÉÏ¿ÉÒÔ´æ´¢ÔÚÒ»Æð¡£ÎªÁ˽«ËüÃÇ´æ´¢ÔÚÒ»Æ𣬾ÍÒª´´½¨Ò»¸ö´Ø( c ......
¾Û¼¯(cluster)ÊÇ´æ´¢±íÊý¾ÝµÄ¿ÉÑ¡ÔñµÄ·½·¨¡£Ò»¸ö¾Û¼¯ÊÇÒ»×é±í£¬½«¾ßÓÐͬһ¹«¹²ÁÐÖµµÄÐд洢ÔÚÒ»Æ𣬲¢ÇÒËüÃǾ³£Ò»ÆðʹÓá£ÕâЩ¹«¹²Áй¹³É¾Û¼¯Âë¡£
¾³£±»Í¬Ê±·ÃÎʵıíÔÚÎïÀíλÖÃÉÏ¿ÉÒÔ´æ´¢ÔÚÒ»Æð¡£ÎªÁ˽«ËüÃÇ´æ´¢ÔÚÒ»Æ𣬾ÍÒª´´½¨Ò»¸ö´Ø( c l u s t e r )À´¹ÜÀíÕâЩ±í¡£±íÖеÄÊý¾ÝÒ»Æð´æ´¢ÔÚ´ØÖУ¬´Ó¶ø×îС»¯±ØÐëÖ´ÐеÄI ......