ORACLE 10.204ÃÜÂëÖØÊÔ´ÎÊýÎÊÌâ
ORACLE 10.204ÃÜÂëÖØÊÔ´ÎÊýÎÊÌâ
ORACLE 10.204ÃÜÂëÖØÊÔ´ÎÊýÎÊÌâ
ORACLE 10.204²¹¶¡ÔöÇ¿ÁËϵͳµÄ°²È«ÐÔ£¬È±Ê¡µÄÃÜÂëÖØÊÔ´ÎÊý¸ÄΪÁË10´Î£¬ÕâÔںܶàÇé¿öÏ£¬»áµ¼ÖÂһЩ¿Í»§±»Ëø¶¨£¬Èç¹ûÏëÐÞ¸ÄÃÜÂëÖØÊÔ´ÎÊý£¬¿ÉÒÔÐÞ¸ÄÏìÓ¦µÄ¸ÅÒªÎļþ£¬Èç¹ûûÓд´½¨Óû§¸ÅÒªÎļþ£¬È±Ê¡µÄ¾ÍÊÇÓÃoracleµÄ¸ÅÒªÎļþ£¬ÐÞ¸ÄÕâ¸ö¸ÅÒªÎļþµÄÖØÊÔ´ÎÊý¾Í¿ÉÒÔÁËÁË¡£
ALTER PROFILE "DEFAULT" LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
1.oracleÉèÖò»Í¬È¨ÏÞµÄÓû§È¥·ÃÎÊͬһ±í¿Õ¼ä
1.create user testa identified by testa;
2.alter user testa default tablespace users temporary tablespace temp;
3.grant connect to testa;
4.grant select any table to testa;
2.ORACLEÖÐÉèÖÃͬһ¸öÓû§¶ÔÁ½¸ö±í¿Õ¼äµÄȨÏ޵ĴúÂë
alter user Óû§ quota unlimi ......
ÔÚdb2ºÍoracleÖеĶÔÊ÷µÄµÝ¹é²éѯÓï¾ä¡£
±í½á¹¹£º
create table MAIN_NODE (
MLA_ID INTEGER not null , //½ÚµãID
MLA_ROOTID &nb ......
High Water Mask£¨×î¸ßˮλÏߣ¬ºÇºÇ£©ÒÔϼò³ÆHWM
deleteÃüÁî²»Ó°Ïì±í×ÔÉíµÄHWM£¬¼´±íÖеÄÇø¿é»áËæ×ÅÊý¾ÝÁ¿µÄÔö´ó¶øÔö´ó£¬µ«É¾³ýÊý¾Ýʱ£¬
Çø¿é²¢²»»á¼õÉÙ£¬µ±²éѯʱ£¬»á°´ÕÕHWMµÄ±ê׼ȥɨÃè±í£¬¼´Ê¹Ê¹ÓÃdelete½«±íÊý¾ÝÇå¿Õ£¬²éѯʱ£¬
ÒÀ¾É»áɨÃèHWMµÄÇø¿é£¬²éѯËÙ¶ÈÒ²¾ÍºÍûʹÓÃdeleteÃüÁî֮ǰÊÇÒ»ÑùµÄ£¬¶øtruncate¿ÉÒÔ½ ......