Oracle Database 2 Day DBA

Oracle®Database2DayDBA10gRelease2(10.2)B14196-01June2005OracleDatabase2DayDBA,10gRelease2(10.2)B14196-01Copyright©2004,2005,Oracle.Allrightsreserved.PrimaryAuthor:ColinMcGregorContributingAuthor:SushilKumar,AntonioRomero,DavidAustin,SteveFogel,LanceAshdown,andDouglasWilliamsContributor:MicheleCyran,DanielaHansell,VasudhaKrishnaswamy,PeterLaquerre,VenkatMaddali,MugheesMinhas,JPPolk,MarkTownsend,andWanliYangThePrograms(whichincludeboththesoftwareanddocumentation)containproprietaryinformation;theyareprovidedunderalicenseagreementcontainingrestrictionsonuseanddisclosureandarealsoprotectedbycopyright,patent,andotherintellectualandindustrialpropertylaws.Reverseengineering,disassembly,ordecompilationofthePrograms,excepttotheextentrequiredtoobtaininteroperabilitywithotherindependentlycreatedsoftwareorasspecifiedbylaw,isprohibited.Theinformationcontainedinthisdocumentissubjecttochangewithoutnotice.Ifyoufindanyproblemsinthedocumentation,pleasereportthemtousinwriting.Thisdocumentisnotwarrantedtobeerror-free.ExceptasmaybeexpresslypermittedinyourlicenseagreementforthesePrograms,nopartoftheseProgramsmaybereproducedortransmittedinanyformorbyanymeans,electronicormechanical,foranypurpose.IftheProgramsaredeliveredtotheUnitedStatesGovernmentoranyonelicensingorusingtheProgramsonbehalfoftheUnitedStatesGovernment,thefollowingnoticeisapplicable:U.S.GOVERNMENTRIGHTSPrograms,software,databases,andrelateddocumentationandtechnicaldatadeliveredtoU.S.GovernmentcustomersarecommercialcomputersoftwareorcommercialtechnicaldatapursuanttotheapplicableFederalAcquisitionRegulationandagency-specificsupplementalregulations.Assuch,use,duplication,disclosure,modification,andadaptationofthePrograms,includingdocumentationandtechnicaldata,shallbesubjecttothelicensingrestrictionssetforthintheapplicableOraclelicenseagreement,and,totheextentapplicable,theadditionalrightssetforthinFAR52.227-19,CommercialComputerSoftware—RestrictedRights(June1987).OracleCorporation,500OracleParkway,RedwoodCity,CA94065TheProgramsarenotintendedforuseinanynuclear,aviation,masstransit,medical,orotherinherentlydangerousapplications.Itshallbethelicensee'sresponsibilitytotakeallappropriatefail-safe,backup,redundancyandothermeasurestoensurethesafeuseofsuchapplicationsiftheProgramsareusedforsuchpurposes,andwedisclaimliabilityforanydamagescausedbysuchuseofthePrograms.Oracle,JDEdwards,PeopleSoft,andRetekareregisteredtrademarksofOracleCorporationand/oritsaffiliates.Othernamesmaybetrademarksoftheirrespectiveowners.TheProgramsmayprovidelinkstoWebsitesandaccesstocontent,products,andservicesfromthirdparties.Oracleisnotresponsiblefortheavailabilityof,oranycontentprovidedon,third-partyWebsites.Youbearallrisksassociatedwiththeuseofsuchcontent.Ifyouchoosetopurchaseanyproductsorservicesfromathirdparty,therelationshipisdirectlybetweenyouandthethirdparty.Oracleisnotresponsiblefor:(a)thequalityofthird-partyproductsorservices;or(b)fulfillinganyofthetermsoftheagreementwiththethirdparty,includingdeliveryofproductsorservicesandwarrantyobligationsrelatedtopurchasedproductsorservices.Oracleisnotresponsibleforanylossordamageofanysortthatyoumayincurfromdealingwithanythirdparty.iiiContentsSendUsYourComments........................................................................................................................xiPreface...............................................................................................................................................................xiiiAudience.....................................................................................................................................................xiiiDocumentationAccessibility...................................................................................................................xiiiStructure.....................................................................................................................................................xivRelatedDocumentation............................................................................................................................xvConventions...............................................................................................................................................xvi1IntroductionAboutthisBook........................................................................................................................................1-1WhatthisBookisNot........................................................................................................................1-1HowtoUsethisBookwithRelatedMaterial.................................................................................1-1TheOracleDatabase................................................................................................................................1-2CommonOracleDBATasks...................................................................................................................1-2ToolsforAdministeringtheDatabase.............................