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

SybaseÊý¾Ý¿âºÍoracleÊý¾Ý¿âÓ÷¨


1 ½«Êý¾Ý¿âTESTÍêÈ«µ¼³ö,Óû§Ãûsystem ÃÜÂëmanager µ¼³öµ½D:daochu.dmpÖÐ
    exp system/manager@TEST file=d:daochu.dmp full=y
2 ½«Êý¾Ý¿âÖÐsystemÓû§ÓësysÓû§µÄ±íµ¼³ö
    exp system/manager@TEST file=d:daochu.dmp owner=(system,sys)
3 ½«Êý¾Ý¿âÖеıíinner_notify¡¢notify_staff_relatµ¼³ö
     exp aichannel/aichannel@TESTDB2 file= d:datanewsmgnt.dmp tables=(inner_notify,notify_staff_relat)
4 ½«Êý¾Ý¿âÖеıítable1ÖеÄ×Ö¶Îfiled1ÒÔ"00"´òÍ·µÄÊý¾Ýµ¼³ö
    exp system/manager@TEST file=d:daochu.dmp tables=(table1) query=" where filed1 like '00%'"
   ÉÏÃæÊdz£Óõĵ¼³ö£¬¶ÔÓÚѹËõ£¬¼ÈÓÃwinzip°ÑdmpÎļþ¿ÉÒԺܺõÄѹËõ¡£
   Ò²¿ÉÒÔÔÚÉÏÃæÃüÁîºóÃæ ¼ÓÉÏ compress=y À´ÊµÏÖ¡£
Êý¾ÝµÄµ¼Èë
1 ½«D:daochu.dmp ÖеÄÊý¾Ýµ¼Èë TESTÊý¾Ý¿âÖС£
    imp system/manager@TEST   file=d:daochu.dmp
    imp aichannel/aichannel@HUST full=y   file=d:datanewsmgnt.dmp ignore=y
    ÉÏÃæ¿ÉÄÜÓеãÎÊÌ⣬ÒòΪÓеıíÒѾ­´æÔÚ£¬È»ºóËü¾Í±¨´í£¬¶Ô¸Ã±í¾Í²»½øÐе¼Èë¡£
    ÔÚºóÃæ¼ÓÉÏ ignore=y ¾Í¿ÉÒÔÁË¡£
2 ½«d:daochu.dmpÖеıítable1 µ¼Èë
imp system/manager@TEST   file=d:daochu.dmp   tables=(table1)
»ù±¾ÉÏÉÏÃæµÄµ¼Èëµ¼³ö¹»ÓÃÁË¡£²»ÉÙÇé¿öÒªÏÈÊǽ«±í³¹µ×ɾ³ý£¬È»ºóµ¼Èë¡£
×¢Ò⣺
²Ù×÷ÕßÒªÓÐ×ã¹»µÄȨÏÞ£¬È¨ÏÞ²»¹»Ëü»áÌáʾ¡£
Êý¾Ý¿âʱ¿ÉÒÔÁ¬Éϵġ£¿ÉÒÔÓÃtnsping TEST À´»ñµÃÊý¾Ý¿âTESTÄÜ·ñÁ¬ÉÏ¡£
¸½Â¼Ò»£º
¸øÓû§Ôö¼Óµ¼ÈëÊý¾ÝȨÏ޵IJÙ×÷
µÚÒ»,Æô¶¯sql*puls
µÚ¶þ£¬ÒÔsystem/managerµÇ½
µÚÈý£¬create user Óû§Ãû IDENTIFIED BY ÃÜÂë £¨Èç¹ûÒѾ­´´½¨¹ýÓû§£¬Õâ²½¿ÉÒÔÊ¡ÂÔ£©
µÚËÄ£¬GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
    DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
       DBA,CONNECT,RESOURCE,CREATE SESSION   TO Óû§Ãû×Ö
µÚÎå, ÔËÐÐ-cmd-½øÈëdmpÎļþËùÔÚµÄĿ¼,
       imp userid=system/manager full=y file=*.dmp
       »òÕß imp u


Ïà¹ØÎĵµ£º

