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

Ϊ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ÈÏÖ¤Åàѵ³£¼ûÎÊÌâ

ORACLEÈÏÖ¤Åàѵ³£¼ûÎÊÌâ
1¡¢ÎÊ£ºÊ²Ã´ÊÇ Oracle ÈÏÖ¤£¿¶¼ÓÐÄÄЩÖÖÀࣿ                              
¡¡¡¡´ð£ºOracle ÈÏÖ¤ÊÇÓÉOracle¹«Ë¾°ä²¼²¢ÊµÊ©µÄÒ»ÏîÈ¨Í ......

oracleÊÂÎñµÄÖ´Ðйý³Ì

1.¿Í»§¶ËÁ¬½ÓÖÁoralce:
             Ê×Ïȿͻ§¶ËÁ¬½ÓÖÁoracleµÄ¼àÌýÆ÷,È»ºó¼àÌýÆ÷·ÖÅäÒ»¸öÊý¾Ý¿âʵÀý(ÕâÀïµÄÊÇʵÀý)¸ø¿Í»§¶Ë,È»ºó¿Í»§¶ËÒÔºó¾ÍÖ±½ÓÓëÕâ¸öÊý¾Ý¿âʵÀý½øÐÐÁ¬½Ó,Ö±ÖÁ¶Ï¿ªÓëoracleµÄÁ¬½Ó.
 
2.Ìá½»sql:
  (1)¿Í»§¶ËÓû§Ìá½»Ò»¸ösql ......

Oracle index µÄÔËÓÃ

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 ......

oracleµÄÕýÔò±í´ïʽ(regular expression)¼òµ¥½éÉÜ

Ŀǰ£¬ÕýÔò±í´ïʽÒѾ­ÔںܶàÈí¼þÖеõ½¹ã·ºµÄÓ¦Ó㬰üÀ¨*nix£¨Linux, UnixµÈ£©£¬HPµÈ²Ù×÷ϵͳ£¬PHP£¬C#£¬JavaµÈ¿ª·¢»·¾³¡£
 
Oracle 10gÕýÔò±í´ïʽÌá¸ßÁËSQLÁé»îÐÔ¡£ÓÐЧµÄ½â¾öÁËÊý¾ÝÓÐЧÐÔ£¬ ÖØ¸´´ÊµÄ±æÈÏ, Î޹صĿհ׼ì²â£¬»òÕß·Ö½â¶à¸öÕýÔò×é³É
µÄ×Ö·û´®µÈÎÊÌâ¡£
 
Oracle 10gÖ§³ÖÕýÔò±í´ïʽµÄËĸöк¯Êý ......

oracleһЩ²Ù×÷

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