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/ImpÊÇÒ»Öֺõı¸·Ý·½Ê½£¬ÕýÈ·µÄ˵·¨ÊÇExp/ImpÖ»ÄÜÊÇÒ»¸öºÃµÄת´¢¹¤¾ß£¬ÌرðÊÇÔÚСÐÍÊý¾Ý¿âµÄת´¢£¬±í¿Õ¼äµÄÇ¨ÒÆ£¬±íµÄ³éÈ¡£¬¼ì²âÂß¼ºÍÎïÀí³åÍ»µÈÖÐÓв»Ð¡µÄ¹¦ÀÍ¡£µ±È»£¬ÎÒÃÇÒ²¿ÉÒÔ°ÑËü×÷ΪСÐÍÊý¾Ý¿âµÄÎïÀí±¸·ÝºóµÄÒ»¸öÂß¼¸¨Öú±¸·Ý£¬Ò²ÊDz»´íµ ......
Oracle Êý¾Ý¿â 11gÃæÏò DBA ºÍ¿ª·¢ÈËÔ±µÄÖØÒªÐÂÌØÐÔ:SecureFiles£º
1¡¢SecureFiles£ºÐ LOB
Á˽âÈçºÎʹÓÃÐÂÒ»´ú LOB£ºSeureFiles¡£SecureFiles ¼¯ÍⲿÎļþºÍÊý¾Ý¿â LOB ·½·¨µÄÓŵãÓÚÒ»Éí£¬¿ÉÒÔ´æ´¢·Ç½á¹¹»¯Êý¾Ý£¬ÔÊÐí¼ÓÃÜ¡¢Ñ¹Ëõ¡¢Öظ´Ïû³ýµÈµÈ¡£
Êý¾Ý¿âפÁô BLOBS »ò OS Îļþ
ÄúÔÚ Oracle Êý¾Ý¿âÖÐ ......
Oracle ×Ö¶ÎÀàÐÍ
×Ö¶ÎÀàÐÍ
ÃèÊö
×ֶγ¤¶È¼°Æäȱʡֵ
CHAR (size )
ÓÃÓÚ±£´æ¶¨³¤(size)×Ö½ÚµÄ×Ö·û´®Êý¾Ý¡£
ÿÐж¨³¤£¨²»×㲿·Ö²¹Îª¿Õ¸ñ£©£»×î´ó³¤¶ÈΪÿÐÐ2000×Ö½Ú£¬È±Ê¡ÖµÎªÃ¿ÐÐ1×Ö½Ú¡£ÉèÖó¤¶È(size)ǰÐ迼ÂÇ×Ö·û¼¯Îªµ¥×Ö½Ú»ò¶à×Ö½Ú¡£
VARCHAR2 (size )
ÓÃÓÚ±£´æ±ä³¤µÄ×Ö·û´®Êý¾Ý¡£ÆäÖÐ×î´ó×Ö½Ú³¤ ......
Ò»£®Âß¼StandbyµÄ×¼±¸¹¤×÷
1 È·ÈϲÙ×÷µÄ¶ÔÏóºÍÓï¾äÊÇ·ñÄܱ»Âß¼StandbyÖ§³Ö
ÓÉÓÚÂß¼StandbyÊÇͨ¹ýSQLÓ¦ÓÃÀ´±£³ÖÓëPrimaryÊý¾Ý¿âµÄͬ²½¡£SQLÓ¦ÓÃÓëREDOÓ¦ÓÃÊÇÓкܴóµÄÇø±ð£¬REDOÓ¦ÓÃʵ¼ÊÉÏÊÇÔÚÎïÀíStandby¶Ë½øÐÐRECOVER£»SQLÓ¦ÓÃÔòÊÇ·ÖÎöÖØ×öÈÕÖ¾ÎļþÖеÄREDOÐÅÏ¢£¬²¢½«Æäת»»ÎªSQLÓï¾ä£¬ÔÚÂß¼Standby¶ËÖ´ ......