两天成为Oracle_DBA

Oracle®Database2DayDBA10gRelease1(10.1)PartNo.B10742-03June2004OracleDatabase2DayDBA,10gRelease1(10.1)PartNo.B10742-03Copyright©2004,Oracle.Allrightsreserved.ContributingAuthors:ColinMcGregor,RuthBaylis,SushilKumar,AntonioRomero,DavidAustin,andMicheleCyranContributors:DanielaHansell,DonnaKeesling,VasudhaKrishnaswamy,PeterLaquerre,TonyMorales,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.OracleisaregisteredtrademarkofOracleCorporationand/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...............................................................................................................................................xv1IntroductionAboutthisBook........................................................................................................................................1-1WhatthisBookisNot........................................................................................................................1-1HowtoUsethisBookwithRelatedMaterial.................................................................................1-1TheOracleDatabase................................................................................................................................1-2CommonOracleDBATasks...................................................................................................................1-2ToolsforAdministeringtheDatabase........................................................................