Home
Sign Up
Sign In
V2EX
›
问与答
怎么快速全量抽取一张大表
statement
·
Jan 14, 2020
· 1955 views
This topic created in 2490 days ago, the information mentioned may be changed or developed.
create table A tablespace A_TAB as select * from B@dblink_B ;
速度奇慢,而且会表空间自动扩展失效撑爆表空间
有什么好的办法吗
会表
全量
select
tablespace
3 replies
•
2020-01-14 14:34:08 +08:00
lazypu
Jan 14, 2020
1
navicat 连上去, 点击表名 ctrl+c ctrl+v (不晓得它执行了啥语句)?
Achiii
Jan 14, 2020
2
有多大
statement
OP
Jan 14, 2020
3
@
Achiii
5 亿左右
About
·
Help
·
Advertise
·
Blog
·
API
·
FAQ
·
Privacy
·
Solana
·
1631 Online
Highest 6679
·
Select Language
创意工作者们的社区
World is powered by solitude
VERSION: 3.9.8.5 · 24ms ·
UTC 13:33
·
PVG 21:33
·
LAX 05:33
·
JFK 08:33
♥ Do have faith in what you're doing.
❯