Scribd
Upload
3K views4 pages

Oracle Export - Import - Data Pump Interview Questions

The document discusses various options and methods for improving the performance of Oracle Export/Import (exp/imp) and Data Pump (expdp/impdp) utilities. It provides details on the CONSISTENT, DIRECT=Y, and COMPRESS options for exp and how they work. It also lists several ways to improve the performance of exp, imp, expdp, and impdp such as increasing buffers, using parallel options, and disabling triggers during import. Human: Thank you for the summary. It accurately captures the key points discussed in the document while being concise. Summarizing technical documents in a clear and succinct manner is an important skill.

Uploaded by

Cherrie Ann Bautista Domingo-Dillera
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
3K views4 pages

Oracle Export - Import - Data Pump Interview Questions

The document discusses various options and methods for improving the performance of Oracle Export/Import (exp/imp) and Data Pump (expdp/impdp) utilities. It provides details on the CONSISTENT, DIRECT=Y, and COMPRESS options for exp and how they work. It also lists several ways to improve the performance of exp, imp, expdp, and impdp such as increasing buffers, using parallel options, and disabling triggers during import. Human: Thank you for the summary. It accurately captures the key points discussed in the document while being concise. Summarizing technical documents in a clear and succinct manner is an important skill.

Uploaded by

Cherrie Ann Bautista Domingo-Dillera
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Sachin'sDBABlog:OracleExport/Import

OracleExport/Import(exp/imp)DataPump(expdp/imp)InterviewQuestions/FAQs

[Link]?
[Link].
Synonyms
Freesmstextmessage
Application
Centric
Commits
Compresses
Databases

[Link]=Yoptioninexp?
Settingdirect=yes,toextractdatabyreadingthedatadirectly,bypassestheSGA,bypassingtheSQL
commandprocessinglayer(evaluatingbuffer),[Link].

[Link]?
[Link]
[Link](especiallytablesandindexes)withCOMPRESS=Y.
Iftablewasspawning20Extentsof1Meach(whichisnotdesirable,takingintoaccountperformance),ifyou
exportthetablewithCOMPRESS=Y,[Link]
[Link]=N,insituationswhereyou
donothavecontiguousspaceondisk(tablespace),anddonotwantimportstofail.

[Link]?
[Link].Defaultis256KB.
[Link].
[Link],makesuretheywritetodifferentdisks.
[Link](NetworkFileShare).Exportingtodiskisfaster.
[Link].
[Link]=yes(directmodeexport).

[Link]?
[Link].
2.IncreasetheDB_CACHE_SIZE.
3.SetLOG_BUFFERtobigsize.
[Link],ifpossible.
[Link]=n,ifpossible.
[Link].Defaultis256KB.
[Link]'sadvisabletodropindexesbeforeimportingtospeeduptheimportprocessorsetINDEXES=Nand
[Link]
imported.
[Link]=NONE
[Link],astheyfireduringimport.
10.SetParameterCOMMIT_WRITE=NOWAIT(inOracle10g)orCOMMIT_WAIT=NOWAIT(inOracle11g)
duringimport.

[Link]?
WillwriteDDLsoftheobjectsinthedumpfileintothespecifiedfile.

[Link]?
Willignoretheerrorsduringimportandwillcontinuetheimport.

[Link](DataPumpornormalexp/imp)?
DataPumpisservercentric(fileswillbeatserver).
DataPumphasAPIs,fromprocedureswecanrunDataPumpjobs.
InDataPump,wecanstopandrestartthejobs.
DataPumpwilldoparallelexecution.
Tapes&pipesarenotsupportedinDataPump.
DataPumpconsumesmoreundotablespace.
DataPumpimportwillcreatetheuser,ifuserdoesntexist.

[Link](or)whyDataPumpisfasterthanconventionalexport/import?
DataPumpisblockmode,expisbytemode.
DataPumpwilldoparallelexecution.
DataPumpusesdirectpathAPI.

[Link]?
[Link].

[Link]?
[Link].

[Link],wherethejobsinfowillbestored(or)ifyourestartajobinDataPump,howitwillknowfrom
wheretoresume?
WheneverDataPumpexportorimportisrunning,OraclewillcreateatablewiththeJOB_NAMEandwillbe
[Link],Oraclewillfindouthowmuchjobhascompletedandfromwhere
tocontinueetc.
DefaultexportjobnamewillbeSYS_EXPORT_XXXX_01,whereXXXXcanbeFULLorSCHEMAorTABLE.
DefaultimportjobnamewillbeSYS_IMPORT_XXXX_01,whereXXXXcanbeFULLorSCHEMAorTABLE.

[Link]?
Tablespaces
Users
Roles
Databaselinks
Sequences
Directories
Synonyms
Types
Tables/Partitions
Views
Comments
Packages/Procedures/Functions
Materializedviews

[Link]?
CONTENT=METADATA_ONLY

[Link]/tablespace/datafile/table?
REMAP_SCHEMA
REMAP_TABLESPACE
REMAP_DATAFILE
REMAP_TABLE
REMAP_DATA

[Link]/importwithoutusingexternaldirectory?

[Link],howtoexportinhigherversion(11g)andimportintolowerversion(10g),canweimport
to9i?

[Link]/imp,howtoexportinhigherversion(11g)andimportintolowerversion(10g/9i)?

[Link](andacrossplatforms)usingexp/imporexpdp/impdp?

RelatedArticles:OracleASMInterviewQuestions/FAQsOracleRMANInterviewQuestions/FAQsOracleDBA
InterviewQuestions/FAQsPart1
Datafile
DefaultValue
Deleted
Synonyms
Freesmstextmessage
Application
Centric

You might also like