資源描述：
《Oracle備份恢復(fù)之13邏輯備份》由會員上傳分享，免費在線閱讀，更多相關(guān)內(nèi)容在教育資源-天天文庫。
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
