[oracle@orazhang oracle]$ expdp sys/oracle directory=expdir schemas=anbob dumpfile=v.dmp include=TABLE:\\"LIKE \\'TEST%\\'\\" include=view:\\"like \\'V_%\\'\\"
Export: Release 10.2.0.1.0 - Production on 星期四, 14 7月, 2011 15:38:30
Copyright (c) 2003, 2005, Oracle. All rights reserved.
UDE-00008: operation generated ORACLE error 28009
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
[oracle@orazhang oracle]$ expdp \\'sys/oracle as sysdba\\' directory=expdir schemas=anbob dumpfile=v.dmp include=TABLE:\\"LIKE \\'TEST%\\'\\" include=view:\\"like \\'V_%\\'\\"
Export: Release 10.2.0.1.0 - Production on 星期四, 14 7月, 2011 15:28:03
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "SYS"."SYS_EXPORT_SCHEMA_01": 'sys/******** AS SYSDBA' directory=expdir schemas=anbob dumpfile=v.dmp include=TABLE:"LIKE 'TEST%'" include=view:"like 'V_%'"
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 192 KB
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "ANBOB"."TESTASC" 5.609 KB 3 rows
. . exported "ANBOB"."TESTFBK2" 5.273 KB 1 rows
. . exported "ANBOB"."TESTLOCK" 5.421 KB 19 rows
. . exported "ANBOB"."TESTCUR" 0 KB 0 rows
. . exported "ANBOB"."TESTFBK1" 0 KB 0 rows
. . exported "ANBOB"."TESTINT" 0 KB 0 rows
. . exported "ANBOB"."TESTINTE" 0 KB 0 rows
Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
/u01/app/oracle/v.dmp
Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 15:28:09
[oracle@orazhang oracle]$ impdp \\'sys/oracle as sysdba\\' directory=expdir remap_schema=anbob:weejar dumpfile=v.dmp
Import: Release 10.2.0.1.0 - Production on 星期四, 14 7月, 2011 15:30:19
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01": 'sys/******** AS SYSDBA' directory=expdir remap_schema=anbob:weejar dumpfile=v.dmp
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "WEEJAR"."TESTASC" 5.609 KB 3 rows
. . imported "WEEJAR"."TESTFBK2" 5.273 KB 1 rows
. . imported "WEEJAR"."TESTLOCK" 5.421 KB 19 rows
. . imported "WEEJAR"."TESTCUR" 0 KB 0 rows
. . imported "WEEJAR"."TESTFBK1" 0 KB 0 rows
. . imported "WEEJAR"."TESTINT" 0 KB 0 rows
. . imported "WEEJAR"."TESTINTE" 0 KB 0 rows
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/VIEW/VIEW
ORA-39082: Object type VIEW:"WEEJAR"."V_DL_TEST" created with compilation warnings
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SYS"."SYS_IMPORT_FULL_01" completed with 1 error(s) at 15:30:24
sys@ORCL> conn weejar/weejar
Connected.
weejar@ORCL> select view_name from user_views;
VIEW_NAME
------------------------------
V_DL_TEST
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。