Oracle-Data-Mining-Administrators-Guide

Oracle®DataMiningAdministrator'sGuide11gRelease2(11.2)E16807-05October2010OracleDataMiningAdministrator'sGuide,11gRelease2(11.2)E16807-05Copyright©1996,2010,Oracleand/oritsaffiliates.Allrightsreserved.PrimaryAuthor:KathyL.TaylorThissoftwareandrelateddocumentationareprovidedunderalicenseagreementcontainingrestrictionsonuseanddisclosureandareprotectedbyintellectualpropertylaws.Exceptasexpresslypermittedinyourlicenseagreementorallowedbylaw,youmaynotuse,copy,reproduce,translate,broadcast,modify,license,transmit,distribute,exhibit,perform,publish,ordisplayanypart,inanyform,orbyanymeans.Reverseengineering,disassembly,ordecompilationofthissoftware,unlessrequiredbylawforinteroperability,isprohibited.Theinformationcontainedhereinissubjecttochangewithoutnoticeandisnotwarrantedtobeerror-free.Ifyoufindanyerrors,pleasereportthemtousinwriting.IfthissoftwareorrelateddocumentationisdeliveredtotheU.S.GovernmentoranyonelicensingitonbehalfoftheU.S.Government,thefollowingnoticeisapplicable:U.S.GOVERNMENTRIGHTSPrograms,software,databases,andrelateddocumentationandtechnicaldatadeliveredtoU.S.GovernmentcustomersarecommercialcomputersoftwareorcommercialtechnicaldatapursuanttotheapplicableFederalAcquisitionRegulationandagency-specificsupplementalregulations.Assuch,theuse,duplication,disclosure,modification,andadaptationshallbesubjecttotherestrictionsandlicensetermssetforthintheapplicableGovernmentcontract,and,totheextentapplicablebythetermsoftheGovernmentcontract,theadditionalrightssetforthinFAR52.227-19,CommercialComputerSoftwareLicense(December2007).OracleUSA,Inc.,500OracleParkway,RedwoodCity,CA94065.Thissoftwareisdevelopedforgeneraluseinavarietyofinformationmanagementapplications.Itisnotdevelopedorintendedforuseinanyinherentlydangerousapplications,includingapplicationswhichmaycreateariskofpersonalinjury.Ifyouusethissoftwareindangerousapplications,thenyoushallberesponsibletotakeallappropriatefail-safe,backup,redundancy,andothermeasurestoensurethesafeuseofthissoftware.OracleCorporationanditsaffiliatesdisclaimanyliabilityforanydamagescausedbyuseofthissoftwareindangerousapplications.OracleisaregisteredtrademarkofOracleCorporationand/oritsaffiliates.Othernamesmaybetrademarksoftheirrespectiveowners.Thissoftwareanddocumentationmayprovideaccesstoorinformationoncontent,products,andservicesfromthirdparties.OracleCorporationanditsaffiliatesarenotresponsibleforandexpresslydisclaimallwarrantiesofanykindwithrespecttothird-partycontent,products,andservices.OracleCorporationanditsaffiliateswillnotberesponsibleforanyloss,costs,ordamagesincurredduetoyouraccesstooruseofthird-partycontent,products,orservices.iiiContentsPreface.................................................................................................................................................................vAudience.......................................................................................................................................................vDocumentationAccessibility.....................................................................................................................vRelatedDocumentation..............................................................................................................................viWheretoFindDatabaseTuningDocumentation..................................................................................viConventions................................................................................................................................................viiWhat'sNewinOracleDataMiningAdministration?...............................................................ixOracleDatabase11gRelease2(11.2.0.2)NewFeaturesinOracleDataMining................................ixOracleDatabase11gRelease1(11.1)NewFeaturesinOracleDataMining......................................ix1GettingStartedwithOracleDataMiningStepOne:InstalltheDatabase..............................................................................................................1-1StepTwo:VerifytheDataMiningInstallation..................................................................................1-2StepThree:CreateaDataMiningUser...............................................................................................1-2StepFour:InstallandLaunchOracleDataMiner.............................................................................1-3StepFive:InstallandLaunchtheSpreadsheetAdd-In....................................................................1-3StepSix:IfYouWanttoUsetheSamplePrograms...........................................................................1-42InstallingOracleDataMiningInstallOracleDatabase...........................................................................................................................2-1VerifytheDataMiningInstallation.....................................................................................................2-9InstallOracleDatabaseExamples...................................................