导出某个view

页面导航:首页 > 数据库 > oracle > 导出某个view

导出某个view

来源: 作者: 时间:2016-01-29 09:07 【

今天同事问我,如何导出某一个view,我较少见这么细粒度的需求,果断测试一下:[[email protected] log]$ expdp xxx xxx directory=DATA_PUMP_DIR dumpfile=view dmp logfile=view_exp log views=V_TESTLRM-0

今天同事问我,如何导出某一个view,我较少见这么细粒度的需求,果断测试一下:

[[email protected] log]$ expdp xxx/xxx directory=DATA_PUMP_DIR dumpfile=view.dmp logfile=view_exp.log views=V_TEST
LRM-00101: unknown parameter name 'views'

意料之中,我一点都不失望,因为看help的时候,根本没有view这个参数。继续:
[[email protected] log]$ vi par.par 
INCLUDE = VIEW: "in ( 'V_TEST' ) ";

[[email protected] log]$ expdp lm/lm directory=DATA_PUMP_DIR dumpfile=view.dmp logfile=view_exp.log parfile=par.par Export: Release 11.2.0.1.0 - Production on Thu Jan 21 02:07:04 2016 Copyright (c) 1982, 2009,  and/or its affiliates.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options Starting "LM"."SYS_EXPORT_SCHEMA_04":  lm/******** directory=DATA_PUMP_DIR dumpfile=view.dmp logfile=view_exp.log parfile=par.par Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 0 KB Processing object type SCHEMA_EXPORT/VIEW/VIEW Master table "LM"."SYS_EXPORT_SCHEMA_04" successfully loaded/unloaded ****************************************************************************** Dump file set for LM.SYS_EXPORT_SCHEMA_04 is:   /u02/app/oracle/product/11.2.0/dbhome_1/rdbms/log/view.dmp Job "LM"."SYS_EXPORT_SCHEMA_04" successfully completed at 02:07:15 OK! 

 
Tags:

相关文章

    文章评论

    最 近 更 新
    热 点 排 行
    Js与CSS工具
    代码转换工具
    
    <