i*****t 发帖数: 220 | 1 If I open two oracle accounts and want to copy the tables from one account to
the other account, what should I do? Thanks! | b******a 发帖数: 20 | 2 My two cents:
You can create synonyms or grant read pemissions if you just need the same set
of data.
If you just want to copy the data one time and change them separately down the
road.
Inside one database, try following
For account B, run
create table T1 as select * from A.T1;
create table T2 as select * from A.T2;
... ...
Across different databases, use sqlplus COPY command
COPY FROM SCOTT/TIGER@MYDATABASE
INSERT T1 -
USING SELECT * FROM T1
... ...
to
【在 i*****t 的大作中提到】 : If I open two oracle accounts and want to copy the tables from one account to : the other account, what should I do? Thanks!
| s****d 发帖数: 13 | 3 Use the imp/exp
If u dont mind also copy other objects :
exp .. owner=user1 ...
imp .. fromuser=user1 touser=user2 ..
If u want tables only:
exp .. tables=t1,t2,.. ..
imp .. tables=t1,t2,... ..
good luck
to
【在 i*****t 的大作中提到】 : If I open two oracle accounts and want to copy the tables from one account to : the other account, what should I do? Thanks!
|
|