Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

OracleÖÐʹÓÃIMP DosÃüÁî µ¼ÈëDICÊý¾Ý¿â±¸·Ý¹ý³Ì

OracleÖÐʹÓÃIMP DosÃüÁî µ¼ÈëDICÊý¾Ý¿â±¸·Ý¹ý³Ì
 
1.ʹÓþßÓн¨Á¢±í¿Õ¼äºÍÓû§È¨ÏÞµÄÓû§µÇ¼Oracle£»
2.½¨Á¢ÐèÒªµÄ±í¿Õ¼ä£»
3.½¨Á¢ÐèÒªµÄÓû§£¨Óû§Ãû£¬ÃÜÂ룬ĬÈϱí¿Õ¼ä£¬ÁÙʱ±í¿Õ¼ä£¬È¨ÏÞ£©
4.´ò¿ªDOS´°¿Ú£¬ÔÚÃüÁîÐÐÖÐÊäÈëIMP£»
5.ÓõÚÈý²½Öн¨Á¢ºÃµÄÓû§µÇ¼Êý¾Ý¿â£»
6.ÊäÈëDICÎļþµÄÍêȫ·¾¶£¬°´ÕÕÌáʾѡÔñ£¬¼´¿Éµ¼Èë¡£
 


Ïà¹ØÎĵµ£º

OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨11£©£º±£»¤OracleÊý¾Ý¿âµÄ°²È«£¨1£©

1¡¢µ÷ÕûĬÈϵݲȫÉèÖÃ
1.1¡¢Ä¬ÈϵÄÓû§
²é¿´Êý¾Ý¿âµÄÓû§ºÍ״̬£¬¿ÉÒÔ²éѯDBA_USERSÊÓͼ¡£
?[Copy to clipboard]View Code SQL
SQL> select username,account_status from dba_users;
1.2¡¢PUBLICȨÏÞ
OracleÖдæÔÚÒ»¸öÃûΪPUBLICµÄαÓû§¡£Ö»ÒªÓÃPUBLICÊÚÓèij¸öȨÏÞ£¬ÄÇôËùÓÐÓû§¶¼»á±»ÊÚÓèÕâ¸öȨÏÞ¡£
?[Copy ......

Oracle±¸·ÝµÄ·ÖÀà

OracleÊý¾Ý¿âµÄ±¸·Ý·ÖΪһÖÂÐԺͷÇÒ»ÖÂÐÔÁ½ÖÖ¡£
Ò»ÖÂÐÔ±¸·Ý£¬¾ÍÊÇÊý¾Ý¿âÔڹرյÄ״̬Ï»òÕßmount״̬ϽøÐеı¸·Ý¡£ÕâʱºòÓÉÓÚÊý¾Ý¿âûÓдò¿ª£¬Ã»ÓÐÊý¾Ý´¦Àí·¢Éú£¬¿ØÖÆÎļþ¡¢Êý¾ÝÎļþºÍÈÕÖ¾ÎļþÖеÄscn±£³ÖÒ»Ö¡£ËùÒÔ³ÉΪһÖÂÐÔ±¸·Ý¡£
²»Ò»ÖÂÐÔ±¸·Ý£¬¾ÍÊÇÊý¾Ý¿âÔÚopen״̬ϽøÐеı¸·Ý£¬ÕâʱºòÓÉÓÚÊý¾ÝÎļþºÍ¿ØÖÆÎļþÒÔ¼° ......

WIN7ÏÂÔõÑù×°Oracle 10g

      
WIN7µÄϵͳ½çÃæºÜƯÁÁ£¬Ê¹ÓÃÆðÀ´È·ÊµºÜ²»´í£¬¿ÉÊÇÈ´Ò²¸øÎÒµÄѧϰ´øÀ´¹ý²»ÉÙÂé·³¡£ÓÈÆäÊÇÕâ´Î×°Oracle£¬±ðÈËÓõÄÊÇXPµÄϵͳºÜÈÝÒ×¾Í×°ÉÏÁ˵ģ¬¿ÉÊÇÎÒÈ´ÔõôҲװ²»ÉÏ¡£ÎªÁËÈÃͬÑùϲ°®WIN7µÄÅóÓÑÉÙ×ßЩÍä·£¬ÏÂÃæ¾Í½éÉÜÒ»ÏÂÔÚwin7Éϰ²×°Oracle10gµÄ·½·¨°É£¬ÄÇ¿ÉÊDZ¾ÈËÓÃÁË8Ììʱ¼ä£¬²»Í ......

linux»·¾³Ï°²×°oracle 11g database·½·¨Ö¸µ¼(¶þ)

±¸×¢£º
    ±¾²©ÄÚÈÝÊdzнÓÉÏÆÚÄÚÈݵÄÑÓÐø£¬ÓÉÓÚÄÚÈݹý³¤£¬Òò´Ë²ÉÓ÷ֶÎ˵Ã÷£¬ÒÔÃâ´ó¼Ò¿´ÆðÀ´Æ£¾ë£¬ÈôÁ˽â¸ü¶àÏêϸµÄ°²×°Á÷³Ì£¬Çë¼ÌÐø¹Ø×¢±¾²©¡£²ÎÕÕÔ­°æ°²×°ÊÖ²á¶ÔÕÕ°²×°¡£
4£®Configure Oracle Installation Owner Shell Limits
<1>ÅäÖÃlimits.confÎļþ£¬ºìÉ«±êעΪÔö¼ÓµÄÅäÖÃÄÚÈÝ¡£
[root@myli ......

oracleЭÒéÊÊÅäÆ÷´íÎóÊÇʲôԭÒò×ܽá

Ôì³ÉORA-12560: TNS: ЭÒéÊÊÅäÆ÷´íÎóµÄÎÊÌâµÄÔ­ÒòÓÐÈý¸ö£º
1.¼àÌý·þÎñûÓÐÆðÆðÀ´¡£windowsƽ̨¸öÒ»ÈçϲÙ×÷£º¿ªÊ¼---³ÌÐò---¹ÜÀí¹¤¾ß---·þÎñ£¬´ò¿ª·þÎñÃæ°å,Æô¶¯oraclehome92TNSlistener·þÎñ¡£
2.database instanceûÓÐÆðÆðÀ´¡£windowsƽ̨ÈçϲÙ×÷£º¿ªÊ¼---³ÌÐò---¹ÜÀí¹¤¾ß---·þÎñ£¬´ò¿ª·þÎñÃæ°å£¬Æô¶¯oracleserviceXXXX ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