来自 技术 2019-04-17 的文章

exp和expdp的filesize参数的使用--导出多个文件

exp和expdp的filesize参数的使用--导出多个文件

在逻辑导出数据时,如果不指定文件大小(注意,0值相当于不指定FILESIZE)值,不管在File参数指定的文件数量是多少,输出都将写入一个文件。

filesize 若导出的数据文件大,应该用该参数,限制文件大小不要超过2g

如:exp userid=lhr/lhr file=/tmp/test1,test2,test3,test4,test5 filesize=2G log=test.log

这样将创建test1.dmp,test2.dmp等,每个文件大小为2g。

EXPDP 命令提供了一个FILESIZE参数,用来指定单个DUMP文件的最大容量,要有效的利用parallel参数,filesize参数必不可少。

举例:某用户对象占用了4G左右的空间,实际导出后的DUMP文件约为3G,我们尝试在导出该用户时指定并行度为4,设置单个文件不超过500M,则语法如下:

$ expdp user/pwd directory=dump_file dumpfile=expdp_20190416_%U.dmp logfile=expdp_20100820.log filesize=500M parallel=4

示例SQL:

expuserid=scott/tigerfile=/tmp/test1,/tmp/test2,/tmp/test3,/tmp/test4,/tmp/test5filesize=1024000log=test.logimpuserid=lhr/lhrFILE=/tmp/test1,/tmp/test2,/tmp/test3,/tmp/test4,/tmp/test5LOG=imp_emp.logFROMUSER=scottTOUSER=lhrTABLES=emp--数据泵示例expdpsystem/lhrSCHEMAS=scottDIRECTORY=DATA_PUMP_DIRDUMPFILE=DATA_PUMP_DIR:expdp_20190416_%U.dmpFILESIZE=1024000impdplhr/lhrSCHEMAS=scottDIRECTORY=DATA_PUMP_DIRDUMPFILE=DATA_PUMP_DIR:expdp_20190416_%U.dmp



[转]FILESIZE参数 – 输出写入到多个导出文件

FILESIZE参数–输出写入到多个导出文件

1.适用于:

甲骨文公司服务器-企业版-版本:8.1.7至10.2

甲骨文公司服务器-个人版-版本:8.1.7至10.2

甲骨文公司服务器-标准版-版本:8.1.7至10.2

本文档中的信息适用于任何平台。

2.目的:

本文档提供当从Oracle数据库导出数据或将数据导入回到Oracle数据库中时有关使用FILESIZE参数信息。

3.范围和应用:

本手册适用于要使用EXPORT实用程序从Oracle数据库中导出数据,并创建多个导出转储文件,而不是一个单一的(通常是非常大)导出转储文件的Oracle8i,Oracle9i以及Oracle10g数据库的用户。手册提供了有关使用FILESIZE参数,典型的错误信息,和一些相关的缺陷与可能的解决方法的信息。

4.简介:

1)默认情况下,输出将数据写入一个出口转存,直至达到最大大小。可以在一个文件中存储的最大值是依赖于您的操作系统。另见:

注:62427.1“2GB或不2GB-文件限制在Oracle”

2)首先介绍Oracle8i,输出支持写入到多个出口文件,输入可以读入多个出口文件。如果你给FILESIZE参数指定一个值(字节的限制),出口将只写入转储文件您指定的字节大小的数据。

3)在Oracle9i及更高版本的服务器上,FILESIZE参数有一个最大的值,这个值等于可以存储在64位(16EB(艾字节)=16384PB(PB级)=16777216TB(TB级)=17179869184GB(千兆字节))的最大值。

4)经典输出客户端(EXP)没有一个真正的转储文件的最佳大小。即使我们只从一个非常大的转储导入一张小表,我们业要通读完整的转储文件。

5)请注意这与Oracle10g的数据泵的客户端(expdp和impdp)不同。如果我们从多个转储文件导入一张小表,我们只能读取数据泵转储文件头,而且我们读取的数据泵主表可能是存储在较后位置的转储文件之一。基于主表中的信息,我们确定该小表处在的转储文件(S),然后我们只读那些特定的转储文件(S)。

6)相比于处理多个小文件,从文件查看点处理一个单一的大型输出转储文件更加困难。因此,250GB的数据,如果需要导出,建议创建多个较小的文件,例如:指定FILESIZE=25G,创建10个规模较小的转储文件。

7)导出到磁带设备时,不使用FILESIZE参数,而使用VOLSIZE参数。有关详情,请参阅:

注:30428.1“Unix系统上的导出到磁带””

8)当导出到一个命名管道,不推荐使用FILESIZE参数。如果使用FILESIZE参数时使用命名管道,请确保您预先为每个出口转存文件创建一个命名管道。有关详情,请参阅:

注:30528.1“使用导出(EXP-2EXP-15),导入(IMP-2IMP-21),或SQL*Loader时的大文件的问题(2GB+)”

5.出口参数的用法:FILESIZE

如果你不指定文件大小(注意,0值相当于不指定FILESIZE)值,不管在File参数指定的文件数量是多少,输出都将写入一个文件。

如果您导出文件所需的空间超过可用的磁盘空间,出口将中止操作,待提供足够的磁盘空间后,输出操作才可以重复并完成。

FILESIZE值可以指定为KB(千字节数)级。例如,FILESIZE=2KB和FILESIZE=2048是相同的。同样,MB指定兆字节(1024*1024)和GB指定千兆字节(1024**3)。

B为字节的简写;该数字不用继续乘以字节大小而获得最终的文件大小(FILESIZE=2048B即是FILESIZE=2048)。

FILESIZE=0(默认)输出写入到一个单一的文件

FILESIZE=1024或:

FILESIZE=1K或:

FILESIZE=1KB输出写入1千字节的文件

FILESIZE=1M或:

FILESIZE=1MB输出写入1兆字节的文件

FILESIZE=1G或:

FILESIZE=1GB,输出写入1千兆字节的文件

当输出写入的数据量超过FILESIZE指定的最大值,输出会从File参数中得到下一个输出文件的名称,如果它已经使用了所有的File参数指定的名称,输出会提示您提供了一个新的输出文件名。

如果输出的数据量不适合提供的文件清单,输出将提示需要更多的文件名。

