There are some tables need copy from one oracle user User1 to another user User2.
1. The structure of the two users are same;
2. No DB Link or privilege granted between those two users;
3. No primary key or unique key conflict between those two users' data;
4. The records number is not very much (at most 10000 for one table)write another copy scripts from User1 to User2 with below criteria :
1. The structure of the two users are same;
2.Can create DB Link or grant priv between those two users;
1. The structure of the two users are same;
2. No DB Link or privilege granted between those two users;
3. No primary key or unique key conflict between those two users' data;
4. The records number is not very much (at most 10000 for one table)write another copy scripts from User1 to User2 with below criteria :
1. The structure of the two users are same;
2.Can create DB Link or grant priv between those two users;
解决方案 »
- 使用sqlplus连接本地数据库报错ORA-12154
- oracle触发器修改同一表不同字段
- number(m,n)类型精确度问题,为什么number(16,4)类型存储111122223333.1234时存成了111122223333.1230
- ORACLE 编译$ make -f env_precomp.mk报错
- 求助一个sql语句
- 清高指点,为什么我的更新sql执行不了呀,问题出在哪里了
- 那位高手有,ORACLE9i 的驱动给我一份?
- 如何在java中把cursor给关掉。解决马上给分!
- pl/sql中插入记录的问题。
- Oracle 比较日期范围 结果不准确
- 几行不懂的代码
- 新手提问 关于此列列表的唯一或主键不匹配 的问题
用户user1拥有表table1
用户user2,需要复制一个一样的表。
方法:
user1执行: grant select on table1 to user2;
user2执行: create table table1 as select * from user1.table2;