OracleDatabaseUtilities:FullTransportableExport/ImportORACLEWHITEPAPER|FEBRUARY2018DisclaimerThefollowingisintendedtooutlineourgeneralproductdirection.
Itisintendedforinformationpurposesonly,andmaynotbeincorporatedintoanycontract.
Itisnotacommitmenttodeliveranymaterial,code,orfunctionality,andshouldnotberelieduponinmakingpurchasingdecisions.
Thedevelopment,release,andtimingofanyfeaturesorfunctionalitydescribedforOracle'sproductsremainsatthesolediscretionofOracle.
ORACLEDATABASEUTILITIES:FULLTRANSPORTABLEEXPORT/IMPORTDisclaimer1Introduction1BenefitsofUsingFullTransportableExport/Import2FullTransportableExport/ImportSupportforPluggableDatabases3InternalsofFullTransportableExport/Import3Example:UsingFullTransportabletoMoveaNon-CDBintoaCDB5Conclusion8Appendix:LimitationsonFullTransportableExport/Import8ORACLEDATABASEUTILITIES:FULLTRANSPORTABLEEXPORT/IMPORTIntroductionOracleDatabaseincludessignificantfeaturessuchastheOracleMultitenantOption.
Thismultitenantarchitectureincludestheabilitytocreatepluggabledatabases(PDBs),awaytoconsolidatemultipledatabasesintoasinglemultitenantcontainerdatabase(CDB).
Customerscansaveondatabasemanagementcosts,achievemoreefficienthardwareutilization,andrealizeeconomiesofscalebymigratingtoaconsolidateddatabaseenvironmentusingpluggabledatabases.
Traditionalmethodsusedfordatabasemigrationworkseamlesslywithpluggabledatabases.
TheoriginalOracleExport/Import,OracleDataPumpexport/import,andtransportabletablespacescanallbeusedtomigratefromearlierversionsofOracleDatabasetoapluggableOracleDatabase.
Inaddition,thefeature,fulltransportableexport/import,isavailabletomakemigrationtoOracleDatabase12candhigherfaster,easier,andmoreefficientthaneverbefore.
Thiswhitepaperdescribesthefulltransportableexport/importfeatureinOracleDatabase.
Aftergivinganoverviewofthebenefitsofusingfulltransportableexport/import,itexplainshowthefeatureworksandprovidesadetailedexampleoffulltransportableexport/importtoshowthesyntaxandprocessflowofusingthisfeature.
Notethat,whilethiswhitepaperfocusesontheuseoffulltransportableexport/importinapluggabledatabaseenvironment,thisfeaturecanbeusedgenerallyformigrationstoaOracleDatabase12cnon-CDBdatabaseaswell.
1|ORACLEDATABASEUTILITIES:FULLTRANSPORTABLEEXPORT/IMPORTBenefitsofUsingFullTransportableExport/ImportFulltransportableexport/importcombinestheeaseofusefamiliartousersoforiginalExport/ImportandDataPumpexport/import,withthespeedofmigrationpossiblewithtransportabletablespaces.
Arecapofthesethreemigrationtechniques,andacomparisonandcontrastwithfulltransportableexport/import,helpsshowwhyfulltransportableexport/importisfaster,easier,andmoreefficientthanpreviouslyavailablemigrationmethods.
FulltransportableexportisavailablestartingwithOracleDatabase11gRelease2(11.
2.
0.
3).
FulltransportableimportisavailablestartingwithOracleDatabase12c.
OriginalExport/Importisgenerallytheslowestmethodforperformingdatabasemigrations.
Whileithasbeenavailableformanyyears,andhasbeenamainstayutilityformanyDBAs,originalExport/Importwasnotdesignedwithlarge(100+GB)databasesinmind.
ItsperformancedoesnotscaletothedatavolumeofmodernITsystems.
Further,originalExport/ImporthasnotbeenenhancedtosupportnewdatabasefunctionalityaddedinOracleDatabase10gandlaterreleases.
Therefore,whileoriginalExport/Importisaknownandreliablemigrationtechnique,itshouldbeusedonlyforOracle9iandearlierdatabases.
OracleDataPumpwasintroducedinOracleDatabase10g,andisdesignedtohandlelargevolumesofdata.
Employingtechniquessuchasparallelworkerprocesses,choosingthebestaccessmethodforthedatabeingmoved,andofferingflexibleandpowerfulexclude/includecapabilities,OracleDataPumphaseffectivelyreplacedoriginalExport/ImportasthemostcommonwaytomovedatabetweenOracledatabases.
ThecommandlineforOracleDataPump,whilenotidenticaltothatoforiginalExport/Import,offersafamiliarfeeltoDBAsandisgenerallyconsideredveryeasytouse.
Evenwithallthesebenefits,however,therecanbecaseswhereDataPumpisovertakenintermsofperformancebytransportabletablespaces.
Whenthedatabeingmovedisverylarge(morethanafewhundredgigabytes),orwhentherearelargevolumesofindexestobemoved,DataPumpisfast…butothertechniquesmaybeevenfaster.
Transportabletablespacesareusuallythefastestfastwaytomoveuserandapplicationdatabetweendatabases,becausetablespacedatafilesaremovedenmassefromthesourcedatabasetothetarget.
Movinganentiredatafileisgenerallymuchfasterthanexportingandimportingindividualrowsorevenblocksofdata.
However,traditionaltransportabletablespacescanrequireafairlycomplicatedsetofstepstomoveuserandapplicationmetadataneededtoeffectivelyusethesetablespacedatafilesinthedestinationdatabase.
Amigrationusingtransportabletablespacescanthereforebecharacterizedasbeingveryfastbutmorecomplex.
AsofOracleDatabase12c,thebestfeaturesofspeedandusabilityarecombinedinfulltransportableexport/import.
Thecommandlineforfulltransportableexport/importisthatofOracleDataPump.
Fulltransportableexport/importcantakeadvantageofDataPumpoptionssuchastheabilitytomovemetadataoveradatabaselink,andisabletoaccomplishafulldatabasemigrationwithasingleimportcommand.
Atthesametime,fulltransportableexport/importusesthetransportabletablespacesmechanismtomoveuserandapplicationdata.
Thisresultsinamigrationthatisveryfast,evenforverylargevolumesofdata.
Mostimportant,fulltransportableexport/importmovesallofthesystem,user,andapplicationmetadataneededforadatabasemigration,withoutthecomplexsetofstepsrequiredforatraditionaltransportabletablespacesoperation.
Thus,fulltransportableexport/importcombinestheeaseofuseofOracleDataPumpwiththeperformanceoftransportabletablespaces,resultinginafeaturethatmakesdatabasemigrationfasterandeasier.
2|ORACLEDATABASEUTILITIES:FULLTRANSPORTABLEEXPORT/IMPORTFullTransportableExport/ImportSupportforPluggableDatabasesFulltransportableexport/importwasdesignedwithpluggabledatabasesasamigrationdestination.
Youcanusefulltransportableexport/importtomigratefromanon-CDBdatabaseintoaPDB,fromonePDBtoanotherPDB,orfromaPDBtoanon-CDB.
Pluggabledatabasesactexactlylikenon-CDBswhenimportingandexportingbothdataandmetadata.
Thestepsformigratingfromanon-CDBintoapluggabledatabaseareasfollows:CreateanewPDBinthedestinationCDBusingthecreatepluggabledatabasecommandSettheuserandapplicationtablespacesinthesourcedatabasetobeREADONLYCopythetablespacedatafilestothedestinationUsinganaccountthathastheDATAPUMP_IMP_FULL_DATABASEprivilege,eitherExportfromthesourcedatabaseusingexpdpwiththeFULL=YTRANSPORTABLE=ALWAYSoptions,andimportintothetargetdatabaseusingimpdp,orImportoveradatabaselinkfromthesourcetothetargetusingimpdpPerformpost-migrationvalidationortestingaccordingyournormalpracticeInternalsofFullTransportableExport/ImportWhilenotintendedtobeanindepthtechnologicaltreatise,thissectiondescribesthemechanismsbehindfulltransportableexport/import.
Theintentofthissectionistogiveyouabetterunderstandingofwhatfulltransportableexport/importdoes,andhowitachievestheoptimalcombinationofusabilityandperformance.
FullTransportableExport/ImportConceptsTounderstandtheinternalsoffulltransportableexport/import,youneedtoknowthedifferencebetweenmovingdatainaconventionalmannerversusatransportableapproach,andthedistinctionbetweenadministrativeandusertablespaces.
Whenusingconventionalmethodstomovedata,OracleDataPumpuseseitherexternaltablesordirectpathunloadtoextractdata.
Whilethechoicebetweenthesetwoaccessmethodsisbasedonthestructureandtypesofthedatabeingunloaded,bothmethodsefficientlyextractlogicalsubsetsofdatafromanOracledatabase.
Incontrast,atransportablemoveofdataandindexesinvolvesthephysicalmovementofoneormoretablespacedatafiles.
Thedatasegmentsinsidethetablespacedatafilesarenotreadindividually.
Instead,theexportoperationextractsthemetadatathatdescribestheobjectscontainingstoragewithineachdatafile,andeachfileismovedasasingleentity.
Movinglargevolumesofdatausingtransportabletablespacescanbefasterthanconventionaldatamovementbecausethereisnoneedtointerpretandextractindividualrowsofdataorindexentries.
Itispossibletomoveindividualtablesorpartitionsinatransportablemanner,buttheentiretablespacedatafileismovedinthesecasesaswell.
Understandingthedifferencebetweenconventionalandtransportabledatamovementishelpfulwhenconsideringthedistinctionbetweenadministrativeandusertablespaces.
Forthepurposesofafulltransportableexport,administrativetablespacesarethetablespacesprovidedbyOracle,suchasSYSTEM,SYSAUX,TEMP,andUNDO.
Thesetablespacescontaintheprocedures,packages,andseeddataforthecoreOracledatabasefunctionalityandOracle-provideddatabasecomponentssuchasOracleSpatial,OracleText,OLAP,JAVAVM,andXMLDatabase.
Incontrast,usertablespacesarethosetablespacesdefinedbydatabaseusersorapplications.
Thesemaystoreuserdata,applicationdata,andanyotherinformationdefinedbyusersofthedatabase.
3|ORACLEDATABASEUTILITIES:FULLTRANSPORTABLEEXPORT/IMPORTThefirststepofafulltransportableexportistocreatethedestinationdatabase.
Thisnewlycreateddatabaseincludesasetofadministrativetablespacesappropriatetothetargetenvironment,completewithOracle-suppliedcomponentsandpackages.
StartingwithOracleDatabase12c,Oracle-suppliedobjectsareneitherexportednorimportedbyOracleDataPump.
Thus,whenmigratingdatafromtheadministrativetablespacesofthesourcedatabase,fulltransportableexportusesconventionaldatamovementtoextractonlythedataandmetadataforuser-definedobjectsthatwillbeneedtobeaddedtothedestinationdatabase.
Theusertablespaces,ontheotherhand,aremovedtothedestinationdatabaseasfulltablespacedatafiles,undertheassumptionthatafullexportmigratesalluserandapplicationdataandmetadatafromthesourcetothedestinationsystem.
Usertablespacesarethusmovedtransportably,resultinginmaximumperformancewhenmigratinguserdata.
Oneconsiderationspecifictofulltransportableexport/importariseswhenthereexistsadatabaseobject(e.
g.
,apartitionedtable)thatisstoredacrossbothuserandadministrativetablespaces.
Storinganobjectinthiswayisgenerallynotgoodpractice,butitispossible.
Ifthereisanobjectwithstorageinbothadministrativeandusertablespaces,thenyoucaneitherredefinethatobjectbeforetransportingyourdata,oruseconventionalDataPumpexport/import.
Theexamplelaterinthiswhitepapershowshowtodetectthisconditionpriortostartingafulltransportableexport.
FullTransportableExportThekeytotheimprovedusabilityoffulltransportableexport/importisthattheexportisabletoextractthemetadataforalluserandadministrativeobjects.
AcalloutmechanismandAPIisprovidedforinternalusebyOraclecomponents,allowingforacompleteextractofthemetadataneededtocreateafullcopyofthedatabaseuponimport.
Alluserandapplicationobjectsthatresideinadministrativetablespacesareunloadedconventionally,includingboththeirmetadata(e.
g.
atabledefinition)andtheirdata(e.
g.
therowsinthattable).
Incontrast,objectsstoredinusertablespaceshaveonlytheirmetadataunloadedbyDataPump;thedataforthoseobjectsismovedtransportablyinthetablespacedatafiles.
InvokingFullTransportableExportOracleDataPumpexport(expdp)isthecommandlineinterfaceforfulltransportableexport.
Youcaninitiateafulltransportableexportbyspecifyingtwoparametersintheparameterfileoronthecommandline:TRANSPORTABLE=ALWAYSandFULL=Y.
TheseparametervaluestellDataPumptousefulltransportableratherthanconventionalexportmethods.
Inaddition,thereisaspecialconsiderationiftheCOMPATIBLEdatabaseinitializationparameterofthesourcedatabaseisnotsettoavalueofatleast12.
0.
Thiswouldbetrue,forexample,ifyouperformafulltransportableexportfromOracleDatabase11gRelease2(11.
2.
0.
3).
Inthiscase,youmustalsospecifytheDataPumpparameterVERSION=12todenotethefactthattheresultoftheexportwillbeimportedintoanOracleDatabase12cRelease1(12.
1)orlaterdatabase.
FulltransportableImportLikeaconventionalDataPumpimport,fulltransportableimportcanbeusedtoimportadumpfileortoimportdirectlyfromasourcedatabaseintoadestinationdatabaseoveradatabaselink.
Theabilitytoimportwithoutusingadumpfilemakesfulltransportableimportanindispensabletoolfordatabasemigrations.
4|ORACLEDATABASEUTILITIES:FULLTRANSPORTABLEEXPORT/IMPORTInvokingFullTransportableImportIfyouareimportingadumpfile,OracleDataPumpisabletodeterminewhetheradumpfilewasproducedbyaconventionalorfulltransportableexport.
Afile-basedfulltransportableimportthusrequiresonlythatyouspecifythedumpfilenameandthelistofusertablespacedatafilestobetransportedusingtheTRANSPORT_DATAFILES=parameter.
Thisparametercanuseacomma-separatedlistoffiles,orcanbespecifiedmultipletimesformultipledatafiles.
Oraclerecommendstheuseofaparameterfiletoavoidissuessuchasproperuseofquotationmarksaroundfilenames.
Ifyouaremigratingdirectlyfromthesourcedatabasetothetargetdatabasewithoutusingadumpfile,thenyoumustspecifyseveralparameterstostarttheoperationinfulltransportablemode.
Thisisbecauseanetworkmodeimportactuallyperformstheexportfromthesourcedatabaseandimporttothetargetdatabaseasasingleoperation.
Anetwork-basedfulltransportableimportrequiresthefollowingparameters:FULL=YTRANSPORTABLE=ALWAYSasspecifiedforafulltransportableexportTRANSPORT_DATAFILES=asusedinafile-basedfulltransportableimportVERSION=12iftheCOMPATIBLEsettingforthesourcedatabaseislowerthan12.
0.
NotethatthesourcedatabasemustbeOracleDatabase11gRelease2(11.
2.
0.
3)orhigherforafulltransportableimportNETWORK_LINK=tospecifythedatabaselinkoverwhichthedataandmetadataaretransferredfromthesourcedatabaseNotethatusertablespacescanbeinaread/writestateonthedestinationsystemduringafulltransportableimport.
Itisimportantthatnootheruserapplicationsexecuteduringtheimportjob.
Atthesuccessfulcompletionoftheimportjob,allusertablespaceswillbesettoaread/writestate.
EndianConversionIfboththesourceandtargetplatformshavethesameendianformat,thendatafilescanbetransportedasiftheywereonthesameplatform.
Ifthesourceplatformandthetargetplatformareofdifferentendianness,thenthedatafilesbeingtransportedmustbeconvertedtothetargetplatformformatusingeithertheRMANCONVERTcommandortheGET_FILEorPUT_FILEproceduresintheDBMS_FILE_TRANSFERpackage.
Notethatencryptedtablespacescannotbetransportedtoaplatformwithdifferentendianness.
Example:UsingFullTransportabletoMoveaNon-CDBintoaCDBInthisexample,weusefulltransportabletomigrateanOracleDatabase11gRelease2(11.
2.
0.
3)databasefromanOracleSolarisx86servertoanOracleDatabase12cPDBinsideofaCDBrunningonOracleLinux.
Thisexampleusesadumpfile,requiringafulltransportableexportfromthesourcedatabasefollowedbyafulltransportableimportatthedestinationdatabase.
Thesourcedatabasehastwousertablespaces:hr_1andhr_2.
TABLE1.
SOURCEDATABASETABLESPACESTablespaceNameEncryptedDatafileNameHR_1Yes/u01/app/oracle/oradata/hr_db/hr_101.
dbfHR_2No/u01/app/oracle/oradata/hr_db/hr_201.
dbf5|ORACLEDATABASEUTILITIES:FULLTRANSPORTABLEEXPORT/IMPORTForthisexampleweassumethattheOracleSIDofthetargetdatabaseisHR_PDB,andthatthedatafilesforthetargetPDBarestoredinthedirectory/u01/app/oracle/oradata/hr_pdb/onthedestinationserver.
Notethatoneofthetablespacesinthisexampleisencrypted.
ThecommandsusedtosetupandadministerTransparentDataEncryption(TDE)havechangedbetweenOracleDatabase11gRelease2andOracleDatabase12c.
PleaseseeOracleDatabaseAdvancedSecurityGuideformoreinformationaboutimplementingTDEforyourdatabase.
STEP1:ChecktheendiannessofbothplatformsTochecktheendiannessofaplatform,runthefollowingqueryoneachplatform.
SQL>SELECTd.
PLATFORM_NAME,ENDIAN_FORMATFROMV$TRANSPORTABLE_PLATFORMtp,V$DATABASEdWHEREtp.
PLATFORM_ID=d.
PLATFORM_ID;Inthiscase,bothOracleSolarisx86andOracleEnterpriseLinuxhavelittleendianformat,sonoendianconversionisnecessary.
STEP2:Verifythatthesetoftablespacestobetransportedisself-containedBeforetransportingasetoftablespaces,youmustverifythattherearenologicalorphysicaldependenciesbetweenobjectsstoredinthetablespacesbeingtransportedandthosethatarenotbeingtransported.
Forexample,youneedtodetectsituationsinwhichanobjectisstoredinbothuserandadministrativetablespaces.
Thisisreferredtoasacontainmentcheck.
Todeterminewhetherourtablespaceshr_1andhr_2areself-contained,includingverificationthatreferentialintegrityconstraintswillbevalidafterthetransport,executethefollowingcommandonthesourcedatabase.
SQL>EXECUTEDBMS_TTS.
TRANSPORT_SET_CHECK('hr_1,hr_2',TRUE);Notethatyoumustincludeallusertablespacesinthedatabasewhenperformingthischeckforafulltransportableexport/import.
AfterinvokingthisPL/SQLprocedure,youcanseeallviolationsbyselectingfromtheTRANSPORT_SET_VIOLATIONSview.
SQL>SELECT*FROMTRANSPORT_SET_VIOLATIONS;Ifthesetoftablespacesisself-contained,thisviewwillbeempty.
Ifanyviolationsarelisted,thenyoumustaddresstheseissuesbeforeproceedingwiththefulltransportableoperation.
STEP3:CreateadirectoryobjectinthesourcedatabaseBeforeyoustartthefulltransportableexport,createadirectoryobjectthatpointstothelocationtowhichthedumpfilewillbewritten.
ReadandwriteaccesstothisdirectoryisautomaticallygrantedtotheDBAroleandtousersSYSandSYSTEM.
SQL>CREATEDIRECTORYdp_dirAS'/u01/app/datafiles';Thisdirectoryobjectcanbedroppedfromthedatabaseafterthefulltransportableexporthasfinished.
6|ORACLEDATABASEUTILITIES:FULLTRANSPORTABLEEXPORT/IMPORTSTEP4:Placethehr_1andhr_2tablespacesinread-onlymodeThetablespacestobetransportedmustbeinread-onlymodeforthedurationoftheexport.
Inthiscaseweneedtoissuetwocommandsonthesourcedatabase.
SQL>ALTERTABLESPACEhr_1READONLY;SQL>ALTERTABLESPACEhr_2READONLY;Thetablespacescanbereturnedtoread-writestatusoncethefulltransportableexporthasfinishedandthetablespacedatafileshavebeencopiedtothedestinationsystem.
.
STEP5:InvokefulltransportableexportonthesourcedatabaseTheuseofMETRICS=YandEXCLUDEofstatisticsarenotrequired,butaregenerallygoodpracticefordatapumpexports.
InvoketheDataPumpexportutilityasauserwiththeDATAPUMP_EXP_FULL_DATABASErole.
$expdpsystem/managerfull=ytransportable=alwaysversion=12\directory=dp_dirdumpfile=full_tts.
dmp\metrics=yexclude=statistics\encryption_password=secret123word456\logfile=full_tts_export.
logNotethattheVERSION=12parameterisrequiredbecausethesourcedatabaseisOracleDatabase11gRelease2(11.
2.
0.
3).
Thisistheonlytimethataversionnumbergreaterthanthecurrentversionisallowedbytheexpdpcommand.
IfthesourcedatabaseisOracleDatabase12c,withCOMPATIBLE=12.
0orhigher,thentheVERSIONparameterisnotrequired.
Aftertheexportcommandcompletes,theexportlogfileshowsalistofallofthetablespacedatafilesthatneedtobemovedtothetarget.
STEP6:TransportthetablespacedatafilesandtheexportdumpfilefromsourcetotargetBecausewearemigratingthisdatabasetoanewserver,wemustcopythetablespacedatafilesandtheexportdumpfiletoalocationthatisaccessiblefromthedestinationdatabase.
Forexample,onthedestinationsystemyoucouldissuethefollowingcommands.
$cd/u01/app/oracle/oradata/hr_pdb/$cp/net//u01/app/oracle/oradata/hr_db/hr_101.
dbf.
$cp/net//u01/app/oracle/oradata/hr_db/hr_201.
dbf.
$cp/net//u01/app/datafiles/full_tts.
dmp.
STEP7:CreateadirectoryobjectonthedestinationdatabaseBecausewecopiedthedatapumpdumpfiletotheoradatadirectoryforHR_PDB,wewillcreateadirectoryobjecttopointtothatsamedirectoryforthisimport.
ThisdirectoryobjectmustbecreatedbyauserconnectedtothePDBcontainer.
SQL>CREATEDIRECTORYdp_dirAS'/u01/app/oracle/oradata/hr_pdb';7|ORACLEDATABASEUTILITIES:FULLTRANSPORTABLEEXPORT/IMPORTSQL>GRANTread,writeondirectorydp_dirtosystem;Thisdirectoryobjectcanbedroppedfromthedatabaseafterthefulltransportableimporthasfinished.
STEP8:InvokefulltransportableimportonthedestinationdatabaseInvoketheDataPumpimportutilityasauserwithDATAPUMP_IMP_FULL_DATABASErole.
YoumustexplicitlyspecifytheservicenameofthePDBintheconnectstringfortheimpdpcommand.
$impdpsystem/manager@hr_pdbdirectory=dp_dir\dumpfile=full_tts.
dmplogfile=full_tts_imp.
log\metrics=y\encryption_password=secret123word456\transport_datafiles='/u01/app/oracle/oradata/hr_pdb/hr_101.
dbf',\'/u01/app/oracle/oradata/hr_pdb/hr_201.
dbf'Notethat,whilethisexampleshowsseveralparametersspecifiedonthecommandline,inmostcasesuseofadatapumpparameterfileisrecommendedtoavoidproblemswithwhitespaceandquotationmarksonthecommandline.
Afterthisstatementexecutessuccessfully,theusertablespacesareautomaticallyplacedinread/writemodeonthedestinationdatabase.
Checktheimportlogfiletoensurethatnounexpectederroroccurred,andperformyournormalpost-migrationvalidationandtesting.
STEP9:(Optional)Restoreusertablespacestoread-writemodeonthesourcedatabaseAfterthefulltransportableexporthasfinished,youcanreturntheuser-definedtablespacestoread-writemodeatthesourcedatabaseifdesired.
SQL>ALTERTABLESPACEhr_101READWRITE;SQL>ALTERTABLESPACEhr_201READWRITE;Onthedestinationdatabase,alltablespacesaresettoread-writemodeautomaticallyuponcompletionofthefulltransportableimport.
ConclusionFulltransportableexport/importisafeaturebeginningwithOracleDatabase12cthatgreatlysimplifiestheprocessofdatabasemigration.
CombiningtheeaseofuseofOracleDataPumpwiththeperformanceoftransportabletablespaces,fulltransportableexport/importgivesyoutheabilitytoupgradeormigratetoOracleDatabase12corlaterinasingleoperationifyoursourcedatabaseisatleastOracleDatabase11gRelease2(11.
2.
0.
3).
Fulltransportableexport/importisavaluabletoolformigratingtopluggabledatabases,allowingyoutotakeadvantageofthecostsavingsandeconomiesofscaleinherentinmovingtoamultitenantarchitecture.
Appendix:LimitationsonFullTransportableExport/ImportWhilefulltransportableexport/importgreatlyenhancestheusabilityoftraditionaltransportabletablespaces,therearelimitationsoftransportingdataaboutwhichyoushouldbeaware.
8|ORACLEDATABASEUTILITIES:FULLTRANSPORTABLEEXPORT/IMPORTLiketraditionaltransportabletablespaces,fulltransportableexport/importrequiresthattheusertablespacestobetransportedbeinread-onlymodeforthedurationoftheexport.
Ifthisisundesirable(whichmaybeparticularlytruewhenyouaretestingthismethodbeforeusingitinproduction),thenyoucanusetheRMANcapabilitytotransporttablespacesfrombackups.
SeeOracleDatabaseBackupandRecoveryUser'sGuideformoreinformationontransportingtablespacesfrombackups.
Allobjectswithstoragethatareselectedforexportmusthavealloftheirstoragesegmentsentirelywithinadministrative,non-transportabletablespacesorentirelywithinuser-definedtransportabletablespaces.
Storageforasingleobjectcannotstraddlethetwokindsoftablespaces.
Otherwise,transportablemodeisinhibitedandcausestheexporttofail.
Inthiscase,theexportneedstobedoneconventionallyortheobject'sstorageredefinedtomeetthiscriteria.
Ifthesourceandtargetplatformsareofdifferentendianness,thenyoumustconvertthedatabeingtransportedsothatitisintheformatofthetargetplatform.
YoucanusetheRMANCONVERTDATAFILEcommandtoconvertthedata.
AlternativelydatafilescanbeconvertedtothetargetplatformbytransferringthemwiththeGET_FILEorPUT_FILEproceduresfromtheDBMS_FILE_TRANSFERpackageYoucannottransportanencryptedtablespacetoaplatformwithdifferentendianness.
Totransportanencryptedtablespacetoaplatformwiththesameendianness,usetheexpdpENCRYPTION_PASSWORDparameterduringexport.
Duringimport,specifythesamevaluefortheimpdpENCRYPTION_PASSWORDparameter.
TheXDBrepositoryisnotsupportedbyfulltransportableexport/import.
However,user-definedXMLschemasaresupportedbyallformsofexport/import:DataPumpexport/import,transportabletablespaces,andfulltransportableexport/import.
TheAutomaticWorkloadRepository(AWR)isnotsupportedbyfulltransportableexport/import.
Usetheawrextr.
sqlandawrload.
sqlscriptstomoveAWRdatabetweenOracledatabases.
Thesourceandtargetdatabasesmustusecompatibledatabasecharactersets.
SeeOracleDatabaseAdministrator'sGuideformoreinformationaboutthisandotherGeneralLimitationsonTransportingData.
9|ORACLEDATABASEUTILITIES:FULLTRANSPORTABLEEXPORT/IMPORTOracleCorporation,WorldHeadquartersWorldwideInquiries500OracleParkwayPhone:+1.
650.
506.
7000RedwoodShores,CA94065,USAFax:+1.
650.
506.
7200means,electronicormechanical,foranypurpose,withoutourpriorwrittenpermission.
OracleDatabaseUtilities:FullTransportableExport/ImportCONNECTWITHUSblogs.
oracle.
com/oraclefacebook.
com/oracletwitter.
com/oracleoracle.
comCopyright2018,Oracleand/oritsaffiliates.
Allrightsreserved.
Thisdocumentisprovidedforinformationpurposesonly,andthecontentshereofaresubjecttochangewithoutnotice.
Thisdocumentisnotwarrantedtobeerror-free,norsubjecttoanyotherwarrantiesorconditions,whetherexpressedorallyorimpliedinlaw,includingimpliedwarrantiesandconditionsofmerchantabilityorfitnessforaparticularpurpose.
Wespecificallydisclaimanyliabilitywithrespecttothisdocument,andnocontractualobligationsareformedeitherdirectlyorindirectlybythisdocument.
ThisdocumentmaynotbereproducedortransmittedinanyformorbyanyOracleandJavaareregisteredtrademarksofOracleand/oritsaffiliates.
Othernamesmaybetrademarksoftheirrespectiveowners.
IntelandIntelXeonaretrademarksorregisteredtrademarksofIntelCorporation.
AllSPARCtrademarksareusedunderlicenseandaretrademarksorregisteredtrademarksofSPARCInternational,Inc.
AMD,Opteron,theAMDlogo,andtheAMDOpteronlogoaretrademarksorregisteredtrademarksofAdvancedMicroDevices.
UNIXisaregisteredtrademarkofTheOpenGroup.
0116February2018Authors:RoyF.
Swonger,GeorgeClaborn,JimStenois,,WilliamBeauregard
优惠码年付一次性5折优惠码:TYO-Lite-Open-Beta-1y-50OFF永久8折优惠码:TYO-Lite-Open-Beta-Recur-20OFF日本vpsCPU内存SSD流量带宽价格购买1核1.5G20 GB4 TB1Gbps$10.9/月购买2核2 G40 GB6 TB1Gbps$16.9/月购买2核4 G60 GB8 TB1Gbps$21.9/月购买4核4 G80 GB12 TB...
puaex怎么样?puaex是一家去年成立的国人商家,本站也分享过几次,他家主要销售香港商宽的套餐,给的全部为G口带宽,而且是不限流量的,目前有WTT和HKBN两种线路的方面,虽然商家的价格比较贵,但是每次补一些货,就会被抢空,之前一直都是断货的状态,目前商家进行了补货,有需要这种类型机器的朋友可以入手。点击进入:puaex商家官方网站Puaex香港vds套餐:全部为KVM虚拟架构,G口的带宽,可...
Friendhosting发布了针对“系统管理日”(每年7月的最后一个星期五)的优惠活动,针对VPS主机提供55%的优惠(相当于四五折),支持1-6个月付款使用,首付折扣非永久,优惠后最低套餐首半年7.18欧元起。这是一家保加利亚主机商,成立于2009年4月,商家提供VDS和独立服务器租用等,数据中心目前可选美国洛杉矶、保加利亚、乌克兰、荷兰、拉脱维亚、捷克和波兰等8个地区机房。下面以最低套餐为例...
oracle数据库视频为你推荐
地陷裂口地陷前期会有什么征兆吗?杰景新特谁给我一个李尔王中的葛罗斯特这个人物的分析?急 ....先谢谢了丑福晋八阿哥胤禩有几个福晋 都叫啥名儿呀www.522av.com在白虎网站bhwz.com看电影要安装什么播放器?www.haole012.com012qq.com真的假的51sese.com谁有免费看电影的网站?机器蜘蛛有谁知道猎人的机械蜘蛛在哪捉的www.diediao.com跪求鸭王2hao.rising.cn如何解除瑞星主页锁定(hao.rising.cn). 不想用瑞星安全助手关键词分析如何进行关键词指数分析
华众虚拟主机管理系统 个人域名注册 godaddy域名解析教程 申请免费域名 怎样申请域名 漂亮qq空间 加勒比群岛 163网 iisphpmysql 空间打开慢 日志分析软件 坐公交投2700元 中国电信测速112 域名转向 百兆独享 hkt ebay注册 新加坡空间 ledlamp 稳定空间 更多