如果在后台运行的输出程序,确保给输出提供足够的文件名。在等待您提供额外的文件名时输出程序会挂起,而您可能不能发现文件名不够用。

例如:运行一个完整的数据库输出的直接路径和创建750MB输出转储文件:

File:exp.par-------------FILESIZE=750MBFILE=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp,exp_f4.dmpFULL=YDIRECT=YLOG=exp_full.log%expsystem/managerPARFILE=exp.par

注1:当出口分配一个新的出口转储文件,这将记录在在出口日志中。

E.g:...continuingexportintofileexp_f2.dmp...

注2:已指定File参数,但是出口不需要这个文件,则该指定的FILE不会被创建。

例如:在上面的例子,如果输出总额为2GB,然后输出将创建3个文件:

-exp_f1.dmpwithsizeof750Mb-exp_f2.dmpwithsizeof750Mb-exp_f3.dmpwithsizeof500Mb

注3:如果出口需要更多的文件,将数据导出,它会提示一个新的文件名。

例如:在上面的例子,如果出口总额为3.5GB,然后出口将创建4个750MB的文件,并会提示为剩余的500MB数据创建新文件。键入下一个出口转储文件的文件名后,出口将继续下去。

Example:...Exportfile:EXPDAT.DMP>exp_f5.dmp...

注4请注意,File参数指定文件名的命令行语法是:

---命令行模式可能的语法(2例):

E.g:%exp...file=exp_f1.dmpexp_f2.dmpexp_f3.dmpexp_f4.dmp...%exp...file=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp,exp_f4.dmp...

或者在Windows系统(3附例):

D:\>exp...file=(exp_f1.dmpexp_f2.dmpexp_f3.dmpexp_f4.dmp)...D:\>exp...file=(exp_f1.dmp,exp_f2.dmp,exp_f3.dmp,exp_f4.dmp)...D:\>exp...file="exp_f1.dmp,exp_f2.dmp,exp_f3.dmp,exp_f4.dmp"...

或者在Unix系统(3附例):

%exp...file=\(exp_f1.dmpexp_f2.dmpexp_f3.dmpexp_f4.dmp\)...%exp...file=\(exp_f1.dmp,exp_f2.dmp,exp_f3.dmp,exp_f4.dmp\)...%exp...file='exp_f1.dmp,exp_f2.dmp,exp_f3.dmp,exp_f4.dmp'...

6.进口参数:FILESIZE

输入数据时,必须使用导入参数FILESIZE告诉导入最大的出口指定转储文件的大小。FILESIZE值可以指定为KB(千字节数)级。例如,FILESIZE=2KB和FILESIZE=2048是相同的。同样,MB指定兆字节(1024*1024)和GB指定千兆字节(1024**3)。

B为字节的简写;该数字不用继续乘以字节大小而获得最终的文件大小(FILESIZE=2048B即是FILESIZE=2048)。

FILESIZE=0(默认)出口读取一个单一的文件

FILESIZE=1024或:

FILESIZE=1K或:

FILESIZE=1KB出口读取1千字节的文件

FILESIZE=1M或:

FILESIZE=1MB出口读取1兆字节的文件

FILESIZE=1G或:

FILESIZE=1GB,出口读取1千兆字节的文件

例如:从上面创建的出口转储文件运行一个表级别的进口程序。

File:imp.par-------------FILESIZE=750MBFILE=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp,exp_f4.dmpFROMUSER=scottTOUSER=scottTABLES=empLOG=imp_emp.log%impsystem/managerPARFILE=imp.par

注1:如果文件参数(如在输出过程中文件exp_f4.dmp未被创建)中列出的文件太多,这些文件名会被忽略。

注2:如果没有列出的所有文件名,进口将主动要求下一个文件名。

例如如果进口开始指定了exp_f1.dmp,exp_f2.dmp两个文件而没有提到第三个或最后的文件名exp_f3.dmp,进口会提示为剩余数据创建新的文件名。输入正确的文件名后,进口程序将继续下去。

例如:

...Importfile:EXPDAT.DMP>exp_f3.dmp...

7.出口可能的警告和错误:

1)EXP-75:FILESIZE四舍五入式下降

FILESIZE参数指定的值是RECORDLENGTH参数值的倍数。如果这是不正确的,那么FILESIZE参数值将下调自动:

%expsystem/managerFILE=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp,\exp_f4.dmpLOG=exp_f.logFILESIZE=1000m\DIRECT=yRECORDLENGTH=65535FULL=yExport:Release10.2.0.3.0-ProductiononThuDec2017:19:132007Copyright(c)1982,2005,Oracle.Allrightsreserved.Connectedto:OracleDatabase10gEnterpriseEditionRelease10.2.0.3.0–ProductionWiththePartitioning,OracleLabelSecurity,OLAPandDataMiningScoringEngineoptionsEXP-00075:roundingFILESIZEdown,newvalueis1048560000ExportdoneinWE8ISO8859P15charactersetandAL16UTF16NCHARcharactersetAbouttoexporttheentiredatabase......

解决办法:忽略警告或指定FILESIZE参数为RECORDLENGTH的倍数:

%expsystem/managerFILE=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp,\exp_f4.dmpLOG=exp_f.logFILESIZE=1048560000\DIRECT=yRECORDLENGTH=65535FULL=y

注1:确保进口时也使用FILESIZE新指定值。

注2:有关参数RECORDLENGTH的详细信息,请参阅:

注3:155477.1“直接参数:常规路径导出与直接路径导出的比较”

2)EXP-73:转储文件太小

如果FILESIZE参数值小于RECORDLENGTH参数值,将产生一个错误。例如如果出口开始于RECORDLENGTH=8192和FILESIZE=4KB。

%expsystem/managerFILE=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp,\exp_f4.dmpLOG=exp_f.logFILESIZE=64k\DIRECT=yRECORDLENGTH=65535FULL=yExport:Release10.2.0.3.0-ProductiononThuDec2017:39:122007Copyright(c)1982,2005,Oracle.Allrightsreserved.Connectedto:OracleDatabase10gEnterpriseEditionRelease10.2.0.3.0–ProductionWiththePartitioning,OracleLabelSecurity,OLAPandDataMiningScoringEngineoptionsEXP-00075:roundingFILESIZEdown,newvalueis65535EXP-00073:dumpfilesizetoosmallEXP-00000:Exportterminatedunsuccessfully

