백업

--전체백업
exp 아이디/암호@sid명 file=%date%.dmp grants=y

exp inchsudo/inch1234@SANGSUDO_YSD.WORLD file=sudo.dmp grants=y

--일부백업
exp 아이디/암호@sid명 tables=tb_customer,tb_category compress=y file=rds.dmp

--일부백업
exp 아이디/암호@sid tables=tb_customer,tb_category constraints=n indexes=n file=rds.dmp

exp playboy/playboy@ora81 tables=cms constraints=n indexes=n file=rds.dmp


imp playboy/playboy@ora81 full=n file file=20010526.DMP tables = cms indexes=n  fromuser=xxxxxx touser=yyyyyyyyy ignore = y indexfile = n

exp cdms/cdms01@CDMS file=cdms20040423.dmp grants=y
exp cdms/cdms01@CDMS file=rds.dmp grants=y
exp cdms/cdms01@CDMS tables=cm_login compress=y file=cdms20040504.dmp

exp cms4/cms4@sni38 file=cms4_2003_03_29.dmp grants=y
exp cms4/cms4@sni38 file=cms4_2003_03_29.dmp grants=y

exp cms4/cms4 tables=site_cat_cont_list compress=y file=site_cat_cont_list.dmp
exp cms4/cms4 tables=site_cat_cont_list compress=y file=site_cat_cont_list.dmp

exp cms4/cms4 tables=site_cat_cont_list compress=y file=site_cat_cont_list.dmp


exp rbt/rbt01@calldb file=%date%.dmp grants=y
exp cms/cms@ora9i file=cms20040618.dmp grants=y


exp rbt/rbt01@calldb tables=music_log_200311,music_stat_200311,charge_log_200310,charge_stat_200310,charge,cp_log_200310,cp_stat_200310 constraints=n indexes=n file=stat.dmp
imp rbt/rbt01@pbc02  full=y  file=calldb_1204_171735.dmp ignore=n