OracleÉ󼯹¦ÄÜ
OracleÉ󼯹¦ÄÜ
Éó¼ÆÊǶÔÑ¡¶¨µÄÓû§¶¯×÷µÄ¼à¿ØºÍ¼Ç¼£¬Í¨³£ÓÃÓÚ£º
u Éó²é¿ÉÒɵĻ¡£ÀýÈ磺Êý¾Ý±»·ÇÊÚȨÓû§Ëùɾ³ý£¬´Ëʱ°²È«¹ÜÀíÔ±¿É¾ö¶¨¶Ô¸Ã Êý¾Ý¿âµÄËùÓÐÁ¬½Ó½øÐÐÉ󼯣¬ÒÔ¼°¶ÔÊý¾Ý¿âµÄËùÓбíµÄ³É¹¦µØ»ò²»³É¹¦µØÉ¾³ý½øÐÐÉ󼯡£
u ¼àÊÓºÍÊÕ¼¯¹ØÓÚÖ¸¶¨Êý¾Ý¿â»î¶¯µÄÊý¾Ý¡£ÀýÈ磺DBA¿ÉÊÕ¼¯ÄÄЩ±»Ð޸ġ¢Ö´ÐÐÁ˶àÉÙ´ÎÂß¼µÄI/OµÈͳ¼ÆÊý¾Ý¡£
ORACLEÖ§³ÖÈýÖÖÉó¼ÆÀàÐÍ£º
u Óï¾äÉ󼯣¬¶ÔijÖÖÀàÐ͵ÄSQLÓï¾äÉ󼯣¬²»Ö¸¶¨½á¹¹»ò¶ÔÏó¡£
u ÌØÈ¨É󼯣¬¶ÔÖ´ÐÐÏàÓ¦¶¯×÷µÄÏµÍ³ÌØÈ¨µÄʹÓÃÉ󼯡£
u ¶ÔÏóÉ󼯣¬¶ÔÒ»ÌØÊâģʽ¶ÔÏóÉϵÄÖ¸¶¨Óï¾äµÄÉ󼯡£
ORACLEËùÔÊÐíµÄÉó¼ÆÑ¡ÔñÏÞÓÚÏÂÁз½Ã棺
u Éó¼ÆÓï¾äµÄ³É¹¦Ö´ÐС¢²»³É¹¦Ö´ÐУ¬»òÕ߯äÁ½Õß¡£
u ¶ÔÿһÓû§»á»°Éó¼ÆÓï¾äÖ´ÐÐÒ»´Î»òÕß¶ÔÓï¾äÿ´ÎÖ´ÐÐÉó¼ÆÒ»´Î¡£
u ¶ÔÈ«²¿Óû§»òÖ¸¶¨Óû§µÄ»î¶¯µÄÉ󼯡£
µ±Êý¾Ý¿âµÄÉó¼ÆÊÇʹÄܵģ¬ÔÚÓï¾äÖ´Ðн׶βúÉúÉ󼯼Ǽ¡£É󼯼Ǽ°üº¬ÓÐÉ󼯵IJÙ×÷¡¢Óû§Ö´ÐеIJÙ×÷¡¢²Ù×÷µÄÈÕÆÚºÍʱ¼äµÈÐÅÏ¢¡£É󼯼Ǽ¿É´æÔÚÊý¾Ý×Öµä±í£¨³ÆÎªÉ󼯼Ǽ£©»ò²Ù×÷ϵͳÉ󼯼ǼÖС£Êý¾Ý¿âÉ󼯼ǼÊÇÔÚSYSģʽµÄAUD$±íÖС£
ÉèÖÃORACLEÉó¼Æ
ÏÂÁв½Öè¿ÉÒÔÉèÖÃORACLEµÄÉ󼯹¦ÄÜ£º
1. Ð޸IJÎÊýÎļþ£¨init<sid>.ora£¬Èç¹ûʹÓ÷þÎñÆ÷²ÎÊýÎļþʹÓÃalter system set <parameter>=<value> scope=spfile|both£¬ÏêÇé²ÎÕÕ1.1½ÚÖйØÓÚ²ÎÊýÎļþµÄ½éÉÜ£©£¬ÉèÖà AUDIT_TRAIL²ÎÊý£¬²¢ÇÒÖØÆôÊý¾Ý¿â¡£AUDIT_TRAILµÄȡֵÈçÏ£º
l DB/TRUE£ºÆô¶¯É󼯹¦ÄÜ£¬²¢ÇÒ°ÑÉ󼯽á¹û´æ·ÅÔÚÊý¾Ý¿âµÄ SYS.AUD$ ±íÖÐ
l OS£ºÆô¶¯É󼯹¦ÄÜ£¬²¢°ÑÉ󼯽á¹û´æ·ÅÔÚ²Ù×÷ϵͳµÄÉó¼ÆÐÅÏ¢ÖÐ
l DB_EXTENDED£º¾ßÓÐDB/TRUEµÄ¹¦ÄÜ£¬ÁíÍâÌîдAUD$µÄSQLBINDºÍSQLTEXT×Ö¶Î
l &n
Ïà¹ØÎĵµ£º
/*============´´½¨Customer±í==========*/
create table Customer
(
Customer_id number(6) not null,
Customer_name varchar2(50) not null,
Password varcha ......
ÔÚOracle 9iÖпÉÒÔ·½±ãµÄ°ÑÊý¾Ýµ¼³öΪÎļþ£¬»òÕß´ÓÎļþµ¼È롣ͨ¹ýOracleµÄÖÎÀí·þÎñÆ÷£¨Oracle Management Server£¬OMS£©¿ÉÒÔ·½±ãµÄʵÏÖ£¬Õû¸ö²Ù×÷¹ý³ÌÖÐÓÐºÜ¶àµØ·½ÐèÒª½âÊÍ˵Ã÷£¬µ«ÊÇÍêÕûµÄÖ¸µ¼×ÊÁϲ»¶à¡£¸÷´óÂÛ̳ÉϺܶàËùνµÄ¸ßÊÖ£¬¶Ô¸ÃÖ÷ÌâµÄ»Ø´ðÍùÍùÊÇ£¬¸ßÊÖÊDz»ÓÃOMSµÄ£¬ÓÃeXP/impl°É¡£¼ÙÈçÄãÖ´Òâ×·ÎÊ£¬Ëû¶à°ë»á¸æËßÄ㣠......
oracle
ÖеĽÇÉ«
Ò»¡¢ºÎΪ½ÇÉ«£¿
¡¡¡¡ÎÒÔÚÇ°ÃæµÄƪ·ùÖÐ˵Ã÷ȨÏÞºÍÓû§¡£ÂýÂýµÄÔÚʹÓÃÖÐÄã»á·¢ÏÖÒ»¸öÎÊÌ⣺Èç¹ûÓÐÒ»×éÈË£¬
ËûÃǵÄËùÐèµÄȨÏÞÊÇÒ»ÑùµÄ£¬µ±¶ÔËûÃǵÄȨÏÞ½øÐйÜÀíµÄʱºò»áºÜ²»·½±ã¡£ÒòΪÄãÒª¶ÔÕâ×éÖеÄÿ¸öÓû§µÄȨÏÞ¶¼½øÐйÜÀí¡£
¡¡¡¡ÓÐÒ»¸öºÜºÃµÄ½â¾ö°ì·¨¾Í
ÊÇ£º½ÇÉ«¡£½ÇÉ«ÊÇÒ»×éȨÏ޵ļ¯ºÏ£¬½«½ÇÉ«¸³ ......
ÕâÆªÎÄÕ²ûÊöÁËÈçºÎ¹ÜÀíoracle ERPµÄinterface±í
ÕâÆªÎÄÕ²ûÊöÁËÈçºÎ¹ÜÀíoracle ERPµÄinterface±í
http://blog.oraclecontractors.com/?p=212
There are a number of tables used by Oracle Applications that should have no rows in them when all is running well, and if any, only a few rows that are in error. ......
ORACLEÈÕÆÚʱ¼äº¯Êý´óÈ«
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02 13:45:25ΪÀý)
Year:
yy two digits Á½Î»Äê &nb ......