oracle单个用户到数据,oracle将一个用户的表数据插入到另一个用户的表中

--相同数据库

insert into tb_b_animaltype select * from guiyang2.tb_b_animaltype;

insert into T_WMS_AREA

(AR_SN, AR_NAME, COMMANDSET_ID, ST_CODE, AT_CODE, O_CODE,AR_DEVICE,AR_REMARK,AR_AREA,AR_AREA_UNIT,AR_CUBAGE,

AR_CUBAGE_UNIT,AR_OUT_FLAG,AR_IN_FLAG,AR_PATH,AR_STATE,AR_FATHER_SN,STORAGE_RULES,STORAGE_BOX,EXISTING_BOX,

AR_IS_AGING,AR_PROPERTY)

select AR_SN,

AR_NAME,

COMMANDSET_ID,

ST_CODE,

AT_CODE,

O_CODE,

AR_DEVICE,

AR_REMARK,

AR_AREA,

AR_AREA_UNIT,

AR_CUBAGE,

AR_CUBAGE_UNIT,

AR_OUT_FLAG,

AR_IN_FLAG,

AR_PATH,

AR_STATE,

AR_FATHER_SN,

STORAGE_RULES,

STORAGE_BOX,

EXISTING_BOX,

AR_IS_AGING,

AR_PROPERTY

from AKADMIN.T_WMS_AREA;

--不同数据库

exp wcy/123 file=D:\wcy.dmp tables=表名;--先把该表导出

imp putuo/suyuan@new2 buffer=20000000 file=D:\wcy.dmp  fromuser=C##pro_new_two_test touser=putuo--再导出