Oracle10g新特性之-expdp/impdp的停止与重启动

eygle

expdp/impdp基本上就是这样一种方式

改天再做个总结吧

szgz

做个记号

改天做试验

dlinger

该文档下载链接:

http://www.itpub.net/showthread. ... 1463718#post1463718

dlinger

看了看expdp的dmp文件
呵呵,oracle原来是用实现的xml来实现的

我做了一个CTAS from dba_objects的表T,
我把T的dmp文件头格式化了一下:
[php]
<?xml version="1.0"?>
<ROWSET>
<ROW>
<STRMTABLE_T><VERS_MAJOR>1</VERS_MAJOR><VERS_MINOR>0</VERS_MINOR>
<VERS_DPAPI>3</VERS_DPAPI><ENDIANNESS>2</ENDIANNESS>
<CHARSET>ZHS16GBK</CHARSET><NCHARSET>AL16UTF16</NCHARSET><DBTIMEZONE>+00:00</DBTIMEZONE>
<FDO>0000006001240F050B0C030C0C0504050D0609070805050505050F05050505050A050505050504050607080823472323081123081141B0230083035407D00300000000000000000000000000000000000000000000000000000000000000000000000000</FDO>
<OBJ_NUM>51944</OBJ_NUM><OWNER_NAME>DLINGER</OWNER_NAME><NAME>T</NAME>
<PROPERTY>536870912</PROPERTY>
<COL_LIST>
<COL_LIST_ITEM>
    <OBJ_NUM>51944</OBJ_NUM><COL_NUM>1</COL_NUM><INTCOL_NUM>1</INTCOL_NUM><SEGCOL_NUM>1</SEGCOL_NUM>
    <PROPERTY>14336</PROPERTY><NAME>OWNER</NAME><TYPE_NUM>1</TYPE_NUM><LENGTH>30</LENGTH><NOT_NULL>0</NOT_NULL>
    <CHARSETID>852</CHARSETID><CHARSETFORM>1</CHARSETFORM><CHARLENGTH>30</CHARLENGTH>
</COL_LIST_ITEM>
     <COL_LIST_ITEM><OBJ_NUM>51944</OBJ_NUM><COL_NUM>2</COL_NUM><INTCOL_NUM>2</INTCOL_NUM><SEGCOL_NUM>2</SEGCOL_NUM>
     <PROPERTY>14336</PROPERTY><NAME>OBJECT_NAME</NAME><TYPE_NUM>1</TYPE_NUM><LENGTH>128</LENGTH><NOT_NULL>0</NOT_NULL>
     <CHARSETID>852</CHARSETID><CHARSETFORM>1</CHARSETFORM><CHARLENGTH>128</CHARLENGTH>
</COL_LIST_ITEM>
<COL_LIST_ITEM>
     <OBJ_NUM>51944</OBJ_NUM><COL_NUM>3</COL_NUM><INTCOL_NUM>3</INTCOL_NUM><SEGCOL_NUM>3</SEGCOL_NUM>
     <PROPERTY>14336</PROPERTY><NAME>SUBOBJECT_NAME</NAME><TYPE_NUM>1</TYPE_NUM><LENGTH>30</LENGTH><NOT_NULL>0</NOT_NULL>
     <CHARSETID>852</CHARSETID><CHARSETFORM>1</CHARSETFORM><CHARLENGTH>30</CHARLENGTH>
</COL_LIST_ITEM>
<COL_LIST_ITEM>
     <OBJ_NUM>51944</OBJ_NUM><COL_NUM>4</COL_NUM><INTCOL_NUM>4</INTCOL_NUM><SEGCOL_NUM>4</SEGCOL_NUM>
     <PROPERTY>14336</PROPERTY><NAME>OBJECT_ID</NAME><TYPE_NUM>2</TYPE_NUM><LENGTH>22</LENGTH><NOT_NULL>0</NOT_NULL>
     <CHARSETID>0</CHARSETID><CHARSETFORM>0</CHARSETFORM><CHARLENGTH>0</CHARLENGTH>
</COL_LIST_ITEM>
<COL_LIST_ITEM>
     <OBJ_NUM>51944</OBJ_NUM><COL_NUM>5</COL_NUM><INTCOL_NUM>5</INTCOL_NUM><SEGCOL_NUM>5</SEGCOL_NUM>
     <PROPERTY>14336</PROPERTY><NAME>DATA_OBJECT_ID</NAME><TYPE_NUM>2</TYPE_NUM><LENGTH>22</LENGTH><NOT_NULL>0</NOT_NULL>
     <CHARSETID>0</CHARSETID><CHARSETFORM>0</CHARSETFORM><CHARLENGTH>0</CHARLENGTH>
</COL_LIST_ITEM>
.
.
.
</COL_LIST></STRMTABLE_T>
</ROW></ROWSET>－－－这是头信息,往下是数据部分了。

< N
PUBLICDUAL

wonder

dlinger是直接编辑dmp就可以看到xml的内容吗？

dlinger

你用ultraedit打开看就行了

swingcoder

expdp eygle/eygle directory=dpdata dumpfile=full.dmp full=y job_name=expfull
时出如下错误是如故?
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 475
ORA-29283: invalid file operation

之前已经用create directory..grant read,write

yxming1677

好文章，学习中。

yudingchu

谢谢分享、

pandzhi

做个记号,有空慢慢看.