OracleÓû§¹ÜÀí
Ò»£¬OracleÊý¾Ý¿âÓû§¼ò½é
ÔÚOracleÊý¾Ý¿âÖÐÈκζÔÏó¶¼ÊôÓÚÒ»¸öÌض¨Óû§£¬»òÕß˵һ¸öÓû§ÓëͬÃûµÄģʽÏà¹ØÁª¡£
ÒªÁ¬½Óµ½OracleÊý¾Ý¿âÐèÒªÒ»¸öÓû§ÕÊ»§£¬¸ù¾ÝÐèÒªÊÚÓèµÄ²Ù×÷ȨÏÞ¡£
1£¬Ä¬ÈÏÊý¾Ý¿âÓû§Ä£Ê½£º
Sys:Êý¾Ý¿â×ֵ䣨´æ´¢±»¹ÜÀí¶ÔÏóËùÓÐÐÅÏ¢£©ºÍÊÓͼ´æ´¢ÔÚ¸ÃģʽÖС£ÏµÍ³¼¶Óû§¡£
System:ĬÈÏϵͳ¹ÜÀíÔ±£¨DBAȨÏÞ£©Óû§¡£ÏµÍ³¼¶Óû§¡£
Scott:Êý¾Ý¿âʾ·¶Óû§£¬Ä¬ÈÏ¿ÚÁîtiger¡£²»Í¬°æ±¾²»Í¬¡£
2£¬Ê²Ã´ÊÇȨÏÞ£¿
¹ÜÀíÓû§¶ÔÊý¾Ý¿â¶¨Ò壨DDL£©ºÍ·ÃÎÊÊý¾Ý¿â£¨DML£©µÄ²Ù×÷¡£
¢ÙϵͳȨÏÞ£º¹ÜÀíÊý¾Ý¿â²Ù×÷DDL£¬½øÐÐϵͳ¼¶»î¶¯µÄÄÜÁ¦¡£
¢Ú¶ÔÏóȨÏÞ£º¹ÜÀí¶ÔÏó½øÐвÙ×÷DML¡£
3£¬Ê²Ã´ÊǽÇÉ«£¿
¢Ù¹ÜÀíÓû§¶ÔÊý¾Ý¿â½øÐв»Í¬¼¶±ðµÄ·ÃÎÊ¡£
¢Ú½ÇÉ«ÊÇÒ»×éȨÏ޵ļ¯ºÏ£¬½«½ÇÉ«¸³¸øÒ»¸öÓû§£¬Õâ¸öÓû§¾ÍÓµÓÐÁËÕâ¸ö½ÇÉ«ÖеÄËùÓÐȨÏÞ¡£
Ö»ÒªµÚÒ»´Î½«½ÇÉ«¸³¸øÕâÒ»×éÓû§£¬½ÓÏÂÀ´¾ÍÖ»ÒªÕë¶Ô½ÇÉ«½øÐйÜÀí¾Í¿ÉÒÔÁË¡£
¶þ£¬Óû§Óë±í¿Õ¼äµÄ¹Øϵ
1£¬Ã¿¸öÓû§¶¼ÓÐÒ»¸öĬÈϱí¿Õ¼ä£¨Ä¬ÈÏΪSystem£©ºÍÒ»¸öÁÙʱ±í¿Õ¼ä£¨Ä¬ÈÏΪTemp£©;
2£¬±í¿Õ¼ä×÷ÓÃ;
¢Ù.¾ö¶¨Êý¾Ý¿âʵÌåµÄ¿Õ¼ä·ÖÅä;
¢Ú.ÉèÖÃÊý¾Ý¿âÓû§µÄ¿Õ¼ä·Ý¶î;
¢Û.¿ØÖÆÊý¾Ý¿â²¿·ÖÊý¾ÝµÄ¿ÉÓÃÐÔ;
¢Ü.·Ö²¼Êý¾ÝÓÚ²»Í¬µÄÉ豸֮¼äÒÔ¸ÄÉÆÐÔÄÜ;
3£¬´´½¨±í¿Õ¼ä(TableSpace)
Óï·¨¸ñʽ:
CREATE TABLESPACE ±í¿Õ¼äÃû
DATAFILE Îļþ±êʶ·û [,Îļþ±êʶ·û]
[SIZEÕûÊý [K\M] ]
[AUTOEXTEND] [ON | OFF]
;
ÆäÖÐ:Îļþ±êʶ·û=’ÎļþÃû’
Àý×Ó£º
Create TableSpace ts5_11
DataFile ‘E:\OracleTableSpace\05_11\ts1.DBF’, ‘E:\OracleTableSpace\05_11\ts2.DBF'
Size 10M;
4£¬Ð޸ıí¿Õ¼äÅäÖÃ
Óï·¨¸ñʽ:
ALTER TABLESPCE ±í¿Õ¼äÃû
(ADD DATAFILE Îļþ±êʶ·û[,Îļþ±êʶ·û]
| RENAME DATAFILE ’ÎļþÃû’[,’ÎļþÃû’]
TO ’ÎļþÃû’[,’ÎļþÃû’]
);
Èý£¬Óû§µÄ´´½¨ºÍ¹ÜÀí
1£¬´´½¨Êý¾Ý¿âÓû§£¨User£©
Óï·¨¸ñʽ:
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
oracle10g´´½¨Óû§
Oracle10g µÄ´´½¨Óû§Ãû
1¡¢ linux Ï oracle µÄÆô¶¯
ÒÔ oracle Éí·ÝµÇ¼
Æô¶¯ lsnrctl start
怬 sqplus /nolog
Á¬½ÓÊý¾Ý¿â connect /as sysdba
Æô¶¯Êý¾Ý¿â startup
¹Ø±ÕÊý¾Ý¿â s ......
ÏÞÖÆË÷ÒýÊÇһЩûÓоÑéµÄ¿ª·¢ÈËÔ±¾³£·¸µÄ´íÎóÖ®Ò»¡£ÔÚSQLÖÐÓкܶàÏÝÚå»áʹһЩË÷ÒýÎÞ·¨Ê¹Óá£ÏÂÃæÌÖÂÛһЩ³£¼ûµÄÎÊÌ⣺
1 ʹÓò»µÈÓÚ²Ù×÷·û(<>¡¢!=)
ÏÂÃæµÄ²éѯ¼´Ê¹ÔÚcust_ratingÁÐÓÐÒ»¸öË÷Òý£¬²éѯÓï¾äÈÔȻִÐÐÒ»´ÎÈ«±íɨÃè¡£
  ......
