´´½¨ºÍɾ³ý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ÊÇÒ»¼þ¸´ÔÓµÄÊÂÇ飬ÓÈÆä¶ÔÓÚÒ»¸öÉúÊÖÀ´Ëµ£¬ËüµÄ¸´Ôӳ̶ÈÔ¶³¬¹ýÁËlinux²Ù×÷ϵͳµÄ°²×°£¬ÒòΪ²»ÏñwindowsÄÇÑù¿ÉÒÔÖ±½Óµã»÷sertup.exe¾ÍokÁË£¬ÔÚ°²×°Ö®Ç°ÄãÒªÅäÖû·¾³±äÁ¿£¬ÐÞ¸ÄÈô¸É¸öϵͳÎļþ£¬²¢ÇÒÕâЩ²ÎÊý¿ÉÄܸù¾ÝÄãlinux°æ±¾µÄ²»Í¬¶øÓÐËù²»Í¬£¬Èç¹ûÅäÖò»ÕýÈ·£¬¿ÉÄܵ¼ÖÂ×îÖյݲװʧ°Ü£¬ÆäËü»¹ÓÐÄãµÄÄ¿ ......
ijÊý¾Ý¿âÖеÄÒ»ÕűíA,±íAµÄÊý¾Ý¿âÁ¿ÏÖÔÚ´ó¸ÅÓÐ10ÒÚÌõÊý¾ÝÖ®¶à.
×î³õµÄ×ö·¨ÊÇÈ«²¿´æ·ÅÔÚÒ»¸ö±í¿Õ¼äÖÐ.Ôì³ÉÏÖÔڵIJéѯËٶȹêÅÀËƵÄ.ÏÖÔÚ²»µÃ²»¶ÔÊý¾Ý¿â×ö³öÖØÐÂÆÀ¹ÀºÍÓÅ»¯.
×î³õµÄÇ°Ìá:
1.ÖÐÓ¦¸Ã½¨Á¢µÄË÷Òý¶¼ÒѾ߱¸
2.²éѯÓï¾ä¶¼ÒѾ×öµ½ÓÅ»¯:ÏÖÔÚÀàËÆÓÚ select count(1) from A Õâô¼òµ¥µÄÒ»¾äͳ¼ÆSQL¶¼ÐèÒª100S×óÓÒ
ta ......
F.1×Ö·ûº¯Êý——·µ»Ø×Ö·ûÖµ
ÕâЩº¯ÊýÈ«¶¼½ÓÊÕµÄÊÇ×Ö·û×åÀàÐ͵IJÎÊý(CHR³ýÍâ)²¢ÇÒ·µ»Ø×Ö·ûÖµ.³ýÁËÌرð˵Ã÷µÄÖ®Íâ,ÕâЩº¯Êý´ó²¿·Ö·µ»ØVARCHAR2ÀàÐ͵ÄÊýÖµ.×Ö·ûº¯ÊýµÄ·µ»ØÀàÐÍËùÊܵÄÏÞÖƺͻù±¾Êý¾Ý¿âÀàÐÍËùÊܵÄÏÞÖÆÊÇÏàͬµÄ,±ÈÈç: VARCHAR2ÊýÖµ±»ÏÞÖÆΪ2000×Ö·û(ORACLE 8ÖÐΪ4000×Ö·û),¶øCHARÊýÖµ±»ÏÞÖÆΪ255×Ö·û(Ô ......
ÔÚwindows ÏÂÅäÖÃPHPʹÓÃORACLEÊý¾Ý¿âÒªµã
ÔÚwindowÏ£¬¾³£ÓÃapache + PHP À´×öÓ¦ÓÃƽ̨£¬µ«ÊÇÈç¹ûʹÓÃoracle×öºǫ́Êý¾Ý¿â£¬µ«ÓÖûÓа²×°ÓÐoracle¿Í»§¶Ë£¬ÏÂÃæµÄÅäÖÿÉÒԲο¼
1¡¢ÔÚûÓа²×°oracleµÄ»úÆ÷ÉÏ£¬PHPÎÞ·¨¼ÓÔØphp_oci8.dllÄ£¿é£¬ÔÒòÊÇphp_oci8.dllÒÀÀµµÄÏà¹Ø×é¼þûÓÐÕÒµ½¡£
ÄãÕýÈ·ÉèÖÃÁË ......
½¨Á¢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 ......