oracle 导入导出 exp imp

oracle 导入导出

exp help=y

imp help=y


exp lipf/lipf@orcl file=/home/oracle/aa.dmp  tables=student
imp lipf/lipf@orcl file=/home/oracle/aa.dmp  tables=student


----导出表
exp uf_cust/uf_cust@orcl  file=d:\tables.dmp tables=role_in,route_table,view_info,work,query_view,level_info,info_pack,info_detail,info,extend_type,extend_mode,disp_pack,disppack_info,detail_column,db_table,db_link,db_config,account,cust,server


---导入表
imp uf_cust/uf_cust@orcl  file=d:\tables.dmp tables=role_in,route_table,view_info,work,query_view,level_info,info_pack,info_detail,info,extend_type,extend_mode,disp_pack,disppack_info,detail_column,db_table,db_link,db_config,account,cust,server



他的help是这么写得，但是执行不成功、

按照用户备份数据库：
exp lipf/lipf owner=lipf file=/home/oracle/aa.dmp

恢复数据库
imp lipf/lipf fromuser=lipf touser=lipf file=/home/oracle/aa.dmp

另外导入导出还有其他的一些参数，具体参考 exp help=y   imp help=y;


dmp  ---到出的是二进制文件


:\>exp help=y 
--------------------------------------------------- 
USERID / 
FULL  (N) 
BUFFER  
OWNER  
FILE  (EXPDAT.DMP) 
TABLES  
COMPRESS  (Y) 
RECORDLENGTH IO  
GRANTS  (Y) 
INCTYPE  
INDEXES  (Y) 
RECORD  (Y) 
ROWS  (Y) 
PARFILE  
CONSTRAINTS  (Y) 
CONSISTENT  
LOG  
STATISTICS  (ESTIMATE) 
DIRECT  (N) 
TRIGGERS  (Y) 
FEEDBACK  x  (0)  
FILESIZE  
QUERY  
 
 
TRANSPORT_TABLESPACE  (N) 
TABLESPACES  
 
E:\>imp help=y 
USERID / 
FULL  (N) 
BUFFER  
FROMUSER  
FILE  (EXPDAT.DMP) 
TOUSER  
SHOW  (N) 
TABLES  
IGNORE  (N) 
RECORDLENGTH IO  
GRANTS  (Y) 
INCTYPE  
INDEXES  (Y) 
COMMIT  (N) 
ROWS  (Y) 
PARFILE  
LOG  
CONSTRAINTS  (Y) 
DESTROY  (N) 
INDEXFILE / 
SKIP_UNUSABLE_INDEXES  (N) 
ANALYZE  ANALYZE  (Y) 
FEEDBACK  x  (0)  
TOID_NOVALIDATE  id  
FILESIZE  
RECALCULATE_STATISTICS  (N) 
 
 
TRANSPORT_TABLESPACE  (N) 
TABLESPACES  
DATAFILES  
TTS_OWNERS 


1 table model
  1) backup one user's table
     exp icdmain/icd rows=y indexes=n compress=n buffer=65536 feedback=100000 volsize=0 file=exp_icdmain_table_yyyymmdd.dmp log=exp_icdmain_table_yyyymmdd.log tables=icdmain.commoninformation,icdmain.serviceinfo,icdmain.dealinfo
  2) recover all table
     imp icdmain/icd fromuser=icdmain touser=icdmain rows=y indexes=n commit=y buffer=65536 feedback=100000 ignore=y volsize=0 file=exp_icdmain_table_yyyymmdd.dmp log=imp_icdmain_table_yyyymmdd.log
  3) recover some table of all table
     imp icdmain/icd fromuser=icdmain touser=icdmain rows=y indexes=n commit=y buffer=65536 feedback=100000 ignore=y volsize=0 file=exp_icdmain_table_yyyymmdd.dmp log=imp_icdmain_table_yyyymmdd.log tables=commoninformation,serviceinfo
     



2 user model
  1) backup all someone's object
     exp icdmain/icd rows=y indexes=n compress=n buffer=65536 feedback=100000 volsize=0  owner=icdmain file=exp_icdmain_user_yyyymmdd.dmp log=exp_icdmain_user_yyyymmdd.log
  2) recover all someone's object
     imp icdmain/icd fromuser=icdmain touser=icdmain rows=y indexes=n commit=y buffer=65536 feedback=100000 ignore=y volsize=0 file=exp_icdmain_user_yyyymmdd.dmp log=imp_icdmain_user_yyyymmdd.log
  3) recover some table of all someone's object
     imp icdmain/icd fromuser=icdmain touser=icdmain rows=y indexes=n commit=y buffer=65536 feedback=100000 ignore=y volsize=0 file=exp_icdmain_user_yyyymmdd.dmp log=imp_icdmain_user_yyyymmdd.log tables=commoninformation,serviceinfo




3 full model
  1)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
  2)backup the full db for zengliang
    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
  3)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
  4)recover all date for zengliang backup
    imp system/manager rows=y indexes=n commit=y buffer=65536 feedback=100000 ignore=y volsize=0 full=y inctype=restore file=exp_fulldb_zl_yyyymmdd.dmp log=imp_fulldb_zl_yyyymmdd.log