Import , Export

imp system/manager fromuser=weblogic_comp touser=ktforum file=weblogic_comp.dmp

----8i

exp member/member1220@MEMBER

exp scott/tiger file=expdat.dmp compress=y tables=emp,dept 

exp community/community file=comm.dmp fully='y' 

;

;

--9i

exp ighome/ighome file=ighome.dmp fully compress

;

exp ebs/ebs123 file=ebs_comm.dmp compress=y

imp system/manager fromuser=community touser=trdoig_comm file=orabackup.dmp

imp community/community GRANTS=Y INDEXES=Y ROWS=Y CONSTRAINTS=Y IGNORE=N SHOW=N DESTROY=Y ANALYZE=Y SKIP_UNUSABLE_INDEXES=N RECALCULATE_STATISTICS=N fromuser=dreams touser=dreams file='daejin.dmp'   NLS_NCHAR_CHARACTERSET=american_america.KO16KSC5601

;

american_america.KO16MSWIN949 - > K016KSC5601

imp system/manager fromuser=community touser=trdoig_comm file=comm2.dmp

imp system/manager fromuser=igblog touser=trdoig_blog file=blog.dmp

imp system/manager formuser=igblog touser=trdoig_comm file=blog.dmp

imp system/manager formuser=ebs touser=ebs_blog file=community.dmp

imp system/manager fromuser=ktforum touser=trdoig_dumy file=orabackup.dmp