Oracle：如何在 dmp 文件导入时禁用表压缩
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1757405/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle: how to disable table compression on dmp file import
提问by Timour
I have dmp file that was created by EXP utility. The source database has table compression enabled. How can I disable compression while importing dmp file. The destination database does not have this future enabled.
我有由 EXP 实用程序创建的 dmp 文件。源数据库启用了表压缩。如何在导入 dmp 文件时禁用压缩。目标数据库没有启用这个未来。
I can not find any switches on IMP utility for this purpose.
为此，我在 IMP 实用程序上找不到任何开关。
imp u/p@sid file=test.dmp LOG=test.log IGNORE=Y TABLES=(A_TABLE) FROMUSER=USR1 TOUSER=USR2
here is the error that I'm getting:
这是我得到的错误：
ORA-00439: feature not enabled: Table compression
Both databases are Oracle v 11g.
这两个数据库都是 Oracle v 11g。
回答by David Aldridge
I think you'll have to precreate your tables by using dbms_metadata to extract the definitions from the source database.
我认为您必须通过使用 dbms_metadata 从源数据库中提取定义来预先创建表。
You could also use the imp indexfile option to create an editable script in which COMPRESS could be globally replaced with NOCOMPRESS.
您还可以使用 imp indexfile 选项创建一个可编辑的脚本，其中 COMPRESS 可以全局替换为 NOCOMPRESS。
Datapump might have an option for doing this ... in 11g I'd be using datapump instead of imp/exp anyway.
Datapump 可能有一个选项来执行此操作...在 11g 中，无论如何我将使用 datapump 而不是 imp/exp。