解决方案:FILESIZE参数,如指定一个较大的值:

%expsystem/managerFILE=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp,\exp_f4.dmpLOG=exp_f.logFILESIZE=640m\DIRECT=yRECORDLENGTH=65535FULL=y

3)EXP-2:错误写入导出文件

如果没有足够的空间供出口写入到转储文件,或另一个进程阻止出口写入转储文件,出口会因为如下一些错误中止:

...EXP-00030:UnexpectedEnd-Of-Fileencounteredwhilereadinginput..exportingtableEMP_LONGerrorclossingexportfileEXP-00002:ErrorinwritingtoexportfileEXP-00002:ErrorinwritingtoexportfileEXP-00000:Exportterminatedunsuccessfully

解决方法:确保有足够的自由空间来创建文件,确保该磁盘没有任何错误,确保其他进程(如防病毒扫描)不会阻止出口写入文件,并重新运行出口。

8.导入时可能的警告和错误:

1)IMP-46:使用出口文件FILESIZE值

如果没有值指定在进口程序中的FILESIZE参数,将产生一个警告。然而,进口程序将继续:

%impsystem/managerFILE=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp\exp_f4.dmpLOG=imp_emp.log\FROMUSER=scottTOUSER=scottTABLES=empImport:Release10.2.0.3.0-ProductiononThuDec2018:00:482007Copyright(c)1982,2005,Oracle.Allrightsreserved.Connectedto:OracleDatabase10gEnterpriseEditionRelease10.2.0.3.0–ProductionWiththePartitioning,OracleLabelSecurity,OLAPandDataMiningScoringEngineoptionsExportfilecreatedbyEXPORT:V10.02.01viadirectpathimportdoneinWE8ISO8859P15charactersetandAL16UTF16NCHARcharactersetIMP-00046:usingFILESIZEvaluefromexportfileof786432000...Importterminatedsuccessfullywithwarnings.

解决办法:忽略警告,下一次从这个出口转储文件集输入时,指定正确的值FILESIZE参数,如:

%impsystem/managerFILE=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp\exp_f4.dmpLOG=imp_emp.logFILESIZE=750m\FROMUSER=scottTOUSER=scottTABLES=emp

2)IMP-47:意外的文件序列号

如果以错误的顺序列出文件名,系统报告错误,进口程序将中止,例如:

%impsystem/managerFILE=exp_f3.dmp,exp_f2.dmp,exp_f1.dmp\exp_f4.dmpLOG=imp_emp.logFILESIZE=750m\FROMUSER=scottTOUSER=scottTABLES=empImport:Release10.2.0.3.0-ProductiononThuDec2018:05:042007Copyright(c)1982,2005,Oracle.Allrightsreserved.Connectedto:OracleDatabase10gEnterpriseEditionRelease10.2.0.3.0–ProductionWiththePartitioning,OracleLabelSecurity,OLAPandDataMiningScoringEngineoptionsExportfilecreatedbyEXPORT:V10.02.01viadirectpathimportdoneinWE8ISO8859P15charactersetandAL16UTF16NCHARcharactersetIMP-00047:unexpectedfilesequencenumber;expected1butfound3IMP-00132:firstfileinthemulti-fileexportisexp_f1.dmpIMP-00000:ImportterminatedunsuccessfullyOr:%impsystem/managerFILE=exp_f1.dmp,exp_f3.dmp,exp_f2.dmp\exp_f4.dmpLOG=imp_emp.logFILESIZE=750m\FROMUSER=scottTOUSER=scottTABLES=empImport:Release10.2.0.3.0-ProductiononThuDec2018:13:392007Copyright(c)1982,2005,Oracle.Allrightsreserved.Connectedto:OracleDatabase10gEnterpriseEditionRelease10.2.0.3.0–ProductionWiththePartitioning,OracleLabelSecurity,OLAPandDataMiningScoringEngineoptionsExportfilecreatedbyEXPORT:V10.02.01viadirectpathimportdoneinWE8ISO8859P15charactersetandAL16UTF16NCHARcharactersetIMP-00047:unexpectedfilesequencenumber;expected2butfound3IMP-00132:firstfileinthemulti-fileexportisexp_f1.dmpIMP-00008:unrecognizedstatementintheexportfile:...

解决方案:以正确的顺序指定转储文件,例如:

%impsystem/managerFILE=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp\exp_f4.dmpLOG=imp_emp.logFILESIZE=750m\FROMUSER=scottTOUSER=scottTABLES=emp

3)IMP-40:FILESIZE与出口程序使用的值不匹配

如果错误的FILESIZE值在进口过程中被指定(例如指定FILESIZE=75m,而非FILESIZE=750m),将报告错误:

%impsystem/managerFILE=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp\exp_f4.dmpLOG=imp_emp.logFILESIZE=75m\FROMUSER=scottTOUSER=scottTABLES=empImport:Release10.2.0.3.0-ProductiononThuDec2018:18:262007Copyright(c)1982,2005,Oracle.Allrightsreserved.Connectedto:OracleDatabase10gEnterpriseEditionRelease10.2.0.3.0-ProductionWiththePartitioning,OracleLabelSecurity,OLAPandDataMiningScoringEngineoptionsExportfilecreatedbyEXPORT:V10.02.01viadirectpathimportdoneinWE8ISO8859P15charactersetandAL16UTF16NCHARcharactersetIMP-00040:FILESIZEdoesnotmatchthevalueusedforexport:786432000IMP-00000:Importterminatedunsuccessfully

解决方案:重新启动进口,并给FILESIZE参数指定正确的值,如:

%impsystem/managerFILE=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp\exp_f4.dmpLOG=imp_emp.logFILESIZE=750m\FROMUSER=scottTOUSER=scottTABLES=emp

4)IMP-2:未能打开读取文件

如果你错误地指定了一个不正确的文件名,进口将提示输入正确的文件名:

