¡¾×ª¡¿ORACLEÓû§Á¬½ÓµÄ¹ÜÀí
ÓÃϵͳ¹ÜÀíÔ±£¬²é¿´µ±Ç°Êý¾Ý¿âÓм¸¸öÓû§Á¬½Ó£º
SQL> select username,sid,serial# from v$session;
Èç¹ûҪͣij¸öÁ¬½ÓÓÃ
SQL> alter system kill session 'sid,serial#';
Èç¹ûÕâÃüÁî²»ÐÐ,ÕÒËüUNIXµÄ½ø³ÌÊý
SQL> select pro.spid from v$session ses,v$process pro where ses.sid=21 and ses.paddr=pro.addr;
˵Ã÷£º21ÊÇij¸öÁ¬½ÓµÄsidÊý
È»ºóÓà kill ÃüÁîɱ´Ë½ø³ÌºÅ¡£
Îå¡¢SQL*PLUSʹÓÃ
a¡¢½üÈëSQL*Plus
$sqlplus Óû§Ãû/ÃÜÂë
Í˳öSQL*Plus
SQL>exit
b¡¢ÔÚsqlplusϵõ½°ïÖúÐÅÏ¢
ÁгöÈ«²¿SQLÃüÁîºÍSQL*PlusÃüÁî
SQL>help
Áгöij¸öÌض¨µÄÃüÁîµÄÐÅÏ¢
SQL>help ÃüÁîÃû
c¡¢ÏÔʾ±í½á¹¹ÃüÁîDESCRIBE
SQL>DESC ±íÃû
d¡¢SQL*PlusÖеıà¼ÃüÁî
ÏÔʾSQL»º³åÇøÃüÁî
SQL>L
ÐÞ¸ÄSQLÃüÁî
Ê×ÏÈÒª½«´ý¸ÄÕýÐбäΪµ±Ç°ÐÐ
SQL>n
ÓÃCHANGEÃüÁîÐÞ¸ÄÄÚÈÝ
SQL>c/¾É/ÐÂ
ÖØÐÂÈ·ÈÏÊÇ·ñÒÑÕýÈ·
SQL>L
ʹÓÃINPUTÃüÁî¿ÉÒÔÔÚSQL»º³åÇøÖÐÔö¼ÓÒ»Ðлò¶àÐÐ
SQL>i
SQL>ÊäÈëÄÚÈÝ
e¡¢µ÷ÓÃÍⲿϵͳ±à¼Æ÷
SQL>edit ÎļþÃû
¿ÉÒÔʹÓÃDEFINEÃüÁîÉèÖÃϵͳ±äÁ¿EDITORÀ´¸Ä±äÎı¾±à¼Æ÷µÄÀàÐÍ£¬ÔÚlogin.sqlÎļþÖж¨ÒåÈçÏÂÒ»ÐÐ
DEFINE_EDITOR=vi
f¡¢ÔËÐÐÃüÁîÎļþ
SQL>START test
SQL>@test
³
Ïà¹ØÎĵµ£º
¸ü¸Ä±íµÄ½á¹¹
1.±à¼±íµÄ×Ö¶Î
ÐÞ¸ÄÒ»¸öÁеÄÊý¾ÝÀàÐÍ(Ò»°ãÏÞÓÚÐ޸ij¤¶È£¬ÐÞ¸ÄΪһ¸ö²»Í¬ÀàÐÍʱÓÐÖî¶àÏÞÖÆ):
Óï·¨:
ALTER TABLE ±íÃû MODIFY(ÁÐÃû Êý¾ÝÀàÐÍ);
eg1:
alter table skate_test modify (author number(10,0) )
ÔÚÐÞ¸ÄÁеij¤¶Èʱºò,Ö»Äܱ ......
ÖØ×öÈÕÖ¾ÎļþÊÇOracleÊý¾Ý¿âÖÐÒ»Öַdz£ÖØÒªµÄÈÕÖ¾Îļþ£¬Ò²ÊÇÆäÒ»¸öºÜÓÐÌØÉ«µÄ¹¦ÄÜ¡£ÖØ×öÈÕÖ¾Îļþ»á¼Í¼¶ÔÓÚÊý¾Ý¿âµÄÈκβÙ×÷£¬ÈçÀûÓÃDMLÓï¾ä»òÕßDDLÓï¾ä¶ÔÊý¾Ý½øÐиü¸Ä£¬»òÕßÊý¾Ý¿â¹ÜÀíÔ±¶ÔÊý¾Ý¿â½á¹¹½øÐиü¸Ä£¬¶¼»áÔÚÖØ×öÈÕÖ¾ÖнøÐмǼ¡£
¡¡¡¡¿É¼û£¬µ±Êý¾Ý±»ÒâÍâµÄɾ³ý»òÕßÐ޸ģ¬ÎÒÃÇ¿ÉÒÔÀûÓÃÖØÐÂÈÕÖ¾Îļþ½øÐлָ´; µ±³ö ......
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¡¡¡¡¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ¼ÆËã»úÒÔÆäÇ¿´óµÄËٶȴ¦ÀíÄÜÁ¦£¬È¡´úÁ˺ܶàÈËΪµÄ¹¤×÷£¬µ«ÊÇ£¬ÍùÍùºÜ¶àʱºò£¬ËüÓÖÊÇÄÇôÈõ²»½û·ç£¬Ö÷°åÉϵÄоƬ¡¢Ö÷°åµç·¡¢ÄÚ´æ¡¢µçÔ´µÈÈκÎÒ»Ïî²»ÄÜÕý³£¹¤×÷£¬¶¼»áµ¼Ö¼ÆËã»úϵͳ²»ÄÜÕý³£¹¤×÷¡£µ±È»£¬ÕâЩË𻵿ÉÒÔÐÞ¸´£¬²»»áµ¼ÖÂÓ¦Óú ......
OS :RHEL AS 4 oracle 10g
0±¸·Ý½Å±¾
#!/bin/bash
# incremental level 0 backup script
source /home/oracle/.bash_profile
current_day=`date +%Y%m%d`
mkdir /home/ora ......
1.Êý¾Ý¿â¹éµµÄ£Ê½:
* ·Ç¹éµµÄ£Ê½:µ±Êý¾Ý¿âÊý¾ÝÖ»¶Á²»»á¸Ä±äʱ,Êý¾Ý²»»á¸Ä±ä,Êý¾Ý¿âÊʺÏÓ÷ǹ鵵ģʽ, ÕâÑùÌá¸ßÐÔÄÜ
&nb ......