Oracle expÏê½â

 µ¼Èë/µ¼³öÊÇORACLEÐÒ´æµÄ×î¹ÅÀϵÄÁ½¸öÃüÁîÐй¤¾ß£¬ÆäʵÎÒ´ÓÀ´²»ÈÏΪExp/ImpÊÇÒ»Öֺõı¸·Ý·½Ê½£¬ÕýÈ·µÄ˵·¨ÊÇExp/ImpÖ»ÄÜÊÇÒ»¸öºÃµÄת´¢¹¤¾ß£¬ÌرðÊÇÔÚСÐÍÊý¾Ý¿âµÄת´¢£¬±í¿Õ¼äµÄÇ¨ÒÆ£¬±íµÄ³éÈ¡£¬¼ì²âÂß¼­ºÍÎïÀí³åÍ»µÈÖÐÓв»Ð¡µÄ¹¦ÀÍ¡£µ±È»£¬ÎÒÃÇÒ²¿ÉÒÔ°ÑËü×÷ΪСÐÍÊý¾Ý¿âµÄÎïÀí±¸·ÝºóµÄÒ»¸öÂß¼­¸¨Öú±¸·Ý£¬Ò²ÊDz»´íµ ......

Oracle 11g SECUREFILES


Oracle Êý¾Ý¿â 11gÃæÏò DBA ºÍ¿ª·¢ÈËÔ±µÄÖØÒªÐÂÌØÐÔ:SecureFiles£º
1¡¢SecureFiles£ºÐ LOB 
Á˽âÈçºÎʹÓÃÐÂÒ»´ú LOB£ºSeureFiles¡£SecureFiles ¼¯ÍⲿÎļþºÍÊý¾Ý¿â LOB ·½·¨µÄÓŵãÓÚÒ»Éí£¬¿ÉÒÔ´æ´¢·Ç½á¹¹»¯Êý¾Ý£¬ÔÊÐí¼ÓÃÜ¡¢Ñ¹Ëõ¡¢Öظ´Ïû³ýµÈµÈ¡£ 
Êý¾Ý¿âפÁô BLOBS »ò OS Îļþ 
ÄúÔÚ Oracle Êý¾Ý¿âÖÐ ......

ÉÐѧÌÃOracle¾­Ñé

×¢: ÕâÊǸöÈË¿´OracleÊÓÆµÊ±Ð´ÏµıʼÇ, ¶àÓдíÎó, Íû¸÷λÇÐÎðÁßϧ´Í½Ì.
 
1. Dos
ϵǽ³¬¼¶¹ÜÀíÔ±
£º
 

sqlplus sys/
ÃÜÂë
as sysdba
 
2.
¸ü¸Ä¹ÜÀíÔ±
£º
alter user scott account unlock;
 
3.
Êý¾ÝµÄ±¸·Ý
.
 
A
µ¼³ö
:
Cmd
ÏÂ
:       ......

SQLProgress 1.01.34 for Oracle Only

SQLProgressÊÇÒ»¸öСÇɵIJÙ×÷Êý¾Ý¿âµÄ¹¤¾ß£¬ËùÓеİ汾¶¼²»³¬¹ý3M£¬°üÀ¨ÏÖÔÚ×îеÄ34°æ±¾¡£33ÒÔ¼°ÒÔǰµÄ°æ±¾ÐèÒª°²×°BDE²ÅÄÜÔËÐУ¬´Ó34¿ªÊ¼£¬Ö»Ö§³ÖOracleÊý¾Ý¿â£¬²ÉÓÃODAC×÷ΪÊý¾Ý¿â·ÃÎʵĽӿڣ¬Ö»ÐèÒªÒ»¸ö²»µ½3MµÄ¿ÉÖ´ÐÐÎļþ¾Í¿ÉÒÔ¶ÔÊý¾Ý¿â½øÐвÙ×÷£¬ÆäËûʲô¶¼Óð²×°¡£¸Ã°æ±¾ÊÇÔÚSQLProgress1.01.33»ù´¡ÉÏÐ޸ĵģ¬33ÊÇBD ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