%impsystem/managerFILE=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp\exp_f4.dmLOG=imp_emp.logFILESIZE=750m\FROMUSER=scottTOUSER=scottTABLES=empImport:Release10.2.0.3.0-ProductiononThuDec2018:21:022007Copyright(c)1982,2005,Oracle.Allrightsreserved.Connectedto:OracleDatabase10gEnterpriseEditionRelease10.2.0.3.0-ProductionWiththePartitioning,OracleLabelSecurity,OLAPandDataMiningScoringEngineoptionsExportfilecreatedbyEXPORT:V10.02.01viadirectpathimportdoneinWE8ISO8859P15charactersetandAL16UTF16NCHARcharactersetIMP-00002:failedtoopenexp_f4.dmforreadImportfile:EXPDAT.DMP>

解决方案:指定正确的文件名,或者以正确的名称重新启动进口转储文件:

...Importfile:EXPDAT.DMP>exp_f4.dmp...

5)IMP-48:文件头不匹配

如果你错误地指定了一个错误的文件名,可能发生以下错误:

%impsystem/managerFILE=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp\exp_f.logLOG=imp_emp.logFILESIZE=750m\FROMUSER=scottTOUSER=scottTABLES=empImport:Release10.2.0.3.0-ProductiononThuDec2018:28:262007Copyright(c)1982,2005,Oracle.Allrightsreserved.Connectedto:OracleDatabase10gEnterpriseEditionRelease10.2.0.3.0–ProductionWiththePartitioning,OracleLabelSecurity,OLAPandDataMiningScoringEngineoptionsExportfilecreatedbyEXPORT:V10.02.01viadirectpathimportdoneinWE8ISO8859P15charactersetandAL16UTF16NCHARcharactersetIMP-00048:mismatchedfileheaderIMP-00008:unrecognizedstatementintheexportfile:IMP-00000:Importterminatedunsuccessfully--orimportabortswith:...IMP-00048:mismatchedfileheaderIMP-00009:abnormalendofexportfileIMP-00000:Importterminatedunsuccessfully

解决方案:重新启动的进口,并指定一系列正确的转储文件的名称,如:

%impsystem/managerFILE=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp\exp_f4.dmpLOG=imp_emp.logFILESIZE=750m\FROMUSER=scottTOUSER=scottTABLES=emp

Parameter FILESIZE - Make Export Write To Multiple Export Files (文档 ID 290810.1)

In this Document

PurposeScopeDetails1. Introduction.2. Usage of Export Parameter: FILESIZE3. Usage of Import Parameter: FILESIZE4. Possible Warnings and Errors upon Export.5. Possible Warnings and Errors upon Import.6. Known Defects.References

APPLIES TO:Oracle Database - Enterprise Edition - Version 8.1.7.0 to 11.2.0.4 [Release 8.1.7 to 11.2]Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Cloud Machine - Version N/A and laterOracle Cloud Infrastructure - Database Service - Version N/A and laterOracle Database Backup Service - Version N/A and laterInformation in this document applies to any platform.***Checked for relevance on 01-Apr-2015***NOTE: In the images and/or the document content below, the user information and data used represents fictitious data. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

PURPOSE

This document provides information about the usage of theFILESIZEparameter when exporting data from an Oracle database or importing data back into an Oracle database.

SCOPE

The article is intended for users of the Oracle8i, Oracle9i, and Oracle10g database who wish to use the EXPORT utility to export data from an Oracle database and create multiple export dump files, rather than one single (and usually very large) export dump file. The article gives information about the usage of the FILESIZE parameter, typical error messages, and some related defects with possible workarounds.

NOTE:Original Export is desupported for general use as of Oracle Database 11g. The only supported use of original Export in Oracle Database 11g is backward migration of XMLType data to Oracle Database 10g release 2 (10.2) or earlier. Therefore, Oracle recommends that you use the new Data Pump Export and Import utilities, except in the following situations which require original Export and Import:Please refer to:http://docs.oracle.com/database/121/SUTIL/original_export.htm#SUTIL3634

DETAILS

