ÔÚORACLE 10gµÇ½´´½¨ÐÂÓû§
ÔÚORACLE 10gµÇ½´´½¨ÐÂÓû§£º
ÔÚORACLE 10gµÇ½´´½¨ÐÂÓû§£º
1¡¢ÓÃsys Óû§µÇ¼
2¡¢create user test1 identified by test123;
3¡¢grant connect,resource to test1;
ÓÃtest1µÇ½£º sqlplus test1/test123
°²×°ÍêÁËOracleÊý¾Ý¿â£¬ÍüÁËÔÚ¿ÚÁî¹ÜÀíÖиøSCOTT½âËøÔõô°ì
ÎÊÌâ²¹³ä£º
ÔËÐÐcmdsqlplus/nolog »Ø³µ
SQL>conn/as sysdba »Ø³µ
SQL>alter user scott account unlock; »Ø³µ
SQL>disconnect »Ø³µSQL>conn scott/tiger@oral; »Ø³µ
È»ºóÊäÈëÁ½´Îж¨ÒåµÄ¿ÚÁî·Ö±ð»Ø³µÈ·Èϼ´¿É
Ïà¹ØÎĵµ£º
1.Ê×ÏȽ«Òªµ¼ÈëµÄÊý¾ÝÉú³ÉexcelÎļþ¸ñʽ£¬×îÇ°Ãæ¿ÕÒ»¸ñ¡£
2.ÓÃPL/SQLÁ¬½ÓÒªµ¼ÈëµÄÊý¾Ý¿â£¬ÊäÈëÓï¾ä select * from ±íÃû for update
3.µã»÷СËø£¨±à¼Êý¾Ý£©£¬Ñ¡ÖÐÒ»Ðн«excel¸´ÖÆÊý¾ÝÕ³Ìùµ½±íÖÐ
ÒÔinformixÊý¾Ýµ¼³öΪÀý£¬Ê×ÏÈʹÓÃSecureCRT¹¤¾ß½øÈëÖնˡ£ÊäÈëÃüÁîdbaccessºóÖ´ÐУ¬Ñ¡ÖÐÊý¾Ý¿âNEWÒ»ÏÂSQLÓï¾äÊäÈëÃüÁunl ......
Õâ¶Îʱ¼ä£¬½ÓµÄ¶àÊÇRACµÄά»¤ºÍ»Ö¸´ÎÊÌâ¡£ËùÒÔÿÌ춼ÊÇÔÚºÍRAC´ò½»µÀ¡£
RACÕæµÄºÜºÃÍæ¡£
´ó¼ÒÓжÔRAC¸ÐÐËȤµÄÓÐÎÊÌâµÄ£¬»òÕßÊÇÓöµ½RACά»¤ÉÏÃæµÄ³öÏÖÎÊÌâµÄ£¬¿ÉÒÔ·¢ÓʼþÖÁinthirties@gmail.comÒ»Æð½»Á÷Ñо¿¡£
ÕæµÄºÜÏ£ÍûÍæOracle ......
OracleÖеÄSQLÔÚÖ´ÐÐ֮ǰ½øÐнâÎö£¬Ò»¸öÓ²½âÎö°üÀ¨ÏÂÃæµÄ²½Ö裺
¼ÓÔص½¹²Ïí³ØÖÐ - SQLÔ´´úÂë±»¼ÓÔص½ÄÚ´æÖС£
Óï·¨½âÎö - Oracle¼ì²éÓ﷨ƴд´íÎó¡£
ÓïÒå½âÎö - OracleÑéÖ¤À´×ÔÊý¾Ý×ÖµäµÄËùÓбíÃûºÍÁÐÃû²¢ÇÒÑéÖ¤ÄãÊÇ·ñÓÐȨ·ÃÎÊÕâЩÊý¾Ý¡£
²éѯת»» - Èç¹ûÔÊÐí(query_rewrite=true)£¬oracle½«°Ñ¸´ÔÓµÄSQLת»»ÎªµÈ¼ÛµÄ¼òµ ......
nocatalog·½Ê½¾ÍÊÇÓÃcontrol file×÷Ϊcatalog£¬Ã¿Ò»´Î±¸·Ý¶¼ÒªÍù¿ØÖÆÎļþÀïÃæдºÃ¶à±¸·ÝÐÅÏ¢£¬¿ØÖÆÎļþÀïÃæ»áÓÐÔ½À´Ô½¶àµÄ±¸·ÝÐÅÏ¢£¬¼´RMANµÄ±¸·ÝÐÅϢдÔÚ±¾µØ¿ØÖÆÎļþÀïÃæ¡£
ÈôΪcatalogÔò±ØÐëÒªÊ×ÏÈÒª´´½¨Ä¿Â¼±¸·ÝÊý¾Ý¿â£¬½¨Á¢»Ö¸´Ä¿Â¼£¬¼´Êý¾Ý¿âµÄ±¸·ÝÐÅϢдµ½»Ö¸´Ä¿Â¼ÀïÃæ¡£
µ±Í¨¹ýrman nocatalog·½Ê½±¸·ÝOracleÊý¾Ý¿ ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´ÐУ¬
......