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)
Study the solution, and 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;我刚接触Oracle 请高手指教,谢谢
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)
Study the solution, and 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;我刚接触Oracle 请高手指教,谢谢
create table USER1.tab1
tablespace myspace
storage
(initial 1M
NEXT 1M
)
AS SELECT * FROM USER2.TAB2;
能不能试着先导出一个.sql的文件.再在第2个用户那里,导入这个文件并执行.
这样的做不知道是否合乎题目的要求.