通过Oracle 10g中的数据库链接进行传输是否已压缩?是否有可能? [英] Is transfer via database link in Oracle 10g compressed ? Is it possible?

问题描述

我正在通过数据库链接(使用INSERT INTO SELECT ...)将数据从一个库传输到另一个库.

I'm transferring data from one base to another via database links (using INSERT INTO SELECT ...).

我想知道通过链接传输的数据是压缩的还是可以压缩的，以避免过多的网络使用.我的带宽非常小，如果尚未完成，那会有所帮助.

I want to know if data transferred through the link is compressed or can be compressed to avoid too much network use. I have very little bandwidth, and I think that would help if it's not already done.

推荐答案

有一些重复数据删除，但没有严重的压缩.

There's some de-duplication but no serious compression.

有一个UTL_COMPRESS函数，但是要在目标上解压缩它可能很棘手(可能是触发器，而不是视图-但这很笨拙).

There is a UTL_COMPRESS function but it would be tricky to get that to decompress on the destination (maybe a trigger, or instead of view - but it is clunky).

EXPDP可以使用数据库链接( NETWORK_LINK )，在11g中，压缩，但确实需要高级压缩选项才能获得许可.

EXPDP can use a database link (NETWORK_LINK) and, in 11g, compression but that does require the Advanced Compression option to be licensed.

最后有常规的提取，压缩，传输，解压缩，加载

Lastly there's conventional extract, zip, transfer, unzip, load

在11gR2中，您可以将外部表与

In 11gR2 you can use external tables with a preprocessor to unzip, so you could semi-automate that final option.

这篇关于通过Oracle 10g中的数据库链接进行传输是否已压缩?是否有可能?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！