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请教Question about SQL server lock小网站项目行情交流SQL String question现在有人招database的工作吗新手提问急，SQL2005, 怎么查过去一小时里run过的所有query?Custom Chart Color Palettes in SSRS 2005Does anyone know Cache or Clarity database?Experts: Oracle database option price hikes no accident (ZZ)programing的contract job每天都要按时去公司上班吗？早9晚5？Import data in R如何复制数据最快?问个sql/ ssis的问题 谢谢！请教专家：这种宽泛的问题怎么准备阿？看看这database server 要升极吗来说说上次发的微软面试题 1关于MSSQL, 问几个比较土的问题file based database