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;
用户user1拥有表table1
用户user2,需要复制一个一样的表。
方法:
user1执行: grant select on table1 to user2;
user2执行: create table table1 as select * from user1.table2;