1.表可以查询,无法创建视图:
解决办法:用sys登录,执行:grant create any view to feems;
2.不同用户下表的迁移:
使用imp/exp工具,先用exp命令导出指定的表,然后再使用exp导入到新的用户下,注意选择from user:旧的用户,
to user:新的用户
3.不同表之间的数据迁移:
使用insert into table1(fieldname1,fieldname2,...) select (fieldname1,fieldname2,...) from table2
insert into
sm_terminal_gps_outline(
create_time,data_order,is_del,terminal_id,terminal_no,user_id,user_name,geo_xpoint,geo_ypoint,abs_xpoint,abs_ypoint,data_type,month,seq_id)
select
create_time,data_order,is_del,terminal_id,terminal_no,user_id,user_name,geo_xpoint,geo_ypoint,abs_xpoint,abs_ypoint,data_type,month,SM_TERMINAL_GPS_OUTLINE_SEQ.Nextval AS SEQ_ID
from dc_terminal_gps_OUTline