Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Ï°²×°oracle11g²½ÖèÓëÌå»á

ÔÚlinuxÉÏ°²×°oracleÊÇÒ»¼þ¸´ÔÓµÄÊÂÇ飬ÓÈÆä¶ÔÓÚÒ»¸öÉúÊÖÀ´Ëµ£¬ËüµÄ¸´Ôӳ̶ÈÔ¶³¬¹ýÁËlinux²Ù×÷ϵͳµÄ°²×°£¬ÒòΪ²»ÏñwindowsÄÇÑù¿ÉÒÔÖ±½Óµã»÷sertup.exe¾ÍokÁË£¬ÔÚ°²×°Ö®Ç°ÄãÒªÅäÖû·¾³±äÁ¿£¬ÐÞ¸ÄÈô¸É¸öϵͳÎļþ£¬²¢ÇÒÕâЩ²ÎÊý¿ÉÄܸù¾ÝÄãlinux°æ±¾µÄ²»Í¬¶øÓÐËù²»Í¬£¬Èç¹ûÅäÖò»ÕýÈ·£¬¿ÉÄܵ¼ÖÂ×îÖյݲװʧ°Ü£¬ÆäËü»¹ÓÐÄãµÄÄ¿ ......

oracle ´óÊý¾Ý²éѯÓÅ»¯µÄ·½°¸

ijÊý¾Ý¿âÖеÄÒ»ÕűíA,±íAµÄÊý¾Ý¿âÁ¿ÏÖÔÚ´ó¸ÅÓÐ10ÒÚÌõÊý¾ÝÖ®¶à.
×î³õµÄ×ö·¨ÊÇÈ«²¿´æ·ÅÔÚÒ»¸ö±í¿Õ¼äÖÐ.Ôì³ÉÏÖÔڵIJéѯËٶȹêÅÀËƵÄ.ÏÖÔÚ²»µÃ²»¶ÔÊý¾Ý¿â×ö³öÖØÐÂÆÀ¹ÀºÍÓÅ»¯.
×î³õµÄÇ°Ìá:
1.ÖÐÓ¦¸Ã½¨Á¢µÄË÷Òý¶¼ÒѾ߱¸
2.²éѯÓï¾ä¶¼ÒѾ­×öµ½ÓÅ»¯:ÏÖÔÚÀàËÆÓÚ select count(1) from A Õâô¼òµ¥µÄÒ»¾äͳ¼ÆSQL¶¼ÐèÒª100S×óÓÒ
ta ......

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

F.1×Ö·ûº¯Êý——·µ»Ø×Ö·ûÖµ
ÕâЩº¯ÊýÈ«¶¼½ÓÊÕµÄÊÇ×Ö·û×åÀàÐ͵IJÎÊý(CHR³ýÍâ)²¢ÇÒ·µ»Ø×Ö·ûÖµ.³ýÁËÌرð˵Ã÷µÄÖ®Íâ,ÕâЩº¯Êý´ó²¿·Ö·µ»ØVARCHAR2ÀàÐ͵ÄÊýÖµ.×Ö·ûº¯ÊýµÄ·µ»ØÀàÐÍËùÊܵÄÏÞÖƺͻù±¾Êý¾Ý¿âÀàÐÍËùÊܵÄÏÞÖÆÊÇÏàͬµÄ,±ÈÈç: VARCHAR2ÊýÖµ±»ÏÞÖÆΪ2000×Ö·û(ORACLE 8ÖÐΪ4000×Ö·û),¶øCHARÊýÖµ±»ÏÞÖÆΪ255×Ö·û(Ô ......

APACHE PHP5 ORACLEÉèÖÃ

ÔÚwindows ÏÂÅäÖÃPHPʹÓÃORACLEÊý¾Ý¿âÒªµã
ÔÚwindowÏ£¬¾­³£ÓÃapache + PHP À´×öÓ¦ÓÃƽ̨£¬µ«ÊÇÈç¹ûʹÓÃoracle×öºǫ́Êý¾Ý¿â£¬µ«ÓÖûÓа²×°ÓÐoracle¿Í»§¶Ë£¬ÏÂÃæµÄÅäÖÿÉÒԲο¼
1¡¢ÔÚûÓа²×°oracleµÄ»úÆ÷ÉÏ£¬PHPÎÞ·¨¼ÓÔØphp_oci8.dllÄ£¿é£¬Ô­ÒòÊÇphp_oci8.dllÒÀÀµµÄÏà¹Ø×é¼þûÓÐÕÒµ½¡£
     ÄãÕýÈ·ÉèÖÃÁË ......

Oracle 10g R2 RACÔÚVMWAREÉϵݲװ

½¨Á¢sshÐÅÈΣ¬racµÄ°²×°ÒªÓÃsshºÍscpÀ´¿½±´°²×°Îļþ¡£
ÔÚËùÓеĽڵãÉÏÔËÐУº
mkdir ~/.ssh
chmod 700 ~/.ssh
ssh-keygen -t rsa
ssh-keygen -t dsa
ÔÚrdb1½ÚµãÉÏÖ´ÐУº
ssh rdb1 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh rdb1 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
ssh rdb2 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