Urgent help!!!# Database - 数据库
i*t
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!
the other account, what should I do? Thanks!
b*a
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/[email protected]
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!
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/[email protected]
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
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!
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!
相关阅读
[转载] SQL server2k on XP?Any popular Database Languages Support RULEBASE??安装完ORACLE9I后执行的SCRIPT有什么用呀？a question for JDBCms sql server 2000 中文版 --〉英文版 的问题mysql questionASP+SQL SERVER怎样处理这种有很多分叉的情况大侠们能给我解释下这都指什么吗? about Oracle现在都研究什么问题Why can't I find the proC compiler?Preparing Oracle Certificate Exam, but...??应该比较危险吧? Re: [转载] SQL server2k on XP?Help~~~~please. copy database tables from MSSQL server to Oracle9i DB in red hat linux7.3Why it took 4 hours to install Oracle9.2?Help!!!!我的tora为什么连不上oracle呀？安装ORACLE8.1.7遇到问题Big problem,need help!How to migrate a database from one sql server to another?有关focussql请教