1. Introduction.
    By default, an export writes data to one export dumpfile until the maximum size is reached. The maximum value that can be stored in a file is dependent on your operating system. See also:Note 62427.1- 2Gb or Not 2Gb - File limits in OracleStarting with Oracle8i, export supports writing to multiple export files, and Import can read from multiple export files. If you specify a value (byte limit) for the FILESIZE parameter, Export will write only the number of bytes you specify to each dump file.In Oracle9i and higher, the FILESIZE parameter has a maximum value equal to the maximum value that can be stored in 64 bits (16 EB (exabyte) = 16384 PB (petabyte) = 16777216 TB (terabyte) = 17179869184 Gb (gigabyte)).With the classic export client (exp) there is not a real optimal size for the dumpfiles. Even if we have to import one small table from a very large dumpfile, we have to read through the complete dumpfile.Note that this is different with Oracle10g's Data Pump clients (expdp and impdp). If we have to import one small table from multiple dumpfiles, we only read the headers of the Data Pump dumpfiles, and we read the Data Pump Master Table which is stored in one of the last dumpfiles. Based on the information in the master table we determine in which dumpfile(s) the small table is located, and then we read only those specific dumpfile(s).From file handling point-of-view one single large export dumpfile is more difficult to handle than multiple smaller files. Therefore if 250 Gb of data needs to be exported, it is recommended to create multiple smaller files, e.g. specify FILESIZE=25G to create 10 smaller dumpfiles.When exporting to a tape device, do not use the FILESIZE parameter, but use the VOLSIZE parameter instead. For details, see also:Note 30428.1- Exporting to Tape on Unix SystemWhen exporting to a named pipe, it is not recommended to use the FILESIZE parameter. When the FILESIZE parameter is used in combination with a named pipe, ensure that you pre-create one named pipe for each export dumpfile. For details, see also:Note 30528.1- Large File Issues (2Gb+) when Using Export (EXP-2 EXP-15), Import (IMP-2 IMP-21), or SQL*Loader

    2. Usage of Export Parameter: FILESIZE

    If you do not specify a value for FILESIZE (note that a value of 0 is equivalent to not specifying FILESIZE), then Export will write to only one file, regardless of the number of files specified in the FILE parameter.If the space requirements of your export file exceed the available disk space, Export will abort, and you will have to repeat the Export after making sufficient disk space available.

    The FILESIZE value can be specified as a number followed by KB (number of kilobytes). For example, FILESIZE=2KB is the same as FILESIZE=2048. Similarly, MB specifies megabytes (1024 * 1024) and GB specifies gigabytes (1024**3).'B' remains the shorthand for bytes; the number is not multiplied to obtain the final file size (FILESIZE=2048B is the same as FILESIZE=2048).

    FILESIZE=0 (default) export writes to one single fileFILESIZE=1024or:FILESIZE=1Kor:FILESIZE=1KB causes export to write to 1 kilobyte filesFILESIZE=1M or:FILESIZE=1MB causes export to write to 1 Megabyte filesFILESIZE=1G or:FILESIZE=1GB causes export to write to 1 Gigabyte files

    When the amount of data Export must write, exceeds the maximum value you specified for FILESIZE, it will get the name of the next export file from the FILE parameter or, if it has used all the names specified in the FILE parameter, it will prompt you to provide a new export filename.

    If the amount of data exported does not fit in the list of files provided, export will prompt for more filenames.Ensure to provide enough filenames to the export if running the export in the background. The export may hang while waiting for you to provide it with additional filenames which you will not be able to do.

    Example: run a direct path full database export and create export dumpfiles with a size of 750 Mb:

    File:exp.par-------------FILESIZE=750MBFILE=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp,exp_f4.dmpFULL=YDIRECT=YLOG=exp_full.log%expsystem/<password> PARFILE=exp.par

    Remark 1. When export allocates a new export dumpfile, this will be logged in the export logfile, e.g.:

    ...continuing export into file exp_f2.dmp...

    Remark 2.Filenames that have been specified with the FILE parameter, and that are not needed for this export, will not be created.E.g.: in the example above, if the total export is 2 Gb, then export will create 3 files:- exp_f1.dmp with size of 750 Mb- exp_f2.dmp with size of 750 Mb- exp_f3.dmp with size of 500 Mb

    Remark 3. If export needs more files to export the data, it will prompt for a new filename.E.g.: in the example above, if the total export is 3.5 Gb, then export will create 4 files with size of 750 Mb, and will prompt for a new filename for the remaining 500 Mb of data. After typing a filename for the next export dumpfile, export will continue. Example:

    ...Export file: EXPDAT.DMP > exp_f5.dmp...

    Remark 4. Note that the command line syntax to specify filenames for the FILE parameter is:

    -- possible syntax for Command Line mode (2 examples):% exp...file=exp_f1.dmpexp_f2.dmpexp_f3.dmpexp_f4.dmp...% exp...file=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp,exp_f4.dmp...-- oronWindows (3 additional examples):D:\> exp...file=(exp_f1.dmpexp_f2.dmpexp_f3.dmpexp_f4.dmp)...D:\>exp...file=(exp_f1.dmp,exp_f2.dmp,exp_f3.dmp,exp_f4.dmp)...D:\>exp...file="exp_f1.dmp,exp_f2.dmp,exp_f3.dmp,exp_f4.dmp"...-- oronUnix (3 additional examples):% exp...file=\(exp_f1.dmpexp_f2.dmpexp_f3.dmpexp_f4.dmp\)...% exp...file=\(exp_f1.dmp,exp_f2.dmp,exp_f3.dmp,exp_f4.dmp\)...% exp...file='exp_f1.dmp,exp_f2.dmp,exp_f3.dmp,exp_f4.dmp'...

    3. Usage of Import Parameter: FILESIZE

    Upon import, you must use the Import parameter FILESIZE to tell Import the maximum dump file size you specified on export. The FILESIZE value can be specified as a number followed by KB (number of kilobytes). For example, FILESIZE=2KB is the same as FILESIZE=2048. Similarly, MB specifies megabytes (1024 * 1024) and GB specifies gigabytes (1024**3).'B' remains the shorthand for bytes; the number is not multiplied to obtain the final file size (FILESIZE=2048B is the same as FILESIZE=2048).

    FILESIZE=0 (default) export reads from one single fileFILESIZE=1024 or:FILESIZE=1K or:FILESIZE=1KB causes export to read from 1 kilobyte filesFILESIZE=1M or:FILESIZE=1MB causes export to read from 1 Megabyte filesFILESIZE=1G or:FILESIZE=1GB causes export to read from 1 Gigabyte files

    Example: to run a table level import from the export dumpfiles created above.

    File:imp.par-------------FILESIZE=750MBFILE=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp,exp_f4.dmpFROMUSER=scottTOUSER=scottTABLES=empLOG=imp_emp.log%impsystem/<password> PARFILE=imp.par

    Remark 1. If too many files are listed for the FILE parameter (e.g. file exp_f4.dmp was not created during export), those filenames will be ignored.Remark 2. If not all filenames are listed, import will ask for the next filename.E.g. if import was started with FILE=exp_f1.dmp,exp_f2.dmp and the third and final filename exp_f3.dmp was not mentioned, import will prompt for a new filename for the remaining data. After typing the correct filename, import will continue. Example:

    ...Import file: EXPDAT.DMP > exp_f3.dmp...

    4. Possible Warnings and Errors upon Export.

    4.1.EXP-75: rounding FILESIZE downThe value specified for the FILESIZE parameter has to be a multiple of the value of RECORDLENGTH parameter. If this is not true, then the value of the FILESIZE parameter will be rounded down automatically:

    % exp system/<password> FILE=exp_f1.dmp, exp_f2.dmp, exp_f3.dmp, \exp_f4.dmp LOG=exp_f.log FILESIZE=1000m\DIRECT=y RECORDLENGTH=65535 FULL=yExport: Release 10.2.0.3.0 - Production on Thu Dec 20 17:19:13 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - ProductionWith the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine optionsEXP-00075: rounding FILESIZE down, new value is 1048560000Export done in WE8ISO8859P15 character set and AL16UTF16 NCHAR character setAbout to export the entire database ......

    Solution: ignore the warning or specify a multiple of the recordlength for the FILESIZE parameter, e.g.:

    %expsystem/<password> FILE=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp,\exp_f4.dmp LOG=exp_f.logFILESIZE=1048560000\DIRECT=yRECORDLENGTH=65535FULL=y

    Remark 1. Ensure that the new value for FILESIZE is also used upon import.Remark 2. For details about parameter RECORDLENGTH, see also:Note 155477.1- Parameter DIRECT: Conventional Path Export Versus Direct Path Export

    4.2. EXP-73: dump file size too smallIf the value of the FILESIZE parameter is smaller than the value of the RECORDLENGTH parameter, an error will be produced. E.g. If the export is started with RECORDLENGTH=8192 and FILESIZE=4KB

    % exp system/<password> FILE=exp_f1.dmp, exp_f2.dmp, exp_f3.dmp, \exp_f4.dmp LOG=exp_f.log FILESIZE=64k \DIRECT=y RECORDLENGTH=65535 FULL=yExport: Release 10.2.0.3.0 - Production on Thu Dec 20 17:39:12 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - ProductionWith the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine optionsEXP-00075: rounding FILESIZE down, new value is 65535EXP-00073: dump file size too smallEXP-00000: Export terminated unsuccessfully

    Solution: Specify a larger value for the FILESIZE parameter, e.g.:

    %expsystem/<password> FILE=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp,\exp_f4.dmpLOG=exp_f.logFILESIZE=640m\DIRECT=yRECORDLENGTH=65535FULL=y

    4.3. EXP-2: Error in writing to export fileIfthere is insufficient space for export to write to the dumpfile, or another process prevents export to write to the dumpfile, then export may also abort with the following errors:

    ...EXP-00030: Unexpected End-Of-File encountered while reading input.. exporting table EMP_LONG error clossing export fileEXP-00002: Error in writing to export fileEXP-00002: Error in writing to export fileEXP-00000: Export terminated unsuccessfully

    Solution:ensure that there is enough free space to create the files, ensure that the disk does not have any errors, ensure that other processes (like anti-virus scanners) are not preventing export to write to the file, andre-run the export.

    5. Possible Warnings and Errors upon Import.

    5.1. IMP-46: using FILESIZE value from export fileIf no value is specified for the FILESIZE parameter during the import, a warning will be produced. However, import will continue:

    % imp system/<password> FILE=exp_f1.dmp, exp_f2.dmp, exp_f3.dmp\exp_f4.dmp LOG=imp_emp.log\FROMUSER=scott TOUSER=scott TABLES=empImport: Release 10.2.0.3.0 - Production on Thu Dec 20 18:00:48 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - ProductionWith the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine optionsExport file created by EXPORT:V10.02.01 via direct pathimport done in WE8ISO8859P15 character set and AL16UTF16 NCHAR character setIMP-00046: using FILESIZE value from export file of 786432000...Import terminated successfully with warnings.

    Solution: Ignore the warning, and next timewhen importing from this export dumpfile set, specify the correctvalue for the FILESIZE parameter, e.g.:

    %impsystem/<password> FILE=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp\exp_f4.dmpLOG=imp_emp.logFILESIZE=750m \FROMUSER=scott TOUSER=scott TABLES=emp

    5.2. IMP-47: unexpected file sequence numberIf the filenames are listed in the wrong order, an error will be reported and import will abort, e.g.:

    % imp system/<password> FILE=exp_f3.dmp, exp_f2.dmp, exp_f1.dmp \exp_f4.dmp LOG=imp_emp.log FILESIZE=750m \FROMUSER=scott TOUSER=scott TABLES=empImport: Release 10.2.0.3.0 - Production on Thu Dec 20 18:05:04 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - ProductionWith the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine optionsExport file created by EXPORT:V10.02.01 via direct pathimport done in WE8ISO8859P15 character set and AL16UTF16 NCHAR character setIMP-00047: unexpected file sequence number; expected 1 but found 3IMP-00132: first file in the multi-file export is exp_f1.dmpIMP-00000: Import terminated unsuccessfully

    or:

    % imp system/<password> FILE=exp_f1.dmp, exp_f3.dmp, exp_f2.dmp \exp_f4.dmp LOG=imp_emp.log FILESIZE=750m \FROMUSER=scott TOUSER=scott TABLES=empImport: Release 10.2.0.3.0 - Production on Thu Dec 20 18:13:39 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - ProductionWith the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine optionsExport file created by EXPORT:V10.02.01 via direct pathimport done in WE8ISO8859P15 character set and AL16UTF16 NCHAR character setIMP-00047: unexpected file sequence number; expected 2 but found 3IMP-00132: first file in the multi-file export is exp_f1.dmpIMP-00008: unrecognized statement in the export file:...

    Solution:Specify the dumpfiles in the correct order, e.g.:

    %impsystem/<password> FILE=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp\exp_f4.dmpLOG=imp_emp.logFILESIZE=750m\FROMUSER=scottTOUSER=scottTABLES=emp

    5.3. IMP-40:FILESIZE does not match the value used for exportIf a wrong value for FILESIZE is specified during import (e.g. specify FILESIZE=75m instead of FILESIZE=750m), an error will be reported:

    % imp system/<password> FILE=exp_f1.dmp, exp_f2.dmp, exp_f3.dmp \exp_f4.dmp LOG=imp_emp.log FILESIZE=75m \FROMUSER=scott TOUSER=scott TABLES=empImport: Release 10.2.0.3.0 - Production on Thu Dec 20 18:18:26 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - ProductionWith the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine optionsExport file created by EXPORT:V10.02.01 via direct pathimport done in WE8ISO8859P15 character set and AL16UTF16 NCHAR character setIMP-00040: FILESIZE does not match the value used for export: 786432000IMP-00000: Import terminated unsuccessfully

    Solution: Restart the import and specify a correct value for the FILESIZE parameter, e.g.:

    %impsystem/<password> FILE=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp\exp_f4.dmpLOG=imp_emp.logFILESIZE=750m\FROMUSER=scottTOUSER=scottTABLES=emp

    5.4. IMP-2: failed to open file for readIfyou specify an incorrect filename by mistake, import will prompt for the correct filename:

    % imp system/<password> FILE=exp_f1.dmp, exp_f2.dmp, exp_f3.dmp \exp_f4.dm LOG=imp_emp.log FILESIZE=750m \FROMUSER=scott TOUSER=scott TABLES=empImport: Release 10.2.0.3.0 - Production on Thu Dec 20 18:21:02 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - ProductionWith the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine optionsExport file created by EXPORT:V10.02.01 via direct pathimport done in WE8ISO8859P15 character set and AL16UTF16 NCHAR character setIMP-00002: failed to open exp_f4.dm for readImport file: EXPDAT.DMP >

    Solution: specify the correct filename, or alternatively re-start the import with the correct names for the dumpfiles, e.g.:

    ...Importfile:EXPDAT.DMP> exp_f4.dmp...

    5.5. IMP-48: mismatched file headerIf you specify a wrong filename by mistake, the following errors can occur:

    % imp system/<password> FILE=exp_f1.dmp, exp_f2.dmp, exp_f3.dmp \exp_f.log LOG=imp_emp.log FILESIZE=750m \FROMUSER=scott TOUSER=scott TABLES=empImport: Release 10.2.0.3.0 - Production on Thu Dec 20 18:28:26 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - ProductionWith the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine optionsExport file created by EXPORT:V10.02.01 via direct pathimport done in WE8ISO8859P15 character set and AL16UTF16 NCHAR character setIMP-00048: mismatched file headerIMP-00008: unrecognized statement in the export file:IMP-00000: Import terminated unsuccessfully-- or import aborts with:...IMP-00048: mismatched file headerIMP-00009: abnormal end of export fileIMP-00000: Import terminated unsuccessfully

    Solution: Restart the import and specify the correct set of dumpfile names, e.g.:

    %impsystem/<password> FILE=exp_f1.dmp,exp_f2.dmp,exp_f3.dmp\exp_f4.dmpLOG=imp_emp.logFILESIZE=750m\FROMUSER=scottTOUSER=scottTABLES=emp

    6. Known Defects.

    Bug 2040507- FILESIZE PARAMETER SPECIFIED WITH EXP ON OS/390 NOT RECOGNIZED ON UNIX IMP-Symptoms: IMP-46 andIMP-40 are possible attempting to import MVS export to another platform-Releases: 9.0.1.5 and lower-Fixed in: 9.2.0.1 and higher; for IBM z/OS (OS/390) a fix on top of 9.0.1.4.0 is available withPatch 3253419-Workaround: run export on a client machine with different platform, using SQL*Net to connect.

    Bug 1076041- EXPORTS THAT USE FILESIZE>4GB FAIL WITH EXP-2-Symptoms: EXP-2 exporting to multiple dump files with FILESIZE >= 4Gb-Releases: 8.1.5.x and 8.1.6.x-Fixed in: 8.1.7.0 and higher-Workaround: do not specify 4Gb filesize, but use lower value.

    Bug 1522646 - INCONSISTENT BEHAVIOR OF HANDLING FILESIZE PARAMETER (not a public bug)-Symptoms: No error if value for FILESIZE was too low (e.g. FILESIZE=1024)-Releases: 8.1.7.4 and lower-Fixed in: 9.0.1.1. and higher-Workaround: specify a valid value for the FILESIZE parameter

    REFERENCESBUG:2040507- FILESIZE PARAMETER SPECIFIED WITH EXP ON OS/390 NOT RECOGNIZED ON UNIX IMPNOTE:155477.1- Parameter DIRECT: Conventional Path Export Versus Direct Path ExportNOTE:30428.1- Exporting To Tape On UNIX SystemsNOTE:30528.1- Large File Issues (2GB+) when Using Export (EXP-2 EXP-15) Import (IMP-2 IMP-21) Or SQL*LoaderNOTE:62427.1- 2Gb or Not 2Gb - File limits in Oracle

    How to Export to Multiple Dumpfiles Using Datapump Export and Import Again (文档 ID 778943.1)

    In this Document

    GoalSolution

    APPLIES TO:

    Oracle Database - Enterprise Edition - Version 10.1.0.2 and laterInformation in this document applies to any platform.***Checked for relevance on 25-Jun-2013***

    GOAL

    You are exporting a very large database, schemas or any other database objects and for whatever reason you would like to split the .dmp file created into smaller and more manageable export .dmp files. You are using datapump export.

    SOLUTION

    To export to multiple .dmp files using datapump you can use the DUMPFILE datapump export parameter and specify more than one file for export to write to or you can use a template with a substitution variable in the file name to create multiple files with names automatically assigned.Syntax and DescriptionDUMPFILE=[directory_object:]file_name [, ...]The directory_object is optional if one has already been established by the DIRECTORY parameter. If you supply a value here, it must be a directory object that already exists and that you have access to. A database directory object that is specified as part of the DUMPFILE parameter overrides a value specified by the DIRECTORY parameter or by the default directory object.You can supply multiple file_name specifications as a comma-delimited list or in separate DUMPFILE parameter specifications. If no extension is given for the filename, then Export uses the default file extension of .dmp. The filenames can contain a substitution variable (%U), which implies that multiple files may be generated. The substitution variable is expanded in the resulting filenames into a 2-digit, fixed-width, incrementing integer starting at 01 and ending at 99. If a file specification contains two substitution variables, both are incremented at the same time. For example, exp%Uaa%U.dmp would resolve to exp01aa01.dmp, exp02aa02.dmp, and so forth.If the FILESIZE parameter is specified, each dump file will have a maximum of that size in bytes and be nonextensible. If more space is required for the dump file set and a template with a substitution variable (%U) was supplied, a new dump file is automatically created of the size specified by FILESIZE, if there is room on the device.As each file specification or file template containing a substitution variable is defined, it is instantiated into one fully qualified filename and Export attempts to create it. The file specifications are processed in the order in which they are specified. If the job needs extra files because the maximum file size is reached, or to keep parallel workers active, then additional files are created if file templates with substitution variables were specified.Although it is possible to specify multiple files using the DUMPFILE parameter, the export job may only require a subset of those files to hold the exported data. The dump file set displayed at the end of the export job shows exactly which files were used. It is this list of files that is required in order to perform an import operation using this dump file set.In the following example, we will export the SCOTT schema and will use a template with a substitution variable (%U) and the FILESIZE parameter to create dump file of 500K size. We will then use these sames files and name format to import the schema back into the database.EXPORT TO MULTIPLE FILES

    > expdp system/manager SCHEMAS=scott DIRECTORY=dpump_dir1 DUMPFILE=dpump_dir1:exp%U.dmp FILESIZE=500KExport: Release 10.2.0.3.0 - 64bit Production on Wednesday, 28 January, 2009 20:54:23Copyright (c) 2003, 2005, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining optionsFLASHBACK automatically enabled to preserve database integrity.Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** SCHEMAS=scott DIRECTORY=dpump_dir1 DUMPFILE=dpump_dir1:exp%U.dmp FILESIZE=500KEstimate in progress using BLOCKS method...Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATATotal estimation using BLOCKS method: 768 KBProcessing object type SCHEMA_EXPORT/USERProcessing object type SCHEMA_EXPORT/SYSTEM_GRANTProcessing object type SCHEMA_EXPORT/ROLE_GRANTProcessing object type SCHEMA_EXPORT/DEFAULT_ROLEProcessing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMAProcessing object type SCHEMA_EXPORT/TABLE/TABLEProcessing object type SCHEMA_EXPORT/TABLE/INDEX/INDEXProcessing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINTProcessing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICSProcessing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINTProcessing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS. . exported "SCOTT"."IND_TABLE" 452.5 KB 2230 rows. . exported "SCOTT"."DEPT" 5.656 KB 4 rows. . exported "SCOTT"."EMP" 7.820 KB 14 rows. . exported "SCOTT"."SALGRADE" 5.585 KB 5 rows. . exported "SCOTT"."BONUS" 0 KB 0 rowsMaster table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded******************************************************************************Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:/testcases/rvazquez/exp01.dmp/testcases/rvazquez/exp02.dmpJob "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at 20:56:33

    After export completes, we can see that 2 .dmp files were created automatically.

    [rmtdcsol1]/testcases/rvazquez> ls -ltotal 1400-rw-r----- 1 grdbms grdbms 512000 Jan 28 20:56 exp01.dmp-rw-r----- 1 grdbms grdbms 192512 Jan 28 20:56 exp02.dmp

    IMPORT MULTIPLE FILES

    NOTE:For Datapump import using multiple dumpfiles, you need to have all the files available and not just some of them, also when performing a limited import only.

    We can use the same syntax to run the import. This time we do not need the FILESIZE parameter. FILESIZE is only needed for export datapump. We have dropped the SCOTT user prior to execution of import datapump.

    > impdp system/manager SCHEMAS=scott DIRECTORY=dpump_dir1 DUMPFILE=dpump_dir1:exp%U.dmpImport: Release 10.2.0.3.0 - 64bit Production on Wednesday, 28 January, 2009 21:17:17Copyright (c) 2003, 2005, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining optionsMaster table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloadedStarting "SYSTEM"."SYS_IMPORT_SCHEMA_01": system/******** SCHEMAS=scott DIRECTORY=dpump_dir1 DUMPFILE=dpump_dir1:exp%U.dmpProcessing object type SCHEMA_EXPORT/USERProcessing object type SCHEMA_EXPORT/SYSTEM_GRANTProcessing object type SCHEMA_EXPORT/ROLE_GRANTProcessing object type SCHEMA_EXPORT/DEFAULT_ROLEProcessing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMAProcessing object type SCHEMA_EXPORT/TABLE/TABLEProcessing object type SCHEMA_EXPORT/TABLE/TABLE_DATA. . imported "SCOTT"."IND_TABLE" 452.5 KB 2230 rows. . imported "SCOTT"."DEPT" 5.656 KB 4 rows. . imported "SCOTT"."EMP" 7.820 KB 14 rows. . imported "SCOTT"."SALGRADE" 5.585 KB 5 rows. . imported "SCOTT"."BONUS" 0 KB 0 rowsProcessing object type SCHEMA_EXPORT/TABLE/INDEX/INDEXProcessing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINTProcessing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICSProcessing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINTProcessing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICSJob "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully completed at 21:17:54

    Please refer to:Oracle® Database Utilities 10g Release 2 (10.2) Part Number B14215-01Oracle® Database Utilities 11g Release 2 (11.2) Part Number E22490-05



    About Me

    ........................................................................................................................

    ● 本文作者:小麦苗,部分内容整理自网络,若有侵权请联系小麦苗删除

    ● 本文在itpub(http://blog.itpub.net/26736162)、博客园(http://www.cnblogs.com/lhrbest)和个人weixin公众号(xiaomaimiaolhr)上有同步更新

    ● 本文itpub地址:http://blog.itpub.net/26736162

    ● 本文博客园地址:http://www.cnblogs.com/lhrbest

    ● 本文pdf版、个人简介及小麦苗云盘地址:http://blog.itpub.net/26736162/viewspace-1624453/

    ● 数据库笔试面试题库及解答:http://blog.itpub.net/26736162/viewspace-2134706/

    ● DBA宝典今日头条号地址:http://www.toutiao.com/c/user/6401772890/#mid=1564638659405826

    ........................................................................................................................

    ● QQ群号:230161599(满)、618766405

    ● weixin群:可加我weixin,我拉大家进群,非诚勿扰

    ● 联系我请加QQ好友(646634621),注明添加缘由

    ● 于 2019-04-01 06:00 ~ 2019-04-30 24:00 在魔都完成

    ● 最新修改时间:2019-04-01 06:00 ~ 2019-04-30 24:00

    ● 文章内容来源于小麦苗的学习笔记,部分整理自网络,若有侵权或不当之处还请谅解

    ● 版权所有,欢迎分享本文,转载请保留出处

    ........................................................................................................................

    ● 小麦苗的微店:https://weidian.com/s/793741433?wfr=c&ifr=shopdetail

    ● 小麦苗出版的数据库类丛书:http://blog.itpub.net/26736162/viewspace-2142121/

    ● 小麦苗OCP、OCM、高可用网络班:http://blog.itpub.net/26736162/viewspace-2148098/

    ● 小麦苗腾讯课堂主页:https://lhr.ke.qq.com/

    ........................................................................................................................

    使用weixin客户端扫描下面的二维码来关注小麦苗的weixin公众号(xiaomaimiaolhr)及QQ群(DBA宝典)、添加小麦苗weixin,学习最实用的数据库技术。

    ........................................................................................................................

    标签:   32GTensorFlo      u3d python   
    上一篇:没有了
    下一篇:没有了