Èç¹ûweb·½Ê½µÄem£¬isqlplus·ÃÎʲ»ÁË¡£
1. ¼ì²éÖ÷»úÃû/IP¡¢¶Ë¿ÚÊÇ·ñÕýÈ·
°²×°Ê±µÄÖ÷»úÃû/IP¡¢¶Ë¿Ú¼Ç¼ÔÚ$ORACLE_HOME/install/portlist.ini ÎļþÖС£
ȱʡÊÇ£º
Ò»°ãÓû§ http://ip:5560/isqlplus
DBAÓû§ &nb ......
¡¾IT168¼¼ÊõÎĵµ¡¿
DATA GUARDµÄ×îÖ÷ÒªµÄ¹¦ÄÜÊÇÈßÔÖ¡£µ±È»¸ù¾ÝÅäÖõIJ»Í¬£¬DATA GUARD»¹¿ÉÒԾ߱¸ÒÔÏÂÌص㣺¸ß¿ÉÓá¢ÐÔÄÜÌáÉý¡¢Êý¾Ý±£»¤ÒÔ¼°¹ÊÕϻָ´µÈ¡£
DATA GUARD¿ÉÒÔ·ÖΪÎïÀíSTANDBYºÍÂß¼STANDBYÁ½ÖÖ¡£¶þÕßµÄ×î´ó²î±ðÔÚÓÚ£¬ÎïÀíSTANDBYÓ¦ÓõÄÊÇÖ÷¿âµÄ¹éµµÈÕÖ¾£¬¶ø ......