Drop user OBS_ZHUJP CASCADE;
Create user OBS_ZHUJP profile default identified by OBS_ZHUJP default tablespace users temporary tablespace temp account unlock;
Grant delete any table to OBS_ZHUJP;
Grant drop any table to OBS_ZHUJP;
Grant insert any table to OBS_ZHUJP;
Grant select any table to OBS_ZHUJP;
Grant unlimited tablespace to OBS_ZHUJP;
Grant update any table to OBS_ZHUJP;
Exp HO2_CTF/HO2_CTF @ OBS file = c:/t4cdbdata. dmp owner = HO2_CTF full = y
Imp HO2_CTF/HO2_CTF @ OBS file = c:/t4cdbdata. dmp fromuser = HO2_CTF TOUSER = OBS_LUYW IGNORE = Y log = c:/implog. log
Imp HO2_CTF/HO2_CTF @ OBS file = c:/t4cdbdata. dmp fromuser = HO2_CTF TOUSER = OBS_LVL IGNORE = Y log = c:/implog. log
Imp HO2_CTF/HO2_CTF @ OBS file = c:/t4cdbdata. dmp fromuser = HO2_CTF TOUSER = OBS_ZHANGL IGNORE = Y log = c:/implog. log
IMP ho2_ctf/ho2_ctf @ obs file = C:/t4cdbdata. dmp fromuser = ho2_ctf touser = obs_fengy ignore = y log = C:/implog. Log
IMP ho2_ctf/ho2_ctf @ obs file = C:/t4cdbdata. dmp fromuser = ho2_ctf touser = obs_dengy ignore = y log = C:/implog. Log
IMP ho2_ctf/ho2_ctf @ obs file = C:/t4cdbdata. dmp fromuser = ho2_ctf touser = obs_liqk ignore = y log = C:/implog. Log
IMP ho2_ctf/ho2_ctf @ obs file = C:/t4cdbdata. dmp fromuser = ho2_ctf touser = obs_zhoul ignore = y log = C:/implog. Log
IMP ho2_ctf/ho2_ctf @ obs file = C:/t4cdbdata. dmp fromuser = ho2_ctf touser = obs_chenm ignore = y log = C:/implog. Log
IMP ho2_ctf/ho2_ctf @ obs file = C:/t4cdbdata. dmp fromuser = ho2_ctf touser = obs_zhujp ignore = y log = C:/implog. Log
IMP ho2_ctf/ho2_ctf @ obs file = C:/t4cdbdata. dmp fromuser = ho2_ctf touser = obs_weiqf ignore = y log = C:/implog. Log
IMP ho2_ctf/ho2_ctf @ obs file = C:/t4cdbdata. dmp fromuser = ho2_ctf touser = obs_heda ignore = y log = C:/implog. Log
Imp HO2_CTF/HO2_CTF @ OBS file = c:/t4cdbdata. dmp fromuser = HO2_CTF TOUSER = OBS_KOIZUMI IGNORE = Y log = c:/implog. log
Imp HO2_CTF/HO2_CTF @ OBS file = c:/t4cdbdata. dmp fromuser = HO2_CTF TOUSER = OBS_GUOYF IGNORE = Y log = c:/implog. log