Oracle Export/Importå·¥å
·ä½¿ç¨ä»ç»
Oracle Export/Importå·¥å
·ä½¿ç¨ä»ç»
Oracle Exp/Impå·¥å
·æ¯ä¸ä¸ªæä½ç®åãæ¹ä¾¿çµæ´»çå¤ä»½æ¢å¤åæ°æ®è¿ç§»å·¥å
·ï¼å®å¯ä»¥å®æ½å
¨åºçº§ãç¨æ·çº§ã表级çæ°æ®å¤ä»½åæ¢å¤ã对äºæ°æ®éå¨G级æG级以å
ï¼å¼ºè°é«å¯ç¨æ§ï¼å¯ä»¥å®¹å¿å°éæ°æ®ä¸¢å¤±çæ°æ®åºç³»ç»ï¼Exp/Impæ¯æ®é使ç¨çé»è¾å¤ä»½æ¹å¼ã
Ø Exportä»æ°æ®åºä¸å¯¼åºæ°æ®å°dumpæ件ä¸
Ø Importä»dumpæ件ä¸å°å
¥æ°æ®å¯¼æ°æ®åºä¸
1. 使ç¨å°Exp/Impå·¥å
·ççåºæ¯ï¼
1ï¼ ä¸¤ä¸ªæ°æ®åºä¹é´ä¼ éæ°æ®
a åä¸ä¸ªçæ¬çoracle Serverä¹é´
a ä¸åçæ¬çoracle Serverä¹é´
a åç§OSä¹é´
a ä¸åç§OSä¹é´
2ï¼ ç¨äºæ°æ®åºçå¤ä»½åæ¢å¤
3ï¼ ä»ä¸ä¸ªSCHEMAä¼ éå°å¦ä¸ä¸ªSCHEMA
4ï¼ ä»ä¸ä¸ªTABLESPACEä¼ éå°å¦ä¸ä¸ªTABLESPACE
2. DUMPæ件ä»ç»
EXPORTå°åºçæ¯äºè¿å¶æ ¼å¼çæ件ï¼ä¸å¯ä»¥æå·¥ç¼è¾ï¼å¦åä¼æåæ°æ®ã该æ件å¨ORACLEæ¯æçä»»ä½å¹³å°ä¸é½æ¯ä¸æ ·çæ ¼å¼ï¼å¯ä»¥å¨åå¹³å°ä¸éç¨ã
DUMPæ件å¨IMPORTæ¶éç¨åä¸å
¼å®¹æ¹å¼ï¼å°±æ¯è¯´ORALCE8çDUMPæ件å¯ä»¥å¯¼å
¥å°ORACLE9ä¸ï¼ä½æ¯çæ¬ç¸å·®å¾å¤§ççæ¬ä¹é´å¯è½æé®é¢ã
3. Oracle9i EXPåè½æè¿°
Oracle9i EXPå¨åæçåºç¡ä¸æ°å¢äºé¨åæ°çåæ°ï¼æåè½ä¸»è¦å为以ä¸å 个é¨åï¼
1ï¼ OBJECT_CONSISTENT - ç¨äºè®¾ç½®EXP对象为åªè¯»ä»¥ä¿æ对象çä¸è´æ§ãé»è®¤æ¯Nã
2ï¼ FLASHBACK_SCNåFLASHBACK_TIME - ç¨äºæ¯æFLASHBACKåè½èæ°å¢ã
3ï¼ RESUMABLEãRESUMABLE_NAMEåRESUMABLE_TIMEOUT - ç¨äºæ¯æRESUMABLE空é´åé
èæ°å¢ã
4ï¼ TTS_FULL_CHECK - ç¨äºå¨ä¼ è¾è¡¨ç©ºé´æ¶ä½¿ç¨ä¾èµæ§æ£æ¥ã
5ï¼ TEMPLATE - ç¨äºæ¯æiASã
6ï¼ TABLESPACES - 设置表空é´å¯¼åºæ¨¡å¼ã个人è§å¾å¯¹äºä¸è¬ç¨æ·èè¨ï¼è¿ä¸ªææ¯æ°å¢åæ°ä¸æå®ç¨çä¸ä¸ªï¼å¯ä»¥è®©ç¨æ·å¨åæ¥çFULLãOWNERãTABLESçåºç¡ä¸å¤äºä¸ç§éæ©ï¼ä½¿å¾EXPæ´å çµæ´»ã
4. EXPORT/IMPORTè¿ç¨ ï¼DUMPæ件å
å«çæ°æ®å¯¹è±¡ï¼
EXPORT导åºçDUMPæ件å
å«ä¸¤ç§åºæ¬ç±»åçæ°æ® ï¼
Ø DDL (Data Dictionary Language)
Ø Data
DUMPæ件å
å«ææéæ°å建Data DictionaryçDDLè¯å¥ï¼åºæ¬ä¸æ¯å¯ä»¥è¯»çæ ¼å¼ ï¼ä½æ¯åºè¯¥æ³¨æçæ¯ï¼åä¸ä¸è¦ç¨ææ¬ç¼è¾å¨ç¼è¾ä¹ï¼oracle说ä¸æ¯æè¿æ ·åçã
ä¸é¢ååºçæ¯DUMPæ件ä¸å
æ¬çORACLE对象ï¼å为TABLE/USER/FULLæ¹å¼ï¼æäºå¯¹è±¡åªæ¯å¨FULLæ¹å¼ä¸ææï¼æ¯å¦public synonyms, users, roles, rollback segmentsçï¼
Table mode User Mode Full Database Mode
---------------------- ---------------------- ----------------------
Table definitions Table definitions Table definitions
Table data Table data Table data
Owner's table grants Owner's grants Grants
Owner's table indexes Owner's indexes Indexes
Table constraints Table constraints Table constraints
Table triggers Table triggers All triggers
Clusters Clusters
Database links Database links
Job queues Job queues
Refresh groups Refresh groups
Sequences Sequences
Snapshots Snapshots
Snapshot logs Snapshot logs
Stored procedures Stored procedures
Private synonyms All synonyms
Views Views
Profiles
Replication catalog
Resource cost
Roles
Rollback segments
System audit options
System privileges
Tablespace definitions
Tablespace quotas
User definitions
5. IMPORTæ¶ç对象åå
¥é¡ºåº
1.Tablespaces
2.Profiles
3.Users
4.Roles
5.SystemPrivilegeGrants
6.RoleGrants
7.DefaultRoles
8.TablespaceQuotas
9.ResourceCosts
10.RollbackSegments
11.DatabaseLinks
12.Sequences
13.Snapshots
14.SnapshotLogs
15.JobQueues
16.RefreshGroups
17.ClusterDefinitions
18.Tables(alsogrants,comments,indexes,constraints,auditing)
19.ReferentialIntegrity
20.POSTTABLESactions
21.Synonyms
22.Views
23.StoredProcedures
24.Triggers,DefaultsandAuditing
æè¿ä¸ªé¡ºåºä¸»è¦æ¯è§£å³å¯¹è±¡ä¹é´ä¾èµå
³ç³»å¯è½äº§ççé®é¢ãTRIGGERæå导å
¥ï¼æ以å¨INSERTæ°æ®å°æ°æ®åºæ¶ä¸ä¼æ¿åTRIGGERãå¨å¯¼å
¥åå¯è½ä¼æä¸äºç¶ææ¯NVALIDçPROCEDUREï¼ä¸»è¦æ¯IMPORTæ¶ä¼å½±åä¸äºæ°æ®åºå¯¹è±¡ï¼èIMPORT并ä¸éæ°ç¼è¯PROCEDUREï¼ä»èé æè¿ç§æ
åµï¼å¯ä»¥éæ°ç¼è¯ä¹ï¼å°±è½è§£å³è¿ä¸ªé®é¢ã
6. å
¼å®¹æ§é®é¢
IMPORTå·¥å
·å¯ä»¥å¤çEXPORT 5.1.22ä¹åççæ¬å¯¼åºçDUMPæ件ï¼æä»¥ä½ ç¨ORACLE7çIMPORTå¤çORACLE6çDUMPæ件ï¼ä¾æ¬¡ç±»æ¨ï¼ä½æ¯ORACLEå¦æçæ¬ç¸å·®å¾å¤§æå¯è½ä¸è½å¤çãå
·ä½çé®é¢å¯ä»¥åç
§ç¸åºçææ¡£ï¼æ¯å¦æå
³åæ°è®¾ç½®çï¼COMPATIBLEåæ°ï¼
² EXPORTéè¦çVIEW
EXPORTéè¦çVIEWæ¯ç±CATEXP.SQLå建ï¼è¿äºå
é¨VIEWç¨äºEXPORTç»ç»DUMPæ件ä¸æ°æ®æ ¼å¼ã大é¨åVIEWç¨äºæ¶éå建DDLè¯å¥çï¼å
¶ä»ç主è¦ä¾ORACLEå¼å人åç¨ãè¿äºVIEWå¨ä¸åORACLEçæ¬ä¹é´æå¯è½ä¸åï¼æ¯ä¸ªçæ¬å¯è½é½ææ°çç¹æ§å å
¥ãæ以å¨æ°ççæ¬éé¢æ§è¡æ§çdumpæ件ä¼æé误ï¼ä¸è¬å¯ä»¥æ§è¡CATEXP.SQL解å³è¿äºé®é¢ï¼
² 解å³ååå
¼å®¹é®é¢çä¸è¬æ¥éª¤å¦ä¸ï¼
1) 导åºæ°æ®åºççæ¬æ¯ç®æ æ°æ®åºèçæ
åµï¼
Ø å¨éè¦å¯¼å
¥çç®æ æ°æ®åºä¸æ§è¡æ§çCATEXP.SQL
Ø ä½¿ç¨æ§çEXPORT导åºDUMPæ件
Ø ä½¿ç¨æ§çIMPORT导å
¥å°æ°æ®åºä¸
Ø å¨æ°æ®åºä¸æ§è¡æ°çCATEXP.SQLï¼ä»¥æ¢å¤è¯¥çæ¬çEXPORT VIEW
2) 导åºæ°æ®åºççæ¬æ¯ç®æ æ°æ®åºæ°çæ
åµ
Ø å¨éè¦å¯¼å
¥çç®æ æ°æ®åºä¸æ§è¡æ°çCATEXP.SQL
Ø ä½¿ç¨æ°çEXPORT导åºDUMPæ件
Ø ä½¿ç¨æ°çIMPORT导å
¥å°æ°æ®åºä¸
Ø å¨æ°æ®åºä¸æ§è¡æ§çCATEXP.SQLï¼ä»¥æ¢å¤è¯¥çæ¬çEXPORT VIEW
7. ç¢çæ´ç
EXPORT/IMPORTä¸ä¸ªå¾éè¦çåºç¨æ¹é¢å°±æ¯æ´çç¢çãå 为å¦ææ¶å次IMPPORTï¼å°±ä¼éæ°CREATE TABLE å导å
¥æ°æ®ï¼æ以æ´å¼ 表é½æ¯è¿ç»åæ¾çã
å¦å¤ç¼ºçæ
åµä¸EXPORTä¼å¨çæDUMPæ件æ¯âå缩(COMPRESS)âTABLE,ä½æ¯è¿ç§å缩å¨å¾å¤æ
åµä¸è¢«è¯¯è§£ãäºå®ä¸ï¼COMPRESSæ¯æ¹åSTORAGEåæ°INITIALçå¼ãæ¯å¦ï¼CREATE TABLE .... STORAGE( INITIAL 10K NEXT 10K..) ç°å¨æ°æ®å·²ç»æ©å±å°100个EXTENT,å¦æéç¨COMPRESS=Yæ¥EXPORTæ°æ®ï¼å产ççè¯å¥æ¶ STORAGE( INITIAL 1000K NEXT 10K) ;æ们å¯ä»¥çå°NEXTå¼å¹¶æ²¡ææ¹åï¼èINITIALæ¯ææEXTENTçæ»åãæ以ä¼åºç°å¦ä¸æ
åµï¼è¡¨Aæ4个100MçEXTENT,æ§è¡DELETE FROM Aï¼ç¶ååç¨COMPRESS=Y 导åºæ°æ®ï¼äº§ççCREATE TABLEè¯å¥å°æ400MçINITIAL EXTENTãå³ä½¿è¿æ¯TABLEä¸å·²ç»æ²¡ææ°æ®ï¼ï¼è¿æ¯çDUMPæ件å³ä½¿å¾å°ï¼ä½æ¯å¨IMPORTæ¶å°±ä¼äº§çä¸ä¸ªå·¨å¤§çTABLE. å¦å¤ï¼ä¹å¯è½ä¼è¶
è¿DATAFILEç大å°ãæ¯å¦ï¼æ4个50Mçæ°æ®æ件ï¼å
¶ä¸è¡¨Aæ15个10MçEXTENT,å¦æéç¨COMPRESS=Yçæ¹å¼å¯¼åºæ°æ®ï¼å°ä¼æINITIAL=150Mé£ä¹å¨éæ°å¯¼å
¥æ¶ï¼ä¸è½åé
ä¸ä¸ª150MçEXTENTï¼å 为å个EXTENTä¸è½è·¨å¤ä¸ªæ件ã
8. å¨USERåTABLESPACEä¹é´ä¼ éæ°æ®
ä¸è¬æ
åµä¸EXPORTçæ°æ®è¦æ¢å¤å°å®åæ¥çå°æ¹å»ãå¦æSCOTTç¨æ·ç表以TABLEæUSERæ¹å¼EXPORTæ°æ®ï¼å¨IMPORTæ¶ï¼å¦æSCOTTç¨æ·ä¸åå¨ï¼åä¼æ¥é! 以FULLæ¹å¼å¯¼åºçæ°æ®å¸¦æCREATE USERçä¿¡æ¯ï¼æ以ä¼èªå·±å建USERæ¥åæ¾æ°æ®ãå½ç¶å¯ä»¥å¨IMPORTæ¶ä½¿ç¨FROMUSERåTOUSERåæ°æ¥ç¡®å®è¦å¯¼å
¥çUSERï¼ä½æ¯è¦ä¿è¯TOUSERä¸å®å·²ç»åå¨å¦ã
å¨impæ·»å åæ°TABLESPACES å¯ä»¥æ¹å导å
¥æ°æ®ç表空é´ï¼
è¿æ2ç§æ
åµï¼ä¸ç§æ¯å¨æ°æ®å¯¼å
¥å建好表ï¼æ表建å°å
¶ä»è¡¨ç©ºé´ä¸ï¼å导å
¥æ°æ®ï¼å¦ä¸ç§æ
åµæ¯æ¶å导å
¥ç¨æ·çunlimited tablespaceçæéä¼å¯¼å
¥ç¨æ·çé»è®¤è¡¨ç©ºé´ï¼
9. EXPORT/IMPORT对SQUENCEçå½±å
å¨ä¸¤ç§æ
åµä¸ï¼EXPORT/IMPORTä¼å¯¹SEQUENCEã
1ï¼ å¦æå¨EXPORTæ¶ï¼ç¨æ·æ£å¨åSEQUENCEçå¼ï¼å¯è½é æSEQUENCEçä¸ä¸è´ã
2ï¼ å¦å¤å¦æSEQUENCE使ç¨CACHEï¼å¨EXPORTæ¶ï¼é£äºå¨CACHEä¸çå¼å°±ä¼è¢«å¿½ç¥çï¼åªæ¯ä»æ°æ®åå
¸éé¢åå½åå¼EXPORTã
å¦æå¨è¿è¡FULLæ¹å¼çEXPORT/IMPORTæ¶ï¼æ°å¥½å¨ç¨sequenceæ´æ°è¡¨ä¸æåæ°æ®ï¼èä¸ä¸æ¯ä¸é¢ä¸¤ç§æ
åµï¼å导åºçæ¯æ´æ°åçæ°æ®ã
å¦æéç¨å¸¸è§è·¯å¾æ¹å¼ï¼æ¯ä¸è¡æ°æ®é½æ¯ç¨INSERTè¯å¥ï¼ä¸è´æ§æ£æ¥åINSERT TRIGGER
å¦æéç¨DIRECTæ¹å¼ï¼æäºçº¦æåtriggerå¯è½ä¸è§¦åï¼å¦æå¨triggerä¸ä½¿ç¨sequence.nextvalï¼å°ä¼å¯¹sequenceæå½±åã
10. EXP常ç¨é项
1ï¼ FULLï¼è¿ä¸ªç¨äºå¯¼åºæ´ä¸ªæ°æ®åºï¼å¨ROWS=Nä¸èµ·ä½¿ç¨æ¶ï¼å¯ä»¥å¯¼åºæ´ä¸ªæ°æ®åºçç»æãä¾å¦ï¼
exp sys file=test.dmp log=test.log full=y rows=n compress=y direct=y
2ï¼ BUFFERåFEEDBACKï¼å¨å¯¼åºæ¯è¾å¤çæ°æ®æ¶ï¼èè设置è¿ä¸¤ä¸ªåæ°ãä¾å¦ï¼
exp new file=test.dmp log=test.log feedback=10000 buffer=100000000 tables=test1,test2
3ï¼ FILLåLOGï¼è¿ä¸¤ä¸ªåæ°åå«æå®å¤ä»½çDMPå称åLOGå称ï¼å
æ¬æ件ååç®å½ï¼éè¦è¯´æçæ¯ï¼EXPå¯ä»¥ç´æ¥å¤ä»½å°ç£å¸¦ä¸ï¼å³ä½¿ç¨FILE=/dev/rmt0(ç£å¸¦è®¾å¤å)ï¼ä½æ¯ä¸è¬æ们é½ä¸è¿ä¹åï¼åå æäºï¼ä¸ãè¿æ ·åçé度ä¼æ
¢å¾å¤ï¼äºãç°å¨ä¸è¬é½æ¯ä½¿ç¨ç£å¸¦åºçï¼ä¸å»ºè®®ç´æ¥å¯¹ç£å¸¦è¿è¡æä½ãè³äºæ²¡æ使ç¨ç£å¸¦åºçæåå¯ä»¥èèåUNIXçTARç»å使ç¨ãå¦æä½ çæ³ä½¿ç¨EXPç´æ¥å°ç£å¸¦ï¼ä½ å¯ä»¥åèMetalinkæç« âEXPORTING TO TAPE ON UNIX SYSTEMSâï¼ææ¡£å·ï¼30428.1ï¼ï¼è¯¥æä¸æ详ç»è§£éã
4ï¼ COMPRESSåæ°å°å¨å¯¼åºçåæ¶å并ç¢åï¼å°½éææ°æ®å缩å°initialçEXTENTéï¼é»è®¤æ¯Nï¼ä¸è¬å»ºè®®ä½¿ç¨ãDIRECTåæ°å°åè¯EXPç´æ¥è¯»åæ°æ®ï¼èä¸åä¼ ç»çEXPé£æ ·ï¼ä½¿ç¨SELECTæ¥è¯»å表ä¸çæ°æ®ï¼è¿æ ·å°±åå°äºSQLè¯å¥å¤çè¿ç¨ãä¸è¬ä¹å»ºè®®ä½¿ç¨ãä¸è¿æäºæ
åµä¸DIRECTåæ°æ¯æ æ³ä½¿ç¨çã
5ï¼ å¦ä½ä½¿ç¨SYSDBAæ§è¡EXP/IMP
è¿æ¯ä¸ä¸ªå¾ç°å®çé®é¢ï¼ææ¶åæ们éè¦ä½¿ç¨SYSDBAæ¥æ§è¡EXP/IMPï¼å¦è¿è¡ä¼ è¾è¡¨ç©ºé´çEXP/IMPï¼ä»¥åå¨9iä¸ç¨SYSç¨æ·æ¥æ§è¡EXP/IMPæ¶ï¼é½éè¦ä½¿ç¨SYSDBAæå¯ãæ们å¯ä»¥ä½¿ç¨ä¸é¢æ¹å¼è¿å
¥EXP/IMPï¼
exp "'sys/sys as sysdba'" file=1.dmp tables=trst rows=n
6ï¼ QUERYåæ°åé¢è·çæ¯whereæ¡ä»¶ï¼å¼å¾æ³¨æçæ¯ï¼æ´ä¸ªwhereåå¥éè¦ä½¿ç¨""æ¬èµ·æ¥ï¼whereåå¥çåæ³åSELECTä¸ç¸åï¼
Ø å¦ææ¯UNIXå¹³å°ææ"å'é½éè¦ä½¿ç¨\u26469å±è½å®ä»¬çç¹æ®å«ä¹ï¼
exp test/test file=1.dmp log=1.log tables=testtable query="where c1=20 and c2=test"
注æï¼>,<,åå¼å·çç¹æ®å符éè¦è½¬è¯
exp test/test file=1.dmp log=1.log tables=testtable query="where c1\>20 and c2=to_date\(\'20090506\',\'yyyymmdd\'\)"
Ø å¦ææ¯windowså¹³å°ï¼å使ç¨ä¸é¢çæ ¼å¼ï¼
exp c/c@ncn file=c.dmp log=c.log tables=t query="""where id=1 and name='gototop'"""ï¼ä½¿ç¨unixä¸æ ¼å¼ä¹æ¯å¯ä»¥çï¼å
·ä½æ
åµæµè¯ä¸ä¸å³å¯ï¼
exp导åºæ¶ï¼å whereæ¡ä»¶:
exp scott/tiger TABLES=(emp,bonus) QUERY="WHERE job='SALESMAN' and sal<1600"
éå¶:
1.The parameter QUERY cannot be specified for full, user, or tablespace mode exports.
åæ°queryä¸è½ä½¿ç¨å¨å®å
¨å¯¼åº,ç¨æ·å¯¼åºå表空é´å¯¼åºæ¹å¼
2.The parameter QUERY must be applicable to all specified tables.
åæ°queryæå®çå
容å¿
须对æææå®ç表é½ææ
3.The parameter QUERY cannot be specified in a direct path export (DIRECT=y)
åæ°queryä¸è½ä¸directè·¯å¾å¯¼åºåæ¶ä½¿ç¨
4.The parameter QUERY cannot be specified for tables with inner nested tables.
åæ°queryä¸è½å¯¼åºå
åµè¡¨
5.You cannot determine from the contents of the export file whether the data is the result of a QUERY export.
ç¨queryåæ°å¯¼åºçæ°æ®ä¸åå
¶ä»æ¹å¼å¯¼åºçæ°æ®æ¯ä¸æ ·ç,æ æ³æ ¹æ®å¯¼åºæ件è¿è¡å辨
11. IMP常ç¨é项
1ï¼ FROMUSERåTOUSERï¼ä½¿ç¨å®ä»¬å®ç°å°æ°æ®ä»ä¸ä¸ªSCHEMAä¸å¯¼å
¥å°å¦å¤ä¸ä¸ªSCHEMAä¸ï¼
2ï¼ IGNOREãGRANTSåINDEXESï¼å
¶ä¸IGNOREåæ°å°å¿½ç¥è¡¨çåå¨ï¼ç»§ç»å¯¼å
¥ï¼è¿ä¸ªå¯¹äºéè¦è°æ´è¡¨çåå¨åæ°æ¶å¾æç¨ï¼æ们å¯ä»¥å
æ ¹æ®å®é
æ
åµç¨åççåå¨åæ°å»ºå¥½è¡¨ï¼ç¶åç´æ¥å¯¼å
¥æ°æ®ãèGRANTSåINDEXESå表示æ¯å¦å¯¼å
¥ææåç´¢å¼ï¼å¦ææ³ä½¿ç¨æ°çåå¨åæ°é建索å¼ï¼æè
为äºå å¿«å°å
¥é度ï¼æ们å¯ä»¥èèå°INDEXES设为Nï¼èGRANTSä¸è¬é½æ¯Yã
3ï¼ å¦å¤ä¸ä¸ªEXP/IMPé½æçåæ°æ¯PARFILEï¼å®æ¯ç¨æ¥å®ä¹EXP/IMPçåæ°æ件ï¼ä¹å°±æ¯è¯´ï¼ä¸é¢çåæ°é½å¯ä»¥åå¨ä¸ä¸ªåæ°æ件ä¸ï¼ä½æ们ä¸è¬å¾å°ä½¿ç¨ã
12. å¨è¿è¡å¹¶è¡EXP/IMPçæ¶åï¼å¦æIMPè¿ç¨å»ºç´¢å¼çè¯ä¸å»ºè®®åæ¶è¿è¡5个以ä¸çIMPï¼å¦æä½ æ³å å¿«é度ï¼å¯ä»¥å¨IMPçæ¶åä¸å»ºç´¢å¼ï¼è¿æ ·åªè¦å
åå
许ï¼å¯ä»¥å¤è·å 个ï¼ç¶åæ¯SQLèæ¬å建éè¦çç´¢å¼ã
13. æ´çåºæ¥çå®ä¾ä¾å¤§å®¶åè
Export/Importæä¸ä¸ªçº§å«: 表级, ç¨æ·çº§åå
¨æ°æ®åºçº§.
1ï¼ table modelï¼æ表å¤çç模å¼ï¼
Ø backup one user's tableï¼å¤ä»½ä¸ä¸ªç¨æ·ä¸ç表ï¼
exp test/test rows=y indexes=n compress=n buffer=65536 feedback=100000 volsize=0 file=exp_table_yyyymmdd.dmp log=exp_table_yyyymmdd.log tables=test_table1,test_table2
Ø recover all tableï¼å¯¼å
¥å
¨é¨å¤ä»½ç表ï¼
imp test2/test2 fromuser=test touser=test2 rows=y indexes=n commit=y buffer=65536 feedback=100000 ignore=y volsize=0 file=exp_table_yyyymmdd.dmp log=imp_table_yyyymmdd.log
Ø recover some table of all tableï¼å¯¼å
¥å¤ä»½çé¨å表ï¼
imp test2/test2 fromuser=test touser=test2 rows=y indexes=n commit=y buffer=65536 feedback=100000 ignore=y volsize=0 file=exp_table_yyyymmdd.dmp log=imp_table_yyyymmdd.log tables=test_table1
2ï¼ user modelï¼ç¨æ·æ¨¡å¼ï¼
Ø backup all someone's objectï¼å¤ä»½ä¸ä¸ªç¨æ·çææçæ°æ®å¯¹è±¡ï¼
exp test/test rows=y indexes=n compress=n buffer=65536 feedback=100000 volsize=0 owner=test file=exp_user_yyyymmdd.dmp log=exp_user_yyyymmdd.log
Ø recover all someone's object
imp test2/test2 fromuser=test touser=test2 rows=y indexes=n commit=y buffer=65536 feedback=100000 ignore=y volsize=0 file=exp_user_yyyymmdd.dmp log=imp_user_yyyymmdd.log
Ø recover some table of all someone's object
imp test2/test2 fromuser=test touser=test2 rows=y indexes=n commit=y buffer=65536 feedback=100000 ignore=y volsize=0 file=exp_user_yyyymmdd.dmp log=imp_user_yyyymmdd.log tables=test_table1,test_table2,test_table3
3ï¼ full model
Ø backup the full db for all
exp system/manager rows=y indexes=n compress=n buffer=65536 feedback=100000 volsize=0 full=y inctype=complete file=exp_fulldb_yyyymmdd.dmp log=exp_fulldb_yyyymmdd.log
Ø backup the full db for increment
exp system/manager rows=y indexes=n compress=n buffer=65536 feedback=100000 volsize=0 full=y inctype=incremental file=exp_fulldb_zl_yyyymmdd.dmp log=exp_fulldb_zl_yyyymmdd.log
注æï¼inctypeæ¯8iç9iå·²ç»ä¸ç¨äº
Ø recover all date for full backup
imp system/manager rows=y indexes=n commit=y buffer=65536 feedback=100000 ignore=y volsize=0 full=y file=exp_fulldb_yyyymmdd.dmp log=imp_fulldb_yyyymmdd.log
Ø recover all date for increment backup
imp system/manager rows=y indexes=n commit=y buffer=65536 feedback=100000 ignore=y vol
size=0 full=y inctype=restore file=exp_fulldb_zl_yyyymmdd.dmp log=imp_fulldb_zl_yyyymmdd.log
温馨提示:答案为网友推荐,仅供参考