使用toad导出数据结构

1、使用toad导出数据结构EditorDEVICEDXBG_BA5EOPTIOW51.登录需要导出的数据库2.database-export-GenerateSchemaScriptDebugVewUtiitieseKzWindowHelp第FiteEditSearchGridEditorSessionCDRCHARGETVPECOTJTEfJTFILTERCOTJTENTFILTEROPTIONSOATAENCODINtSCONVERTmnNameK)Interrw嘿DataHumpExportWizardDataSubsetWizard舅ExportDDLExportEileBrowser锢

2、ExportUtilityWizard*GenerateDatabaseScriptTab!曰己5FlatFfe.SchemaBrowserADVAMCEDOP'TIONSAREAINFOBASICOPT1ON5CALLEEAUTHROUTEPOLICYCALLEE5TAMDARDJZAT1ONCALLERAUTHPOLICVCALLERSTAMDARDIZATIOfJOTablM利郎号|石书Synonymsf()加ndImportMonitorOptimizeReportSpoolSQLAdministerCompareCreateDiagnosemr>£Indexe

3、sCarstrairtsTriggersEMSP.SHToadforOracle-LEISP_SHai72.16.1.207:15Zl/oralOSchemaBrovser(EISDatabaseGenerateSchemaScriptExpert3.每个子菜单选项如下SourceandOutputOfajMtTypasObjMr5ttFiters中tOption5®ExtractFrom5ch«na0ExtractFromSchetnadefinitionFfc回5e叫DOLlAhencompleta“隆叫ObjectTree网hencomplete-ANONYMOU5：

4、CTX5V5DB5NMPDIPDM5Y5：EM5A5ADDLFilename。何5P_5H曰EJ|MakeonefieQamedafterKchschemainthisdrectcryDafinftionFilename:D:EM5P_5H.(fefEMF5Y5LJD?LJAFilT：1IM!IEKMDDATAMD5YSMGMTJflEWOLAPSVSORACLE.OOMORDPLUGINSORD5V5：OUTLNPRECISE一SCOTTSIinformschemasvs5rsMANFl5Y5TEM-1_-1DeFfileMilbeusedforHTMLsctemadocgeneration

5、0CreateIndividualObjettDDLFiles*Use5QLextensionforallfilesUbfrxtert$iiion器configuredInTOADoptionsUserelativepathintuildall”scriptTopLevelDirectory:nandOdtput|OfejKtTypesobjectSet|yters|Options_User!二IUser'sdefaultthlspace二|User'stemporarytblspace_Alltablespacescontaininguser'sobjects口Use

6、r'srolesUserysprofile匚LJoRecydeBinObjsdAuditsonObjectsAll.OnSelectedObj.Types匚Auditson5QL/5ysPrivsQdustert0Constrarts0Check回ForeignKay叵PrimaryKey:IUniqueKey匚Contejds回。日Links匚DimensionsDirectories0Frictions回营询tsOOnSelactsdObj.Types0IndexesJav4ClassJavaResourceisviSourceJobs0西<年博50MaterializedV

7、iewsIICommahtQColumnCommentsEMaterialized¥tewLogsQOutlines回P征臣产叵PackageBodies0Partitims12PoliciesQPolicyQvupsPIPracBdi>esQueuesQusueTablesQRefreshGroupsSchsdJerChainsQSchediferProgramsQSchsdJerSchedKSchediierJobs0SequencesSynonynis(Private)Sj/nonymfi(Public)llTablMCommentsCokmnCommentsQTrigg

8、ers21Types；TypeBodss0ViewsnCcftwnantsCokinnComnierits注：导由时，一定要手动选择JOBS、partitions>policies>procedures、sequencestriggers>tables(comments>columncomments)>views(comments、columncomments):用能等券潴嘲。宣回瞳俵”徐不出圈FieEditSearchGridEditorSessionDatabaseDebugViewUtilitieseBizV自量t>SourceandOutputObj

9、ectTypesObjectSetIFilters|ScriptOptiore)SpecifyObjectSet(Optional)SourceandOutputObjectTypesObjectSetEntersScriptOptionsAllObjects§niExtract。廿e。Namesh记.：INOTLikeOCaseSensitiveTablesAlTablespacesvIIncludeTablespace=NullIndexesAlTablespacesv口IncludeTablespace=NullandOutputObjectTypes.Obj耻159”日忸&q

10、uot;ScriptOptionsGeneralScriptOptionsObjectswithStorageGonstraintsOtherObjectsGeneralScriptOptions 5ortforCreation IncludeMSetDefineOFF"IncludeDropstatementsDropTableswithPurgeOption问IncludeH5hu网Ernors"aFterprocsandtriggersSQL*PIle"Prompt"commentsinscript Alwaysuse'/toendSQLs

11、tatements Onelineperstatement|CommentsinScript_IListDependencies-IIrdudeCounts1|IncludeSchemaNamePrefixforObjects二SubstituteThisfortheSchemaName:4.单机执行按钮导出«FileEditSearchGridEditorSessionDatabaseDebuSourceandOutputObjectTypesObjectSetFiltersScriptOptions5.执行完成后结果如下图SoireeandCH*pi*ObjectTypesObj

12、ectSet日tcrsStreitOptionsObjectTreeSelectandright-ckkrow&Fc<actions* Functions1)* Indrsesd?7)* Procedixes(4)* Sequences(43* Ta#5值用)+Triggers(102)系View(14)6.导出drop的方法注：用这种方法导出的数据结构不带drop,若需要带drop,则在以下选项卡中勾选以下两项：Includedropstatements;droptableswithpurgeoption；SourceandOutputObjectTypesObjectSetFiltersScriptOptionsGeneralScriptOptionsObjectswithStorageConstraintsOtherObjects:GeneralScriptOptionsj口SortforCreation口IncludeHSetDefineOff"口IncludeDropStatements口DropTableswithPurgeOption0Include“ShowErrors11afterprocsandtriggers