如何在 Oracle 中导出视图
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/14317631/
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
How to export views in Oracle
提问by jobi88
How can i export only views in oracle using export command??
如何使用导出命令仅导出 oracle 中的视图？
I can able to export entire data base using this command.
我可以使用此命令导出整个数据库。
回答by Alen Oblak
With EXPDP, that's EXPORT DATA PUMP, you can export only views:
使用 EXPDP，即 EXPORT DATA PUMP，您只能导出视图：
expdp user/pass DUMPFILE=file.dmp DIRECTORY=ext_tab_dir SCHEMAS=test INCLUDE=VIEW
回答by Chris
That is not possible. Views are included in a user-level or full export, but there is no way to export only the views.
这是不可能的。视图包含在用户级或完全导出中，但无法仅导出视图。
If you just need the view definitions, but not necessarily in export dump format, you can for example get them via dbms_metadata.get_ddl. That will not include the grants, however.
如果您只需要视图定义，但不一定是导出转储格式，您可以例如通过dbms_metadata.get_ddl. 然而，这不包括赠款。
