ΪOracleÊý¾Ý¿â´´½¨Óû§
Oracle°²×°Íêºó£¬ÆäÖÐÓÐÒ»¸öȱʡµÄÊý¾Ý¿â£¬³ýÁËÕâ¸öȱʡµÄÊý¾Ý¿âÍ⣬ÎÒÃÇ»¹¿ÉÒÔ´´½¨×Ô¼ºµÄÊý¾Ý¿â¡£
¶ÔÓÚ³õѧÕßÀ´Ëµ£¬ÎªÁ˱ÜÃâÂé·³£¬¿ÉÒÔÓÃ'Database Configuration Assistant'Ïòµ¼À´´´½¨Êý¾Ý¿â¡£
´´½¨ÍêÊý¾Ý¿âºó£¬²¢²»ÄÜÁ¢¼´ÔÚÊý¾Ý¿âÖн¨±í£¬±ØÐëÏÈ´´½¨¸ÃÊý¾Ý¿âµÄÓû§£¬²¢ÇÒΪ¸ÃÓû§Ö¸¶¨±í¿Õ¼ä¡£
ÏÂÃæÊÇ´´½¨Êý¾Ý¿âÓû§µÄ¾ßÌå¹ý³Ì£º
1.¼ÙÈçÏÖÔÚÒѾ½¨ºÃÃûΪ'news'µÄÊý¾Ý¿â£¬´ËʱÔÚF:\oracle\product\10.1.0\oradata\Ŀ¼ÏÂÒѾ´æÔÚnewsĿ¼£¨×¢Ò⣺ÎÒµÄOracle10g°²×°ÔÚF:\oracleÏ£¬ÈôÄãµÄOracle°²×°ÔÚ±ðµÄĿ¼£¬ÄÇôÄãн¨µÄÊý¾Ý¿âĿ¼¾ÍÔÚ*\product\10.1.0\oradata\Ŀ¼Ï£©¡£
2.ÔÚ´´½¨Óû§Ö®Ç°£¬ÏÈÒª´´½¨±í¿Õ¼ä£º
Æä¸ñʽΪ£º¸ñʽ: create tablespace ±í¼äÃû datafile 'Êý¾ÝÎļþÃû' size ±í¿Õ¼ä´óС;
È磺
SQL> create tablespace news_tablespace datafile 'F:\oracle\product\10.1.0\oradata\news\news_data.dbf' size 500M;
ÆäÖÐ'news_tablespace'ÊÇÄã×Ô¶¨ÒåµÄ±í¿Õ¼äÃû³Æ£¬¿ÉÒÔÈÎÒâÈ¡Ãû£»'F:\oracle\product\10.1.0\oradata\news\news_data.dbf'ÊÇÊý¾ÝÎļþµÄ´æ·ÅλÖã¬'news_data.dbf'ÎļþÃûÒ²ÊÇÈÎÒâÈ¡£»'size 500M'ÊÇÖ¸¶¨¸ÃÊý¾ÝÎļþµÄ´óС£¬Ò²¾ÍÊDZí¿Õ¼äµÄ´óС¡£
3.ÏÖÔÚ½¨ºÃÁËÃûΪ'news_tablespace'µÄ±í¿Õ¼ä£¬ÏÂÃæ¾Í¿ÉÒÔ´´½¨Óû§ÁË(Oracle¹æ¶¨ÁËÈýÖÖ»ù±¾Óû§Éí·Ýnormal¡¢sysoper¡¢sysdba¡£ÆäÖÐsysdbaºÍsysoper¶¼ÊôÓÚϵͳ¼¶Óû§£¬Ö»ÓÐͨ¹ýÊÚȨµÄnormalÓû§²Å¿ÉÒÔÖ±½Ó·ÃÎÊн¨µÄ±í¿Õ¼äÖеÄÊý¾ÝÐÅÏ¢)¡££º
Æä¸ñʽΪ£º¸ñʽ: create user Óû§Ãû identified by ÃÜÂë default tablespace ±í¿Õ¼ä±í;
È磺
SQL> create user news identified by news default tablespace news_tablespace;
ĬÈϱí¿Õ¼ä'default tablespace'ʹÓÃÉÏÃæ´´½¨µÄ±í¿Õ¼ä¡£
4.½Ó×ÅÊÚȨ¸øÐ½¨µÄÓû§£º
SQL> grant connect,resource to news; --±íʾ°Ñ connect,resourceȨÏÞÊÚÓènewsÓû§
Ïà¹ØÎĵµ£º
ORACLEÈÏÖ¤Åàѵ³£¼ûÎÊÌâ
1¡¢ÎÊ£ºÊ²Ã´ÊÇ Oracle ÈÏÖ¤£¿¶¼ÓÐÄÄЩÖÖÀࣿ
¡¡¡¡´ð£ºOracle ÈÏÖ¤ÊÇÓÉOracle¹«Ë¾°ä²¼²¢ÊµÊ©µÄÒ»ÏîÈ¨Í ......
1.¿Í»§¶ËÁ¬½ÓÖÁoralce:
Ê×Ïȿͻ§¶ËÁ¬½ÓÖÁoracleµÄ¼àÌýÆ÷,È»ºó¼àÌýÆ÷·ÖÅäÒ»¸öÊý¾Ý¿âʵÀý(ÕâÀïµÄÊÇʵÀý)¸ø¿Í»§¶Ë,È»ºó¿Í»§¶ËÒÔºó¾ÍÖ±½ÓÓëÕâ¸öÊý¾Ý¿âʵÀý½øÐÐÁ¬½Ó,Ö±ÖÁ¶Ï¿ªÓëoracleµÄÁ¬½Ó.
2.Ìá½»sql:
(1)¿Í»§¶ËÓû§Ìá½»Ò»¸ösql ......
1 ²é¿´Ä³ÕűíµÄindexµÄÏêϸÐÅÏ¢¡££¨column_position´ú±íÑ¡Ôñ˳Ðò£©
select table_name, index_name, column_name, column_position
from user_ind_columns
where table_name = 'T_BASE_DATA_DICTIONARY'
order by table_name, index_name, column_position;
2 ÔÚ´´½¨±íʱ¶ÔÁÐÖ¸¶¨NOT NULLºó»á½ûÓÃN ......
Ŀǰ£¬ÕýÔò±í´ïʽÒѾÔںܶàÈí¼þÖеõ½¹ã·ºµÄÓ¦Ó㬰üÀ¨*nix£¨Linux, UnixµÈ£©£¬HPµÈ²Ù×÷ϵͳ£¬PHP£¬C#£¬JavaµÈ¿ª·¢»·¾³¡£
Oracle 10gÕýÔò±í´ïʽÌá¸ßÁËSQLÁé»îÐÔ¡£ÓÐЧµÄ½â¾öÁËÊý¾ÝÓÐЧÐÔ£¬ ÖØ¸´´ÊµÄ±æÈÏ, Î޹صĿհ׼ì²â£¬»òÕß·Ö½â¶à¸öÕýÔò×é³É
µÄ×Ö·û´®µÈÎÊÌâ¡£
Oracle 10gÖ§³ÖÕýÔò±í´ïʽµÄËĸöк¯Êý ......
1.²é¿´±í¿Õ¼ä:
SELECT A.TABLESPACE_NAME,A.BYTES TOTAL,B.BYTES USED, C.BYTES FREE,
(B.BYTES*100)/A.BYTES "% USED",(C.BYTES*100)/A.BYTES "% FREE"
from SYS.SM$TS_AVAIL A,SYS.SM$TS_USED B,SYS.SM$TS_FREE C
WHERE A.TABLESPACE_NAME=B.TABLESPACE_NAME AND A.T ......