[ 图 ] oracle 数据库备份 expisc/isc#1234@10.150.19.1:1521/iscfile=e:\temp\4A_ISC_USER.dmptables=(ISC_USER) expisc/isc#1234@10.150.19.1:1521/iscfile=e:\temp\4A_all.dmpfull=y EXPisc1/isc#1234@10.150.19.1:1521/isc1BUFFER=64000FILE=e:\temp\4A1.DMPOWNER=ISC1TABLES=(ISC_USER)
关联查询 selectt.*,u.hrdeptid,u.newou,b.newoufromisc_user_配网用户名重复t,isc_useru,isc_baseorgb wheret.用户id=u.idandu.newou=b.newou
数据清理 select*fromisc_userwherenamecodelike'%qy.gd.csg.cn%' select*fromtmp_yx_user_0401 isc_usert.NAMECODE hr_user_qy0331_okLOGIN_NAMEisnotnull/*5334*/ select*fromtmp_yx_user_0401_qy_login_name; select*fromhr_user_qy0331_ok; CREATETABLEtmp_yx_user_qy_0403as( selecty.*,h.员工id,h.ouASHROU,h.员工所属
更新isc_user newou updateisc_useraseta.newou=(selectb.newoufromisc_baseorgbwherea.baseorg_id=b.id) whereexists(select1fromisc_baseorgcwherea.baseorg_id=c.id)