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

´´½¨ºÍɾ³ýOracleÊý¾Ý¿âÓû§¡¢±í¿Õ¼ä

1. ´´½¨ÆÕͨÓû§
  >create user username identified by username;
  >grant create tablespace, resource ,connect to username;
2. ´´½¨±í¿Õ¼äºÍÓû§
    2.1 ´´½¨ÁÙʱ±í¿Õ¼ä
  >create temporary tablespace DB_TEMP
   tempfile '/opt/oracle/oradata/mydb/ts_db_temp01.dbf'
   size 200M
   autoextend on
   next 50M maxsize unlimited
   extent management local;
    2.2 ´´½¨Êý¾Ý±í¿Õ¼ä
  >create tablespace DB_TABLESPACE
   logging
   datafile '/opt/oracle/oradata/mydb/ts_db_data01.dbf'
   size 500M 
   autoextend on 
   next 50M  maxsize unlimited
   extent management local;
    2.3 ´´½¨Óû§²¢Ö¸¶¨±í¿Õ¼ä
  >create user username identified by password
   default tablespace DB_TABLESPACE
   temporary tablespace DB_TEMP;
    2.4 ¸øÓû§ÊÚÓèȨÏÞ
  >grant connect,resource to username;
3. ɾ³ýOracleÊý¾Ý¿âÓû§ºÍ±í¿Õ¼ä
    3.1 ɾ³ýOracleÊý¾Ý¿âÓû§
  >drop user user cascade;
    3.2 ɾ³ýOracleÊý¾Ý¿â¿Õ¼ä
  >drop tablespace tsname including contents and datafiles;


Ïà¹ØÎĵµ£º

linuxϵͳÖÐÅäÖÃoracle¿ª»ú×ÔÆô¶¯

Centos  redhat ,oracle10g,oracle11g¾ùÊÊÓÃ
 
1.       ±àд½Å±¾£º
# vi  startoracle.sh
#11gµÄ»°Ö»ÊÇÕâ¸öĿ¼ÓÐËùÇø±ð
ORACLE_HOME=/home/oracle/product/10.2.0/db_1;export ORACLE_HOME
 
ORACLE_SID=orcl;export ORACLE_SID #ÕâÀïÅäÉÏÄãµÄ±¾µØʾÀýÃû
&nbs ......

¹ØÓÚoracleµÄ³¹µ×жÔØÎÊÌâ

oracle9iжÔØ
1,ÔÚ·þÎñÖÐÍ£Ö¹oracleµÄËùÓзþÎñ
2,ÔÚ³ÌÐòÁËжװËùÓÐOracle²úÆ·£¬(µ«Universal Installer±¾Éí²»Äܱ»É¾³ý)
3,ɾ³ý×¢²á±í:
(1)ÔËÐÐregeditÑ¡ÔñHKEY_LOCAL_MACHINE\SOFTWARE\ORACLE£¬É¾³ýÕâ¸öÏî
(2)Ñ¡ÔñHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Oracle,ɾ³ýÕâ¸öÏî.
(3),Ñ¡ÔñHKEY_LOCAL_MACHI ......

oracleº¯Êý´óÈ« Êý×Ö´¦Àíº¯Êý


oracleº¯Êý´óÈ«-Êý×Ö´¦Àíº¯Êý
F.3    Êý×Öº¯Êý
º¯Êý½ÓÊÜNUMBERÀàÐ͵IJÎÊý²¢·µ»ØNUMBERÀàÐ͵ÄÊýÖµ.³¬Ô½º¯ÊýºÍÈý½Çº¯ÊýµÄ·µ»ØÖµ¾«È·µ½36λ.ACOS¡¢ASIN¡¢ATAN¡¢ATAN2µÄ½á¹û¾«È·µ½36λ.
l         ABS
Óï·¨:   ABS(x)
¹¦ÄÜ:   µÃµ½xµÄ¾ø¶ÔÖ ......

oracleʵÀýÃû,·þÎñÃûµÈ¸ÅÄîÇø±ðÓëÁªÏµ

oracleʵÀýÃû,·þÎñÃûµÈ¸ÅÄîÇø±ðÓëÁªÏµ
 
Ò»¡¢Êý¾Ý¿âÃûITPUB¸öÈË¿Õ¼äv{7x6lo\
ʲôÊÇÊý¾Ý¿âÃû£¿ITPUB¸öÈË¿Õ¼ä*s*R5LVBXZ2w$I
Êý¾Ý¿âÃû¾ÍÊÇÒ»¸öÊý¾Ý¿âµÄ±êʶ£¬¾ÍÏñÈ˵ÄÉí·ÝÖ¤ºÅÒ»Ñù¡£ËûÓòÎÊýDB_NAME±íʾ£¬Èç¹ûһ̨»úÆ÷ÉÏ×°Á˶àÈ«Êý¾Ý¿â£¬ÄÇôÿһ¸öÊý¾Ý¿â¶¼ÓÐÒ»¸öÊý¾Ý¿âÃû¡£ÔÚÊý¾Ý¿â°²×°»ò´´½¨Íê³ÉÖ®ºó£¬²Î ......

Oracle רÓ÷þÎñÆ÷Óë¹²Ïí·þÎñÆ÷µÄÇø±ð

רÓ÷þÎñÆ÷£ºÒ»¸ö¿Í»§¶ËÁ¬½Ó¶ÔÓ¦Ò»¸ö·þÎñÆ÷½ø³Ì
¹²Ïí·þÎñÆ÷£º¶à¸ö¿Í»§¶ËÁ¬½Ó¶ÔÓ¦Ò»¸ö·þÎñÆ÷½ø³Ì£¬·þÎñÆ÷¶Ë´æÔÚÒ»¸ö½ø³Ìµ÷¶ÈÆ÷À´¹ÜÀí¡£
OracleȱʡÓõÄÊÇרÓ÷þÎñÆ÷ģʽ£¬Oracle¿ÉÒÔͬʱ֧³Ö¹²Ïí·þÎñÆ÷ºÍרÓ÷þÎñÆ÷ģʽ£¬¿ÉÒÔÖ¸¶¨Ò»¸ö»á»°Ê¹ÓÃרÓ÷þÎñÆ÷£¬ÁíÒ»¸ö»á»°Ê¹Óù²Ïí·þÎñÆ÷¡£
¹²Ïí·þÎñÆ÷¾ßÓÐÒÔÏÂһЩȱµã£º
1)¹² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