Oracle-从Dump-文件里提取-DDL-语句-方法说明.docVIP

Oracle-从Dump-文件里提取-DDL-语句-方法说明 Oracle 从Dump 文件里提取 DDL 语句 方法说明Oracle 从Dump 文件里提取 DDL 语句 方法说明 有关Dump 文件的命令有exp/imp 和 expdp/impdp。 这四个命令之前都有整理过相关的文章。 ORACLE EXP/IMP 说明 /tianlesoftware/article/details/4718366 exp/imp 与 expdp/impdp 对比 及使用中的一些优化事项 /tianlesoftware/article/details/6093973 Oracle expdp/impdp 使用示例 /tianlesoftware/article/details/6260138 Oracle 10g Data Pump Expdp/Impdp 详解 /tianlesoftware/article/details/4674224 Oracle expdp/impdp 从高版本 到 低版本 示例 /tianlesoftware/article/details/6533421 对于Dump 文件，我们不能直接提取出Data数据，但是我们可以通过相关的参数，从Dump文件中提取出对应的DDL 语句。 （1）如果是导出导入（exp/imp）,那么是indexfile参数。 （2）如果是数据泵（expdp/impdp）,那么是sqlfile 参数。 准备工作：SYS@anqing1(rac1)gt; create user dvdidentified by dvd; User created. SYS@anqing1(rac1)gt; grant dba to dvd; Grant succeeded. SYS@anqing1(rac1)gt; conn dvd/dvd; Connected. DVD@anqing1(rac1)gt; create table t1(idnumber); Table created. DVD@anqing1(rac1)gt; insert into t1values(1); 1 row created. DVD@anqing1(rac1)gt; commit; Commit complete. DVD@anqing1(rac1)gt; create index idx_t1on t1(id); Index created. DVD@anqing1(rac1)gt; 一.使用导出导入命令 1.1 导出dvd 用户的数据，生成dump文件[oracle@rac1 ~]$ exp dvd/dvd file=dvd.dmpowner=dvd Export: Release .0 - Production onWed Sep 21 19:50:14 2011 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 10gEnterprise Edition Release .0 - Production With the Partitioning, Real ApplicationClusters, OLAP, Data Mining and Real Application Testing options Export done in US7ASCII character set andAL16UTF16 NCHAR character set server uses ZHS16GBK character set(possible charset conversion) About to export specified users ... . exporting pre-schema procedural objectsand actions . exporting foreign function library namesfor user DVD . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions foruser DVD About to export DVDs objects ... . exporting database links . exporting sequence numbers . exporting cluster definitions . about to export DVDs