资源描述：
《Oracle备份恢复之13逻辑备份》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
ExportandImportUtilities
1ObjectivesAftercompletingthislesson,youshouldbeabletodothefollowing:DescribetheusesoftheExportandImportutilitiesDescribeExportandImportconceptsandstructuresPerformsimpleExportandImportoperationsListguidelinesforusingExportandImport
2OracleExportandImportUtilitiesOracle databaseOracle databaseExportImport
3OracleExportandImportUtilityOverviewYoucanusetheseutilitiestodothefollowing:ArchivehistoricaldataSavetabledefinitionstoprotectthemfromusererrorfailureMovedatabetweenmachinesanddatabasesorbetweendifferentversionsoftheOracleserverTransporttablespacesbetweendatabases
4MethodsofInvokingthe ExportandImportUtilitiesCommand-lineinterfaceAninteractivedialogParameterfilesOracleEnterpriseManager
5FullDatabaseModeTablesdefinitionsTablesdataGrantsIndexesTablesconstraintsExportModesTableModeTabledefinitionsTabledata(allorselectedrows)Owner’stablegrantsOwner’stableindexesTableconstraintsUserModeTablesdefinitionsTablesdataOwner’sgrantsOwner’sindexesTablesconstraintsTablespaceModeTabledefinitionsGrantsIndexesTableconstraintsTriggers
6InvokingExportSyntax:Examples:exphr/hrTABLES=employees,departmentsrows=yfile=exp1.dmpexpkeyword=value,value2,…,valuenexpsystem/managerOWNER=hrdirect=y file=expdat.dmpexp\'username/passwordASSYSDBA\'TRANSPORT_TABLESPACE=yTABLESPACES=ts_emplog=ts_emp.log
7UsingtheExportWizard
8Direct-PathExportConceptsBuffer cacheGenerateSQL commandsWriteblocksDirectPathDumpfileExportExportOracleServerReadblocksEvaluating bufferTTC bufferBuffer cache managerSQL command processingTwo-Task common (TTC)DirectPathConventionalPath
9Direct-PathExportFeaturesThetypeofExportisindicatedonthescreenoutput,exportdumpfile,andthelogfile.DataisalreadyintheformatthatExportexpects,avoidingunnecessarydataconversion.UsesanoptimizedSQLSELECTstatement.
10Direct-PathExportRestrictionsThedirect-pathoptioncannotbeinvokedinteractively.Client-sideandserver-sidecharactersetsmustbethesame.TheBUFFERparameterhasnoaffect.
11SpecifyingDirect-PathExportAscommandlineargumenttotheExportcommand:Asakeywordinaparameterfile:expparfile=expuserid=hr/hrfull=ydirect=yParameterfile…..(OtherParameters)DIRECT=Y…...(OtherParameters)
12UsesoftheImportUtilityforRecoveryCreatetabledefinitionsExtractdatafromavalidExportfileImportfromacompleteorcumulativeExportfileRecoverfromuser-errorfailures
13ImportModesModeDescriptionTableImportspecifiedtablesintoaschema.UserImportallobjectsthatbelongtoa schemaTablespaceImportalldefinitionsoftheobjectscontainedinthetablespaceFullDatabaseImportallobjectsfromtheexportfile
14InvokingImportSyntax:Examples:imphr/hrTABLES=employees,departmentsrows=yfile=exp1.dmpimpkeyword=valueorkeyword=value,value2,…valuenimpsystem/managerFROMUSER=hrfile=exp2.dmpimp\'username/passwordASSYSDBA\'TRANSPORT_TABLESPACE=yTABLESPACES=ts_employees
15UsingtheImportWizard
16InvokingImportasSYSDBAYouneedtoinvokeImportasSYSDBAunderthefollowingconditions:AttherequestofOracletechnicalsupportWhenimportingatransportabletablespacesetToinvokeImportasSYSDBA:imp\'username/passwordASSYSDBA\'
17ImportProcessSequence1.Newtablesarecreated2.Dataisimported3.Indexesarebuilt4.Triggersareimported5.Integrityconstraintsareenabledonthenewtables6.Anybitmap,functional,and/ordomainindexesarebuilt
18GlobalizationSupportConsiderationsTheExportfileidentifiesthecharacterencodingschemethatisusedforthecharacterdatainthefile.TheImportutilitytranslatesdatatothecharactersetofitshostsystem.AmultibytecharactersetExportfilemustbeimportedintoasystemthathasthesamecharacteristics.
19SummaryInthislesson,youshouldhavelearnedhowto:DescribetheusesofExportandImportDescribeExportandImportconceptsandstructuresPerformsimpleExportandImportoperationsListguidelinesforusingExportandImport
20Practice18OverviewThispracticecoversthefollowingtopics:UsingtheExportutilityUsingtheImportutility
