Edit D:\rfid\database\database\doc\owb.112\e10579\change_mgmt.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html lang="en" xml:lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Language" content="en" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <meta name="robots" content="all" scheme="http://www.robotstxt.org/" /> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = document) - Version 5.1" /> <meta name="Date" content="2009-07-31T16:48:26Z" /> <meta name="doctitle" content="Oracle® Warehouse Builder Installation and Administration Guide 11g Release 2 (11.2) for Windows and Linux" /> <meta name="partno" content="E10579-01" /> <meta name="docid" content="WBINS" /> <link rel="Start" href="../../index.htm" title="Home" type="text/html" /> <link rel="Copyright" href="../../dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="Stylesheet" href="../../dcommon/css/blafdoc.css" title="Default" type="text/css" /> <script type="text/javascript" src="../../dcommon/js/doccd.js"> </script> <link rel="Contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="Index" href="index.htm" title="Index" type="text/html" /> <link rel="Prev" href="content_mgmt.htm" title="Previous" type="text/html" /> <link rel="Next" href="security_mgmt.htm" title="Next" type="text/html" /> <link rel="alternate" href="../e10579.pdf" title="PDF version" type="application/pdf" /> <title>Using the Metadata Loader</title> </head> <body> <div class="header"> <div class="zz-skip-header"><a name="top" id="top" href="#BEGIN">Skip Headers</a></div> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td align="left" valign="top"><b>Oracle® Warehouse Builder Installation and Administration Guide<br /> 11<i>g</i> Release 2 (11.2) for Windows and Linux</b><br /> Part Number E10579-01</td> <td valign="bottom" align="right"> <table class="icons oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="245"> <tr> <td align="center" valign="top"><a href="../../index.htm"><img width="24" height="24" src="../../dcommon/gifs/doclib.gif" alt="Go to Documentation Home" /><br /> <span class="icon">Home</span></a></td> <td align="center" valign="top"><a href="../../nav/portal_booklist.htm"><img width="24" height="24" src="../../dcommon/gifs/booklist.gif" alt="Go to Book List" /><br /> <span class="icon">Book List</span></a></td> <td align="center" valign="top"><a href="toc.htm"><img width="24" height="24" src="../../dcommon/gifs/toc.gif" alt="Go to Table of Contents" /><br /> <span class="icon">Contents</span></a></td> <td align="center" valign="top"><a href="index.htm"><img width="24" height="24" src="../../dcommon/gifs/index.gif" alt="Go to Index" /><br /> <span class="icon">Index</span></a></td> <td align="center" valign="top"><a href="../../dcommon/html/feedback.htm"><img width="24" height="24" src="../../dcommon/gifs/feedbck2.gif" alt="Go to Feedback page" /><br /> <span class="icon">Contact Us</span></a></td> </tr> </table> </td> </tr> </table> <hr /> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td align="left" valign="top"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="98"> <tr> <td align="center" valign="top"><a href="content_mgmt.htm"><img width="24" height="24" src="../../dcommon/gifs/leftnav.gif" alt="Go to previous page" /><br /> <span class="icon">Previous</span></a></td> <td align="center" valign="top"><a href="security_mgmt.htm"><img width="24" height="24" src="../../dcommon/gifs/rightnav.gif" alt="Go to next page" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </td> <td align="right" valign="top" style="font-size: 90%"><a href="../e10579.pdf">View PDF</a></td> </tr> </table> <a name="BEGIN" id="BEGIN"></a></div> <div class="IND"><!-- End Header --><a id="BABHCIDB" name="BABHCIDB"></a><a id="WBINS12000" name="WBINS12000"></a> <h1 class="chapter"><span class="secnum">12</span> Using the Metadata Loader</h1> <p>This section discusses change and version management with Metadata Loader. The Metadata Loader utility copies and moves all types of metadata objects in a repository. With this utility, you can move metadata between Oracle Warehouse Builder repositories that reside on platforms with different operating systems. You can use the Design Center to run the Metadata Loader utilities. The Design Center provides a graphical interface that guides you through the process of exporting and importing metadata.</p> <p>This section contains the following topics:</p> <ul> <li> <p><a href="#BABEAIEH">Exporting Metadata from the Design Center</a></p> </li> <li> <p><a href="#BABFJDIG">Importing Metadata Using the Design Center</a></p> </li> <li> <p><a href="#BABCFBBC">Upgrading Metadata from Earlier Releases</a></p> </li> <li> <p><a href="#BABJJGFF">Metadata Loader Utilities</a></p> </li> <li> <p><a href="#BABDAJIJ">Multiple Session Concurrency and MDL</a></p> </li> <li> <p><a href="#BABIIJAI">Metadata Loader Log File</a></p> </li> <li> <p><a href="#BABHBDHG">About Metadata Loader Results</a></p> </li> <li> <p><a href="#BGBBJJFE">Managing Versions and History with the Metadata Loader</a></p> </li> </ul> <a id="BABEAIEH" name="BABEAIEH"></a><a id="WBINS16232" name="WBINS16232"></a> <div class="sect1"> <h2 class="sect1"><a id="sthref576" name="sthref576"></a>Exporting Metadata from the Design Center</h2> <p>You can use Design Center to export objects from a workspace into an MDL file. This includes objects that are part of the Project Navigator, Locations Navigator, and Globals Navigator. The information related to the exported objects, such as table columns and their constraints, data loading configuration parameters, and named attribute sets, are also exported.</p> <p>Before you attempt to export metadata, ensure you have <code>READ</code> privileges on any object that you want to export. You also need to have <code>READ</code> privileges on folder objects. If you do not have <code>READ</code> privileges on a folder object, such as projects or modules, the folder object and all objects that it contains are not exported. During an export, the Metadata Export Utility skips objects for which you do not have <code>READ</code> privileges. It logs information about the list of objects that have not been exported due to lack of security privileges. See <a href="#BABIIJAI">"Metadata Loader Log File"</a> for details about viewing the list of objects that were not exported.</p> <p>By default, <code>READ</code> privileges are provided on all the workspace objects to all registered users. See <a href="#BABGDDJC">"Export Advanced Options Dialog Box"</a> if you want to export security information such as users, roles, role assignments, and object privileges.</p> <p>You have two options for exporting metadata. You could either export the entire design or you could export selected objects in the workspace. If you want to export selected objects, then those objects must be within the same navigator. For example, you cannot export a table from the Project Navigator and a public transformation from the Globals Navigator at the same time; you must export them in two separate steps.</p> <p>Before starting the export operation, take care of the following:</p> <ul> <li> <p>Ensure the destination computer has sufficient disk storage. If there is insufficient disk space, the export fails. The destination computer must be able to contain the entire metadata file, because the export utility cannot save portions of the metadata file.</p> </li> <li> <p>Ensure that you are the only user accessing the objects to be exported. To ensure that you are exporting the most up-to-date metadata, it is advisable to ask all other users to log out of the workspace. See <a href="#BABDAJIJ">"Multiple Session Concurrency and MDL"</a>.</p> </li> </ul> <a id="WBINS16233" name="WBINS16233"></a> <p class="subhead2">To export metadata from a workspace using the Design Center:</p> <ol> <li> <p>From the Design Center, select the object or objects you want to export.</p> <p>You can select multiple objects by holding down the <span class="bold">Control</span> key and selecting the objects.</p> <p>Note that you may export individual objects such as tables, or groups of objects. When you export projects nodes, or modules, you also export the objects they contain. When you export collections, you also export the objects they reference.</p> </li> <li> <p>From the <span class="bold">File</span> menu, select <span class="bold">Export</span> and then <span class="bold">Warehouse Builder Metadata</span>.</p> <img width="446" height="274" src="img/exporting_01.gif" alt="Description of exporting_01.gif follows" title="Description of exporting_01.gif follows" longdesc="img_text/exporting_01.htm" /><br /> <a id="sthref577" name="sthref577" href="img_text/exporting_01.htm">Description of the illustration exporting_01.gif</a><br /> <br /></li> <li> <p>[Optional] If you made changes to the repository metadata prior to running the export utility, a warning dialog box is displayed.</p> <p>Click <span class="bold">Save</span> to save changes or <span class="bold">Revert</span> to revert to the previously saved version.</p> <img width="290" height="140" src="img/exporting_02.gif" alt="Description of exporting_02.gif follows" title="Description of exporting_02.gif follows" longdesc="img_text/exporting_02.htm" /><br /> <a id="sthref578" name="sthref578" href="img_text/exporting_02.htm">Description of the illustration exporting_02.gif</a><br /> <br /></li> <li> <p>In the Metadata Export Dialog Box:</p> <ul> <li> <p>Click <span class="bold">Browse</span> to specify the <span class="bold">File Name</span> (name and location) of the export file.</p> </li> <li> <p>Click <span class="bold">Browse</span> to specify the <span class="bold">Log File</span> (name and location).</p> </li> <li> <p>[Optional] Under <span class="bold">Annotations</span>, enter comments about the export file.</p> </li> <li> <p>[Optional] Check <span class="bold">Export all object dependencies</span> if you are also exporting all the dependencies of the exported objects.</p> </li> <li> <p>[Optional] Click <span class="bold">Advanced</span> to export additional metadata. See <a href="#BABGDDJC">"Export Advanced Options Dialog Box"</a>.</p> </li> </ul> <p>See <a href="#BABBFCJJ">"Metadata Export Dialog Box"</a>.</p> </li> <li> <p>Click <span class="bold">Export</span>.</p> </li> <li> <p>When the export completes successfully (see <a href="#BABEDAAJ">"Metadata Progress Dialog Box"</a>), in the Metadata Export Dialog box, click <span class="bold">OK</span>.</p> </li> </ol> </div> <!-- class="sect1" --> <a id="BABFJDIG" name="BABFJDIG"></a><a id="WBINS16241" name="WBINS16241"></a> <div class="sect1"> <h2 class="sect1"><a id="sthref579" name="sthref579"></a>Importing Metadata Using the Design Center</h2> <p>You can use the Design Center to import metadata. The Metadata Import Utility also automatically upgrades metadata that was created using an earlier version of Warehouse Builder to the current version. See <a href="#BABCFBBC">"Upgrading Metadata from Earlier Releases"</a> for more information about upgrading metadata.</p> <p>To prepare for importing metadata, you must take care of the following:</p> <ul> <li><a id="BABGAHHE" name="BABGAHHE"></a> <p><a id="sthref580" name="sthref580"></a><a id="sthref581" name="sthref581"></a><span class="bold">Required Access Privileges:</span> To import metadata, the user performing the import must have the following privileges:</p> <ul> <li> <p><code>EDIT</code> privilege on existing objects that are being replaced by the import.</p> </li> <li> <p><code>CREATE</code> privilege on existing folder objects under which new objects are created by the import.</p> </li> </ul> <p>By default, the <code>FULL_CONTROL</code> privilege is assigned on all workspace objects to registered users. The Metadata Import Utility skips objects for which the user importing metadata does not have the required privileges. The list of objects that have not been imported due to security privileges are logged in the Metadata Loader Log File. See <a href="#BABIIJAI">"Metadata Loader Log File"</a></p> <p>You can import security information such as users and roles. When importing user metadata, if a corresponding database user does not exist for a user, the import fails and an error message is written to the Metadata Loader Log File. See <a href="#BABIIFEG">"Import Advanced Options Dialog Box"</a> for information about importing security information such as users and roles, and <a href="#BABIIJAI">"Metadata Loader Log File"</a>.</p> <p>Because the Metadata Import Utility alters the repository, the metadata objects must be locked prior to importing. See <a href="#BABDAJIJ">"Multiple Session Concurrency and MDL"</a>.</p> </li> <li> <p><span class="bold">Backup of Current Workspace:</span> Consider making a backup of your existing workspace, either in the form of an export or a metadata snapshot, before attempting a large or complex import.</p> </li> <li> <p><span class="bold">Multiple Language Support Base Language Compatibility:</span> The base language is the default language used in the repository and is set using the Repository Assistant during installation. You cannot alter this setting after installing the repository. See <a href="#BABHGJCI">"Languages"</a> for more information about setting the base language in a repository.</p> </li> </ul> <a id="WBINS16244" name="WBINS16244"></a> <div class="sect2"><a id="sthref582" name="sthref582"></a> <h3 class="sect2">Importing Objects</h3> <a id="WBINS16245" name="WBINS16245"></a> <p class="subhead2">To import objects from an export file using the Design Center:</p> <ol> <li> <p>From the Design Center, select <span class="bold">File</span>, select <span class="bold">Import</span>, and then select <span class="bold">Warehouse Builder Metadata</span>.</p> <img width="446" height="293" src="img/importing_01.gif" alt="Description of importing_01.gif follows" title="Description of importing_01.gif follows" longdesc="img_text/importing_01.htm" /><br /> <a id="sthref583" name="sthref583" href="img_text/importing_01.htm">Description of the illustration importing_01.gif</a><br /> <br /></li> <li> <p>[Optional] If you had made changes to the repository metadata prior to running the import utility, a warning dialog box is displayed.</p> <p>Click <span class="bold">Save</span> to save changes or <span class="bold">Revert</span> to revert to the previously saved version.</p> <img width="290" height="141" src="img/importing_02.gif" alt="Description of importing_02.gif follows" title="Description of importing_02.gif follows" longdesc="img_text/importing_02.htm" /><br /> <a id="sthref584" name="sthref584" href="img_text/importing_02.htm">Description of the illustration importing_02.gif</a><br /> <br /></li> <li> <p>In the Metadata Import dialog box:</p> <ul> <li> <p>Click <span class="bold">Browse</span> to specify the <span class="bold">File Name</span> (name and location) of the import file.</p> </li> <li> <p>Click <span class="bold">Browse</span> to specify the <span class="bold">Log File</span> (name and location).</p> </li> <li> <p>Under <span class="bold">Object Selection</span>, choose either <span class="bold">Import all objects from file</span> or <span class="bold">Import selected objects from file</span>.</p> </li> <li> <p>Under <span class="bold">Import Option</span>, select one of <span class="bold">Create new metadata only</span>, <span class="bold">Update metadata replace existing objects and create new metadata</span>, <span class="bold">Merge metadata merge existing objects and create new metadata</span>, or <span class="bold">Replace existing objects only</span>.</p> </li> <li> <p>Under <span class="bold">Match by</span>, select one of <span class="bold">Universal Identifier</span> or <span class="bold">Names</span>.</p> </li> <li> <p>[Optional] Click <span class="bold">Show Summary</span> to view a summary of the contents of the export file. See <a href="#BABIBAAG">"File Summary Dialog Box"</a>.</p> </li> <li> <p>[Optional] Click <span class="bold">Advanced</span> to import metadata for additional languages, security information, or user-defined properties. See <a href="#BABIIFEG">"Import Advanced Options Dialog Box"</a>.</p> </li> </ul> <p>See <a href="#BABFHAGA">"Metadata Import Dialog Box"</a>.</p> </li> <li> <p>Click <span class="bold">Import</span>.</p> </li> <li> <p>The Metadata Import Progress dialog box is displayed; it indicates the progress of the import. Note that you can cancel an in-progress Metadata Import by clicking <span class="bold">Cancel</span>. See <a href="#BABEDAAJ">"Metadata Progress Dialog Box"</a>.</p> </li> </ol> <p>If the MDL file that you selected for import was created using an earlier version of Warehouse Builder, clicking <span class="bold">Show Summary</span>, <span class="bold">Advanced</span>, or <span class="bold">Import</span> displays the Metadata Upgrade dialog box. This dialog box enables you to automatically upgrade the selected MDL file to the current version of Warehouse Builder. For more information about this dialog, see <a href="#BABJIHJH">"Metadata Upgrade Dialog Box"</a>.</p> </div> <!-- class="sect2" --> <a id="WBINS16252" name="WBINS16252"></a> <div class="sect2"><a id="sthref585" name="sthref585"></a> <h3 class="sect2"><a id="sthref586" name="sthref586"></a>Combining Import Modes and Matching Criteria</h3> <p>Each search method used as matching criteria may be combined with an import mode. Each combination offers different results in the import process. The mode that you select determines how the metadata import utility searches for metadata objects in the workspace, prior to importing.</p> <p>For example, if the search is by the name of a repository object in the export file, the Metadata Import Utility searches the workspace for the object's name. If an object with the corresponding name is not found, the resulting actions are based on the import mode you select.</p> <p><a href="#BABBHGCH">Table 12-1</a> describes what happens in the available import modes for repository objects that either match or do not match the object names.</p> <div class="tblformal"><a id="WBINS16253" name="WBINS16253"></a><a id="sthref587" name="sthref587"></a><a id="BABBHGCH" name="BABBHGCH"></a> <p class="titleintable">Table 12-1 Import Mode Results</p> <table class="Formal" title="Import Mode Results" summary="This table contains three columns. The first column lists the import mode. The second column describes the result when the object name in the MDL file matches object names in the repository. The third column describes the result when the object name in the MDL file does not match any object name in the repository." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="18%" /> <col width="40%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t2">Import Mode</th> <th align="left" valign="bottom" id="r1c2-t2">Result Using Matching Names</th> <th align="left" valign="bottom" id="r1c3-t2">Result Not Using Matching Names</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t2" headers="r1c1-t2"> <p>Create Mode</p> </td> <td align="left" headers="r2c1-t2 r1c2-t2"> <p>A message is written to the log file that the object exists, and the object is skipped.</p> </td> <td align="left" headers="r2c1-t2 r1c3-t2"> <p>A new object is created.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t2" headers="r1c1-t2"> <p>Replace Mode</p> </td> <td align="left" headers="r3c1-t2 r1c2-t2"> <p>The object is replaced.</p> </td> <td align="left" headers="r3c1-t2 r1c3-t2"> <p>A warning message is written to the log file that the object cannot be replaced because it does not exist in the workspace. The object is skipped.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t2" headers="r1c1-t2"> <p>Update Mode</p> </td> <td align="left" headers="r4c1-t2 r1c2-t2"> <p>The object is replaced.</p> </td> <td align="left" headers="r4c1-t2 r1c3-t2"> <p>A new object is created.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t2" headers="r1c1-t2"> <p>Merge Mode</p> </td> <td align="left" headers="r5c1-t2 r1c2-t2"> <p>The object is merged.</p> </td> <td align="left" headers="r5c1-t2 r1c3-t2"> <p>A new object is created.</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <p>The MDL reads and processes the imported metadata and writes status and diagnostic information in the log file.</p> </div> <!-- class="sect2" --> <a id="BABDIAAH" name="BABDIAAH"></a><a id="WBINS16255" name="WBINS16255"></a> <div class="sect2"> <h3 class="sect2"><a id="sthref588" name="sthref588"></a><a id="sthref589" name="sthref589"></a>Import Different Base Languages</h3> <p>When you import metadata in multiple languages, the language settings in the target repository may be different from the language settings in the export file. For example, the target repository may have the base language as English and additional language as French and German. But the export file may have the base language as French and additional language as English and German. This section describes how the MDL handles these conditions.</p> <a id="WBINS16256" name="WBINS16256"></a> <div class="sect3"><a id="sthref590" name="sthref590"></a> <h4 class="sect3">Different Base Languages in the Import File and Target Repository</h4> <p>When you import metadata, MDL compares the ISO identification of the base language in the import file with the ISO identification of the base language of the target repository. The ISO identification consists of the language ID followed by the locale, in the format <code><span class="codeinlineitalic">language_locale</span></code>. For example, <code>en_US</code> is American English and <code>fr_FR</code> is French.</p> <p>If the base ISO identification languages are different, MDL displays a warning dialog box informing you that the base languages are different and warns you that Oracle recommends that you import metadata with the same character set and base language. You have the option to continue with the import. Click <span class="bold">Yes</span> to continue with the import. Click <span class="bold">No</span> to cancel the import.</p> <p>Note that under certain circumstances, continuing to import metadata when the base languages are different may lead to corruption of the metadata being imported. Oracle recommends that you move metadata between repositories with the same character set and base languages.</p> <p>If the base ISO identification languages are the same, but the locales are different, the Metadata Import Utility displays a warning dialog box to determine whether you want to continue with the import. For example, the export file contains English and the base language of the repository is American English. Click <span class="bold">Yes</span> to import metadata, or click <span class="bold">No</span> to cancel the import.</p> </div> <!-- class="sect3" --> <a id="WBINS16257" name="WBINS16257"></a> <div class="sect3"><a id="sthref591" name="sthref591"></a> <h4 class="sect3">Importing Supported Languages</h4> <p>During the import, MDL checks if the additional languages in the import file exist in the target repository. If the import file contains additional languages that do not exist in the target repository, and you specify that these additional languages are to be imported, the Metadata Import utility writes a warning message in the MDL log file stating that the additional languages are not installed in the repository.</p> </div> <!-- class="sect3" --></div> <!-- class="sect2" --> <a id="WBINS16258" name="WBINS16258"></a> <div class="sect2"><a id="sthref592" name="sthref592"></a> <h3 class="sect2"><a id="sthref593" name="sthref593"></a><a id="sthref594" name="sthref594"></a>Import Validation Rules</h3> <p>When you import a set of definitions from previously exported metadata, the import utility updates existing definitions within a project. However, certain metadata definitions require attention to ensure that they are updated correctly. The following are examples of some of the errors you may see:</p> <ul> <li> <p><span class="bold">Mapping Definitions.</span> The Metadata Import Utility binds imported mapping operators to their physical objects if the associated objects exist in the workspace. However, if the associated physical objects do not exist in the workspace, the imported mapping operators are not bound. The Metadata Import Utility writes a warning message in the log file, which states that the mapping operators are not bound. You must then synchronize the new mapping operators with the physical objects they represent.</p> </li> <li> <p><span class="bold">Foreign Key Definitions.</span> It is possible that a source MDL file contains foreign key references to unique or primary keys that are not in the target workspace. If the referenced unique or primary keys for any foreign key appearing in the MDL file do not exist in the target workspace, the MDL Import Utility writes a warning message in the log file, which states that the workspace does not contain a referenced key for the foreign key.</p> </li> </ul> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="BABCFBBC" name="BABCFBBC"></a><a id="WBINS16259" name="WBINS16259"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><a id="sthref595" name="sthref595"></a>Upgrading Metadata from Earlier Releases</h2> <p>While importing metadata, the Metadata Import Utility automatically upgrades metadata created using earlier releases to Oracle Warehouse Builder 11<span class="italic">g</span> Release 2 (11.2). You do not have to manually upgrade the metadata from a previous release of Warehouse Builder.</p> <p>When you import an MDL file, the version used to create the file is automatically detected. If the MDL file was created using an earlier release of Oracle Warehouse Builder, the Metadata Upgrade dialog box is displayed. This dialog box enables you to upgrade the MDL file to the current version. See <a href="#BABJIHJH">"Metadata Upgrade Dialog Box"</a>.</p> <p>If you import an <code>.mdl</code> file that contains metadata for gateway modules (such as DB2 or Informix) from an older version of Warehouse Builder, the file may not import the metadata into the corresponding source module folders of a project. These imported files are stored under the Others node in the Project Navigator. You must manually copy the metadata for the gateway modules into the correct source module folders.</p> <p>The production versions of Warehouse Builder from which metadata is automatically upgraded to Oracle Warehouse Builder 11<span class="italic">g</span> Release 2 (11.2) are as follows:</p> <ul> <li> <p>Oracle Warehouse Builder 9.2</p> </li> <li> <p>Oracle Warehouse Builder 10<span class="italic">g</span> Release 1</p> </li> <li> <p>Oracle Warehouse Builder 10<span class="italic">g</span> Release 2</p> </li> <li> <p>Oracle Warehouse Builder 11<span class="italic">g</span> Release 1</p> </li> </ul> <p>If you must upgrade an MDL file from an older version of OWB, you must first upgrade it to one of OWB 9.2, 10.1, 10.2, or 11.1, and then upgrade this intermediate MDL file to OWB 11.2.</p> <a id="WBINS16261" name="WBINS16261"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --><a id="sthref596" name="sthref596"></a> <h3 class="sect2">Changes to Workspace Objects When Upgrading from OWB 9.2</h3> <p>When you upgrade from OWB 9.2, the upgrade utility makes the following changes to objects in the workspace:</p> <ul> <li> <p><span class="bold">Dimension and Cube Mapping Operators:</span> The mapping operators for dimensions and cubes are converted to table operators. These table operators use the physical tables created by the MDL Upgrade Utility for dimensions and cubes.</p> </li> <li> <p><span class="bold">Dimensions:</span> An associated dimension table is created with the same name as the dimension. The table contains the columns, constraints, and attribute sets defined in the Dimension Editor Table Properties of the dimension in the previous release.</p> </li> <li> <p><span class="bold">Mapping Display Sets for Dimension Hierarchies:</span> Any mapping sets originally created based on the named attribute set for a dimension hierarchy are removed. This is because display sets for dimension hierarchies are no longer automatically created and maintained.</p> </li> <li> <p><span class="bold">Dimension Attributes:</span> For each level attribute upgraded, a dimension attribute with the same name is created, if it does not exist in the dimension.</p> </li> <li> <p><span class="bold">Cubes:</span> An associated cube table is created with the same name as the cube. The cube table contains columns, constraints, and attribute sets defined in the Cube Editor Table Properties of the cube in the previous release.</p> </li> <li> <p><span class="bold">Intelligence Objects and Reports:</span> In the previous release, intelligence objects and reports were available only using OMB Plus scripting. These objects are not upgraded.</p> </li> <li> <p><span class="bold">Locations and Control Center Connections:</span> Locations and Control Center connections are moved out of the projects that own them so that they can be shared across the entire workspace. Thus the statistics in the import log file displays an additional project for these objects.</p> </li> <li> <p><span class="bold">Control Centers and Locations:</span> After an upgrade, there is no association between the locations and the control centers that they reference. You must review the control center details using the Edit Control Center dialog box and select the locations associated with this control center.</p> </li> <li> <p><span class="bold">Advanced Queues:</span> An associated queue table is created based on the property AQ queue table name. The queue table created by the MDL File Upgrade Utility contains a column whose data type is the object type for that advanced queue.</p> </li> <li> <p><span class="bold">Advanced Queue Operator in a Mapping:</span> Mapping Advanced Queue operators are changed to contain only one attribute called <code>PAYLOAD</code>. For Mapping Advanced Queue operators that are used as a source, a new Expand operator is added after the Mapping Advanced Queue operator. For Mapping Advanced Queue operators that are used as a target, a new Construct operator is added before the Mapping Advanced Queue operator.</p> </li> <li> <p><span class="bold">Mapping Operator Names:</span> The MDL Upgrade Utility ensures that the physical names and business names of all mapping operators are unique.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="WBINS16348" name="WBINS16348"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --><a id="sthref597" name="sthref597"></a> <h3 class="sect2">Changes to Workspace Objects When Upgrading from OWB 10.1, 10.2 or 11.1</h3> <p>When you upgrade from OWB 10.1, 10.2, or 11.1 to OWB 11.2, the upgrade utility makes the following changes to objects in the workspace:</p> <ul> <li> <p><span class="bold">Mapping Table Function Operators:</span> The mapping operators for table functions are upgraded to have only one input group and one output group. Old input groups that were configured as a <code>REF</code> cursor type are upgraded to a <code>SYS_REFCURSOR</code> type, and a new construct operator is added to the map; its input group values are the same as in the <code>REF</code> cursor type input group, and the output group attribute is set to <code>SYS_RECURSOR</code> type.</p> </li> <li> <p><span class="bold">Mapping Key Lookup Operators:</span> The mapping operators for key lookups are upgraded to the new lookup operator.</p> </li> <li> <p><span class="bold">Stream Capture Process Objects:</span> Stream capture process objects are not upgraded.</p> </li> <li> <p><span class="bold">Business Presentation Modules:</span> Business presentation modules and their contents are not upgraded.</p> </li> <li> <p><span class="bold">BI Beans Locations:</span> BI beans locations are not upgraded.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="WBINS16262" name="WBINS16262"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --><a id="sthref598" name="sthref598"></a> <h3 class="sect2">Checking for Warnings and Error Messages</h3> <p>After upgrading the metadata, check the log file for warnings and errors.</p> <ul> <li> <p>If you receive warnings during the upgrade, the upgrade utility completes and logs the warnings. If you receive errors, the upgrade utility terminates and logs the errors.</p> </li> <li> <p>If warnings and errors are shown after an upgrade, search for the words Warning and Error in the log file to determine the problem.</p> </li> <li> <p>If an unexpected error occurs and the upgrade terminates, the log file contains the details. Check your log file or contact Oracle Support.</p> </li> </ul> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <div class="sect1"><!-- infolevel="all" infotype="General" --><a id="sthref599" name="sthref599"></a> <h2 class="sect1">Design Center Metadata Management Dialog Boxes</h2> <p>The Design Center uses several dialogs to manage metadata export, import, and upgrade. These are:</p> <a id="BABBFCJJ" name="BABBFCJJ"></a><a id="WBINS16236" name="WBINS16236"></a> <div class="sect2"> <h3 class="sect2">Metadata Export Dialog Box</h3> <p>The Metadata Export dialog box displays the names and the types of the exported objects.</p> <img width="588" height="411" src="img/exporting_03.gif" alt="Description of exporting_03.gif follows" title="Description of exporting_03.gif follows" longdesc="img_text/exporting_03.htm" /><br /> <a id="sthref600" name="sthref600" href="img_text/exporting_03.htm">Description of the illustration exporting_03.gif</a><br /> <br /> <p>The Metadata Export dialog box also contains the following items:</p> <ul> <li> <p><span class="bold">Annotations:</span> Use this field to enter any comments about the file that contains the exported objects.</p> </li> <li> <p><span class="bold">File Name:</span> Displays a default path and file name for the export file. You can retain this default or specify a directory and file name. Type the name of the export file to create or click <span class="bold">Browse</span> to locate a directory or file. The file name extension commonly used is <code>.mdl</code>.</p> </li> <li> <p><span class="bold">Log File:</span> Use this field to specify the file name and path for the log file that stores diagnostic and statistical information about the export. See <a href="#BABIIJAI">"Metadata Loader Log File"</a></p> </li> <li> <p><span class="bold">Export all object dependencies:</span> Select this option to export all the dependencies of the objects being exported. For example, when you export a table, the location to which the table is deployed is also exported.</p> <p>Note that public objects such as locations, public transformations, public experts, public icon sets, or public data rules belong to a project called <code>PUBLIC_PROJECT</code>. You can export the <code>PUBLIC_PROJECT</code> and its objects if the selected exported objects have a dependency on the public objects and if you select the <span class="bold">Export all object dependencies</span> option.</p> </li> <li> <p><span class="bold">Advanced:</span> Use the Advanced button to export additional metadata such as user-defined properties, security information, and additional languages. See <a href="#BABGDDJC">"Export Advanced Options Dialog Box"</a>.</p> </li> </ul> <p>Click <span class="bold">Export</span> to export the metadata for the selected objects. The Metadata Export Progress dialog box is displayed. See <a href="#BABBFCJJ">"Metadata Export Dialog Box"</a> for more information about the contents of this dialog box.</p> </div> <!-- class="sect2" --> <a id="BABGDDJC" name="BABGDDJC"></a><a id="WBINS16238" name="WBINS16238"></a> <div class="sect2"> <h3 class="sect2">Export Advanced Options Dialog Box</h3> <p>Use the Export Advanced Options dialog box to export any of the following:</p> <ul> <li> <p>Additional language metadata</p> </li> <li> <p>User-defined definitions</p> </li> <li> <p>Security information</p> </li> </ul> <img width="500" height="445" src="img/exporting_04.gif" alt="Description of exporting_04.gif follows" title="Description of exporting_04.gif follows" longdesc="img_text/exporting_04.htm" /><br /> <a id="sthref601" name="sthref601" href="img_text/exporting_04.htm">Description of the illustration exporting_04.gif</a><br /> <br /> <p>This dialog box contains two sections: <a href="#BABHGJCI">Languages</a> and <a href="#BABFCHJC">Administration</a>.</p> <a id="BABHGJCI" name="BABHGJCI"></a><a id="WBINS16239" name="WBINS16239"></a> <div class="sect3"> <h4 class="sect3"><a id="sthref602" name="sthref602"></a>Languages</h4> <p>The <span class="bold">Base Language</span> field displays the base language of the repository. Warehouse Builder exports and imports data in the base language.</p> <p>You can specify additional languages to export and import objects that contain translations for their business names and descriptions. The <span class="bold">Available Languages</span> list displays the list of languages that are installed in the repository. To export or import additional languages, select the language and click the arrows to move the language from the <span class="bold">Available Languages</span> list to the <span class="bold">Selected Languages</span> list. You may choose multiple languages at the same time by holding down the Control or Shift key while making your selection.</p> <p>Note that the Available Languages list contains language entries only if you installed additional languages in the repository. For example, the repository has American English as base language, and additional languages French and Simplified Chinese. While exporting metadata from the repository, you may select French as the additional language. The Metadata Export Utility then exports the base language of the object, American English, and the additional language French for objects that contain a French translation. Note that additional languages are exported for an object only if they contain translations for the business names and descriptions.</p> </div> <!-- class="sect3" --> <a id="BABFCHJC" name="BABFCHJC"></a><a id="WBINS16240" name="WBINS16240"></a> <div class="sect3"> <h4 class="sect3">Administration</h4> <p>You may export additional metadata if you have administrator privileges. The options you may choose to export additional metadata are as follows:</p> <ul> <li> <p><a id="sthref603" name="sthref603"></a><span class="bold">Export user-defined definition:</span> Select this option to export the definitions of user-defined objects and user-defined properties.</p> </li> <li> <p><a id="sthref604" name="sthref604"></a><span class="bold">Export security information:</span> Select this option to include security information such as object privileges or role assignments made to users. See <a href="security_mgmt.htm#BGBCJHCG">Chapter 13, "Managing Security"</a> for more information about security.</p> </li> </ul> <p>After you specify the options on the Export Advanced Options dialog box, click <span class="bold">OK</span> to close this dialog box and return to the Metadata Export dialog box.</p> </div> <!-- class="sect3" --></div> <!-- class="sect2" --> <a id="BABFHAGA" name="BABFHAGA"></a><a id="WBINS16246" name="WBINS16246"></a> <div class="sect2"> <h3 class="sect2">Metadata Import Dialog Box</h3> <p>Use the Metadata Import dialog box to specify the information required to import metadata in an export file.</p> <img width="526" height="449" src="img/importing_03.gif" alt="Description of importing_03.gif follows" title="Description of importing_03.gif follows" longdesc="img_text/importing_03.htm" /><br /> <a id="sthref605" name="sthref605" href="img_text/importing_03.htm">Description of the illustration importing_03.gif</a><br /> <br /> <p>Specify the following information on this dialog box:</p> <ul> <li> <p><span class="bold">File Name:</span> Type the name of the MDL file or click <span class="bold">Browse</span> to locate the MDL file you want to import.</p> </li> <li> <p><span class="bold">Log File:</span> Type the name of the log file, along with the path, that will store diagnostic and statistical information about the import. You can also click <span class="bold">Browse</span> to locate the log file. See <a href="#BABIIJAI">"Metadata Loader Log File"</a> for more information about log files.</p> </li> <li> <p><span class="bold">Object Selection:</span> The Metadata Import Utility enables you to select the objects that you want to import from the MDL file. The Object Selection section contains the following options:</p> <ul> <li> <p><span class="bold">Import all objects from file:</span> Select this option to import all objects contained in the export file.</p> </li> <li> <p><span class="bold">Import selected objects from file</span>: Select this option to import only some of the objects contained in the MDL file. Click <span class="bold">Select Objects</span> to select the objects that you want to import. The Import Object Selection dialog box is displayed.</p> <p>The Import Object Selection dialog box is displayed contains two sections: <span class="bold">Available</span> and <span class="bold">Selected</span>. The Available section contains primary objects such as projects, modules, tables, views, and connections, which are specified in the MDL file. Expand the nodes in this section to view the objects they contain. When you select a node, all the objects that it contains are included in the import. For example, if you select a module node, all the objects contained in the module are imported. Use the shuttle buttons to move the selected objects from the Available section to the Selected section.</p> <p>The MDL file that is imported may also contain administrative objects. To import these administrative objects, you must have administrative privileges. If these privileges are absent, the following occurs:</p> <ul> <li> <p>The Available section of the Import Object Selection Page dialog box does not display any administrative objects that the MDL file may contain.</p> </li> <li> <p>The Import Utility displays an alert that the user does not have the required administrative privileges to perform the import, provided the MDL file contains only administrative objects.</p> </li> </ul> </li> </ul> </li> <li> <p><span class="bold">Import Option:</span> Use the Import Option section to select the import mode. You can select one of the following options for the import mode:</p> <ul> <li> <p><span class="bold">Create new metadata only</span>: This option, known as <span class="bold">create mode</span>, adds new objects to a workspace.</p> </li> <li> <p><span class="bold">Update metadata (replace existing objects and create new metadata)</span>: This option, known as <span class="bold">update mode</span>, adds new objects to a workspace and also replaces existing objects with those in the MDL file that is imported.</p> </li> <li> <p><span class="bold">Merge metadata (merge existing objects and create new metadata)</span>: When you select this option, known as <span class="bold">merge mode</span>, the MDL adds new objects and overwrites existing objects in the workspace only if they differ from those in the MDL file. The merge mode does not delete existing objects. Note that you cannot import metadata using the merge mode for mappings, pluggable mappings, and data auditors.</p> </li> <li> <p><span class="bold">Replace existing objects only</span>: This option, known as <span class="bold">replace mode</span>, replaces existing objects in your workspace but does not add new objects. In this mode, the Metadata Import Utility overwrites any existing metadata.</p> </li> </ul> <p>When you import metadata using the update or the replace modes, the import completely replaces the child objects of existing objects, so that the final object is exactly the same as the source object. Any existing children of a repository object that are not replaced or added are deleted. This occurs regardless of whether a child object occurs in a mapping or is a foreign, primary, or unique key column in a table or view.</p> <p>For example, in the MDL export file, the <code>CUST</code> table contains three columns with the physical names: <code>last_name</code>, <code>first_name</code>, and <code>middle_init</code>. In the workspace, the same table exists, and contains four columns with the physical names: <code>last_name</code>, <code>first_name</code>, <code>status</code>, and <code>license_ID</code>. During a replace operation, the columns <code>last_name</code> and <code>first_name</code> are replaced, column <code>middle_init</code> is added, and column <code>status</code> and <code>license_ID</code> are deleted. The final result is that the <code>CUST</code> table in the workspace contains the same metadata from the <code>CUST</code> table in the export file.</p> <p>Note that using the replace and update modes may cause loss of data constraints, metadata physical property settings, data loading properties, and mapping attribute connections. If you choose to use replace or update modes, ensure that you have the option of restoring the workspace from a backup.</p> </li> <li> <p><span class="bold">Match By:</span> When you use the metadata import utility, it first searches the workspace for metadata objects that exist in the workspace and compares them to those in the import file. To compare metadata in the import file with the existing workspace metadata, it uses the matching criteria. How the comparison is made is determined by the import mode and by the chosen search method.</p> <p>The Match By section provides the following options for matching criteria. By default, the import utility searches by UOIDs. Note that MDL import does not support merging existing mappings.</p> <ul> <li> <p><span class="bold">Universal Identifier</span> option searches the workspace using the Universal Object Identifiers (UOIDs) of the objects that are imported. The Metadata Import Utility uses the UOIDs to determine whether an object must be created, replaced, or merged during the import operation. Use this method if you want to maintain UOIDs across different workspaces even when object names in the target workspace have changed.</p> </li> <li> <p><span class="bold">Names</span> option searches the workspace using the names of the objects that are imported. Physical names are exported to the export file; the physical name determines whether an object must be created, replaced, or merged during an import operation. Use this method if you want to create new UOIDs for those objects when object names in the target schema change.</p> </li> </ul> </li> </ul> </div> <!-- class="sect2" --> <a id="BABIIFEG" name="BABIIFEG"></a><a id="WBINS16247" name="WBINS16247"></a> <div class="sect2"> <h3 class="sect2">Import Advanced Options Dialog Box</h3> <p>Use the Import Advanced Options dialog box to import any of the following:</p> <ul> <li> <p>Additional language metadata</p> </li> <li> <p>User-defined definitions</p> </li> <li> <p>Security information</p> </li> </ul> <img width="500" height="445" src="img/importing_04.gif" alt="Description of importing_04.gif follows" title="Description of importing_04.gif follows" longdesc="img_text/importing_04.htm" /><br /> <a id="sthref606" name="sthref606" href="img_text/importing_04.htm">Description of the illustration importing_04.gif</a><br /> <br /> <p>This dialog box contains two sections: <a href="#BABHGJCI">Languages</a> and <a href="#BABFCHJC">Administration</a>.</p> <a id="WBINS16248" name="WBINS16248"></a> <div class="sect3"><a id="sthref607" name="sthref607"></a> <h4 class="sect3"><a id="sthref608" name="sthref608"></a>Languages</h4> <p>The Base Language displays the base language of the repository. By default, data is imported in the base language.</p> <p>You can specify additional languages to import. The Metadata Import Utility imports the translations of the object for business name and description. The Available Languages list displays the list of languages that are specified in the MDL file. For example, the MDL file contains the additional languages French and Simplified Chinese, but your repository contains only French as the additional language. Then the Available Languages list displays only French. Select the language you want to import and click the arrow to move the language to the Selected Languages list. See <a href="#BABDIAAH">"Import Different Base Languages"</a>.</p> </div> <!-- class="sect3" --> <a id="WBINS26349" name="WBINS26349"></a> <div class="sect3"><a id="sthref609" name="sthref609"></a> <h4 class="sect3">Administration</h4> <p>This option is available only if you have administrator privileges and the metadata exists in the MDL file used for import. The options you may choose to import additional metadata are as follows:</p> <ul> <li> <p><a id="sthref610" name="sthref610"></a><span class="bold">User-defined definitions:</span> To import the definitions for the user-defined objects and the user-defined properties, select the <span class="bold">Import User-defined definitions</span> option.</p> </li> <li> <p><a id="sthref611" name="sthref611"></a><span class="bold">Security Grants:</span> Select <span class="bold">Import security information</span> to import security information such as object privileges and role assignments made to users.</p> </li> </ul> <p>If the MDL file contains any of these objects, then you can import this additional metadata.</p> <p>When you import an MDL file into a new workspace, if you want to inherit the security information from the old workspace, you must import the security information before you import other objects. To do this you need to be connected to the workspace as a user with administrator privileges.</p> <p>After you make your selections on the Import Advanced Options dialog box, click <span class="bold">OK</span> to save your selections and return to the Metadata Import dialog box.</p> </div> <!-- class="sect3" --> <a id="WBINS16250" name="WBINS16250"></a> <div class="sect3"><a id="sthref612" name="sthref612"></a> <h4 class="sect3">Name Conflicts</h4> <p>Name conflicts may occur in one of the following cases:</p> <ul> <li> <p>A different object with the same name exists in the target workspace.</p> </li> <li> <p>A different object with the same business name exists in the target workspace.</p> </li> <li> <p>A different object with the same UOID exists in the workspace.</p> </li> </ul> <p>When a name conflict occurs, the MDL reports an error and terminates the import.</p> </div> <!-- class="sect3" --></div> <!-- class="sect2" --> <a id="BABIBAAG" name="BABIBAAG"></a><a id="WBINS16251" name="WBINS16251"></a> <div class="sect2"> <h3 class="sect2">File Summary Dialog Box</h3> <p>The File Summary dialog box contains a brief summary of the contents of the export file. The information on this page is divided into the following sections:</p> <ul> <li> <p><span class="bold">File</span> section contains the name of the data file, the creation timestamp, the name of the export user, the workspace connection information, the version of the Design Center used for the export, and annotations.</p> </li> <li> <p><span class="bold">Administration</span> section contains information about the users and roles. It also lists the following details:</p> <ul> <li> <p>Base language of the export file</p> </li> <li> <p>Additional languages in the export file</p> </li> <li> <p>Whether security information were included in the export file</p> </li> <li> <p>Whether user-defined definitions were included in the export file</p> </li> </ul> </li> <li> <p><span class="bold">Statistics</span> section contains details about the types of objects contained in the export file and the number of objects of each type.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="BABJIHJH" name="BABJIHJH"></a><a id="WBINS16260" name="WBINS16260"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">Metadata Upgrade Dialog Box</h3> <p>This dialog box is displayed automatically when it is determined that the MDL file being imported was created using a previous version. Use the <span class="bold">File Name</span> field to specify the name of the file that stores the upgraded MDL file. You can also click <span class="bold">Browse</span> to locate a directory or MDL file.</p> <p>Click <span class="bold">Upgrade</span> to upgrade the MDL file to the current version. After the Upgrade completes, the Metadata Upgrade dialog box is closed. Click <span class="bold">Cancel</span> if you do not want to upgrade the MDL file.</p> </div> <!-- class="sect2" --> <a id="BABEDAAJ" name="BABEDAAJ"></a><a id="WBINS16237" name="WBINS16237"></a> <div class="sect2"> <h3 class="sect2">Metadata Progress Dialog Box</h3> <p>The Metadata Progress dialog box is titled either Metadata Export Progress, Metadata Import Progress, or Metadata Upgrade Progress. It displays a progress bar that indicates the relative completeness (as a percentage) of the metadata export, import, or upgrade activity. If the operation is successful, a message indicating this displays above the progress bar; it may also display that an error occurred.</p> <img width="493" height="202" src="img/exporting_05.gif" alt="Description of exporting_05.gif follows" title="Description of exporting_05.gif follows" longdesc="img_text/exporting_05.htm" /><br /> <a id="sthref613" name="sthref613" href="img_text/exporting_05.htm">Description of the illustration exporting_05.gif</a><br /> <br /> <p>To view detailed information about the metadata export or import, click <span class="bold">Show Details</span>. The message log is displayed. The message log contains the following information:</p> <ul> <li> <p>Start time of the export or import</p> </li> <li> <p>Names and types of objects exported or imported</p> </li> <li> <p>Warning or error messages</p> </li> <li> <p>End time of the export or import</p> </li> <li> <p>Location of the export or import log file</p> </li> <li> <p>Total export or import time in <code>hh:mi:ss</code> or milliseconds</p> </li> </ul> <p>You can hide the message log by clicking <span class="bold">Hide Details</span>.</p> <p>To view details about the exported or imported objects, click <span class="bold">Show Statistics</span>. The Metadata Results dialog is displayed. See <a href="#BABHBDHG">"About Metadata Loader Results"</a>.</p> <p>Note that you can cancel an in-progress Metadata Export or Import by clicking <span class="bold">Cancel</span>.</p> <p>Once the export or import completes, click <span class="bold">OK</span> in the Metadata Progress dialog.</p> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="BABJJGFF" name="BABJJGFF"></a><a id="WBINS16263" name="WBINS16263"></a> <div class="sect1"> <h2 class="sect1"><a id="sthref614" name="sthref614"></a><a id="sthref615" name="sthref615"></a>Metadata Loader Utilities</h2> <p>The Metadata Loader consists of the following two utilities:</p> <ul> <li> <p>Metadata Export Utility</p> <p>Use the Metadata Export Utility to export metadata from a workspace.</p> </li> <li> <p>Metadata Import Utility</p> <p>Use the Metadata Import Utility to import metadata into a workspace.</p> </li> </ul> <p>MDL uses its own format, and the Metadata Import Utility only reads files of MDL format (files created by the Metadata Export utility). The Metadata Loader file is a formatted ZIP file.</p> <a id="WBINS16264" name="WBINS16264"></a> <div class="sect2"><a id="sthref616" name="sthref616"></a> <h3 class="sect2"><a id="sthref617" name="sthref617"></a>Metadata Export Utility</h3> <p>The Metadata Export Utility extracts metadata objects from a workspace and writes the information into a ZIP format file. This ZIP file has an <code>.mdl</code> extension and contains the following files:</p> <ul> <li> <p><span class="bold">Metadata Loader XML file:</span> This file contains the objects extracted from the workspace and formatted in XML. It has the same name as the name of the ZIP file, but with the extension <code>.mdx</code>.</p> </li> <li> <p><span class="bold">Catalog:</span> The catalog file is called <code>mdlcatalog.xml</code> and it contains internal information about the Metadata Loader XML file.</p> </li> </ul> <p>The Metadata Export Utility enables you to specify a file name and a path for the exported MDL file. For example, you export the repository metadata into a file called <code>sales.mdl</code>. When you unzip this MDL ZIP file, you obtain two files. The file <code>sales.mdx</code> contains the repository objects. The file <code>mdlcatalog.xml</code> contains internal information about the MDL XML file.</p> <p>You can export an entire project, collections, public objects, locations, or any subset of objects. If you export a subset of objects, the MDL exports definitions for each object that you have selected and the parent objects to which the subset belongs. This enables the MDL to maintain the tree relationships for those objects during metadata import.</p> <p>For example, if you export a single dimension, the export file contains definitions for the dimension, the module to which the dimension belongs, the project to which the module belongs, and the configurations for the dimension.</p> <p>If you are exporting a subset of objects, ensure that you both export and import all referenced object. You may export the objects referenced by a set of objects by selecting the <span class="bold">Export All Dependencies</span> option on the Metadata Export dialog box. For example, if you export a table <code>EMPLOYEES</code> and it contains a foreign key reference to the table <code>DEPARTMENTS</code>, you may choose to export both tables.</p> </div> <!-- class="sect2" --> <a id="WBINS16265" name="WBINS16265"></a> <div class="sect2"><a id="sthref618" name="sthref618"></a> <h3 class="sect2"><a id="sthref619" name="sthref619"></a>Metadata Import Utility</h3> <p>The Metadata Import Utility reads the metadata information from an exported MDL file and creates, replaces, or merges the metadata objects into a workspace. It imports information that belongs to exported metadata objects, such as table columns and their constraints, data loading configuration parameters, and named attribute sets. The Metadata Import Utility enables you to import repository objects even if the references for those objects cannot be satisfied.</p> <p>You can use the Metadata Import Utility to import objects into a project or a collection. The Metadata Import Utility only reads files created by the metadata export utility.</p> <p>If the MDL file being imported was created using an earlier product version, the Metadata Import Utility automatically upgrades it to the current version.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <a href="#BABCFBBC">"Upgrading Metadata from Earlier Releases"</a> for more information about the automatic upgrade of MDL files</div> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="BABDAJIJ" name="BABDAJIJ"></a><a id="WBINS16266" name="WBINS16266"></a> <div class="sect1"> <h2 class="sect1"><a id="sthref620" name="sthref620"></a><a id="sthref621" name="sthref621"></a>Multiple Session Concurrency and MDL</h2> <p>The repository allows multiple clients to access the same workspace concurrently. Warehouse Builder uses locks to allow only one client to change repository objects. While an object is locked, other clients can only view it in the state it existed after the last transaction instigated by any user is committed.</p> <p>When replacing or merging objects, the MDL acquires locks on the primary objects that exist both in the repository and in the MDL file. Primary objects include, but are not limited to, projects, modules, tables, dimensions, cubes, mappings, views, and flat files. Secondary objects, such as columns and mapping attributes, are not locked. If locks cannot be obtained because other users are locking the primary objects, then the import fails. Therefore, you must be able to hold locks for primary objects that you are importing. To ensure a successful metadata import, you may need to be the sole client accessing the workspace.</p> <p>The MDL saves changes made to the workspace after a successful metadata import (any import with no error messages, including imports with only information or warning messages). The MDL also executes a rollback after an unsuccessful import.</p> </div> <!-- class="sect1" --> <a id="BABIIJAI" name="BABIIJAI"></a><a id="WBINS16267" name="WBINS16267"></a> <div class="sect1"> <h2 class="sect1"><a id="sthref622" name="sthref622"></a><a id="sthref623" name="sthref623"></a>Metadata Loader Log File</h2> <p>Whenever you export or import repository metadata, the MDL writes diagnostic and statistical information to a log file. You can specify the location of the log file when you call the MDL.</p> <p>The log file enables you to monitor and troubleshoot export and import activities in detail and contains the following information:</p> <ul> <li> <p>Name of the data file</p> </li> <li> <p>Start time and end time of the export or import</p> </li> <li> <p>Time taken for the export or import in hours, minutes, and seconds (in <code>hh:mi:ss</code> format) or milliseconds</p> </li> <li> <p>Object types exported or imported</p> </li> <li> <p>Number of objects of each object type exported or imported</p> <p>The import log file also displays the total number of objects that have been added, replaced, skipped, and deleted.</p> </li> <li> <p>Status messages</p> <p>Status messages provide information about the import or export process. They are of the following types:</p> <ul> <li> <p><span class="bold">Informational:</span> Provides information about the import or export, such as missing metadata objects, whether or not objects were imported, and any reasons why objects were not imported or exported.</p> </li> <li> <p><span class="bold">Warning:</span> Cautions you about the import or export of an object but does not indicate a failed or terminated export or import. A warning notifies you of the possibility of unexpected results that could occur as a result of the export or import.</p> </li> <li> <p><span class="bold">Error:</span> Indicates that the MDL export or import was terminated and did not complete successfully. The error message provides a brief description of the reason for the failure.</p> </li> </ul> </li> </ul> </div> <!-- class="sect1" --> <a id="BABHBDHG" name="BABHBDHG"></a><a id="WBINS16268" name="WBINS16268"></a> <div class="sect1"> <h2 class="sect1"><a id="sthref624" name="sthref624"></a><a id="sthref625" name="sthref625"></a><a id="sthref626" name="sthref626"></a>About Metadata Loader Results</h2> <p>When you use the Metadata Loader Export or Import utilities, you can view the results of a successful export or import task. Use the Metadata Export Results dialog box or the Metadata Import Results dialog box to ensure that all of the objects were exported or imported. To view the results dialog box, click <span class="bold">Show Details</span> on the Metadata Export Progress dialog box or the Metadata Import Progress dialog box. This displays the Message Log. Click <span class="bold">Show Statistics</span> at the end of this log.</p> <p>The results dialog box contains the following information:</p> <ul> <li> <p>The name of the project exported or imported (if applicable).</p> </li> <li> <p>The number of objects of each type exported or imported.</p> </li> <li> <p>The number of objects of each object type skipped.</p> <p>Details about the number of skipped objects is displayed only when you import metadata.</p> </li> </ul> </div> <!-- class="sect1" --> <a id="BGBBJJFE" name="BGBBJJFE"></a><a id="WBINS11100" name="WBINS11100"></a> <div class="sect1"> <h2 class="sect1">Managing Versions and History with the Metadata Loader</h2> <p>Using the Metadata Loader (MDL) utility, you can import and export metadata from any object in the Projects Navigator, Globals Navigator, and Connection Navigator. You can then move exported files into a third-party version control tool such as Oracle Repository, ClearCase, or SourceSafe. You can enter annotations for your MDL export file to keep track of the information contained in the file.</p> <p>The <a id="sthref627" name="sthref627"></a>Metadata Loader (MDL) enables you to populate a new repository and transfer, update, or restore a backup of existing repository metadata. You can copy or move metadata objects between repositories, even if those repositories reside on platforms with different operating systems.</p> <a id="CHDGCGJI" name="CHDGCGJI"></a><a id="WBINS16269" name="WBINS16269"></a> <div class="sect2"> <h3 class="sect2"><a id="sthref628" name="sthref628"></a><a id="sthref629" name="sthref629"></a>Accessing the Metadata Loader</h3> <p>You can access the Metadata Loader using either the graphical user interface described in this section or using the OMB Plus scripting language described in Oracle Warehouse Builder API and Scripting Reference.</p> <p>While the graphical interface guides you through the most commonly performed export and import tasks, the OMB Plus scripting language enables you to perform more specialized export and import tasks and enables you to manage a control file.</p> <a id="CIHCIJHF" name="CIHCIJHF"></a><a id="WBINS16270" name="WBINS16270"></a> <div class="sect3"><a id="CEGGCEGC" name="CEGGCEGC"></a> <h4 class="sect3">About Metadata Loader Control Files</h4> <p>When you use the OMB Plus commands related to the Metadata Loader, a control file provides you with greater control over how objects are imported or exported. For example, by default, the Metadata Loader exports objects into a binary zip format. To override the default of exporting to a zip file, use <code>OMBEXPORT MDL_FILE</code> with the <code>CONTROL_FILE</code> option with a control file that contains the option <code>ZIPFILEFORMAT=N</code>.</p> <p>See <a class="olink WBSCR" href="http://www.oracle.com/pls/db112/lookup?id=WBSCR"><span class="italic">Oracle Warehouse Builder API and Scripting Reference</span></a> for more information about using a control file, the Metadata Loader, and information about each of the following commands:</p> <ul> <li> <p><code>OMBIMPORT</code></p> </li> <li> <p><code>OMBEXPORT</code></p> </li> <li> <p><code>OMUIMPORT</code></p> </li> <li> <p><code>OMUIMPORT MDL_FILE</code></p> </li> <li> <p><code>OMBIMPORT MDL_FILE</code></p> </li> <li> <p><code>OMUEXPORT MDL_FILE</code></p> </li> <li> <p><code>OMBEXPORT MDL_FILE</code></p> </li> </ul> </div> <!-- class="sect3" --></div> <!-- class="sect2" --></div> <!-- class="sect1" --></div> <!-- class="ind" --> <div class="footer"> <hr /> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="33%" /> <col width="*" /> <col width="33%" /> <tr> <td align="left"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="98"> <tr> <td align="center" valign="top"><a href="content_mgmt.htm"><img width="24" height="24" src="../../dcommon/gifs/leftnav.gif" alt="Go to previous page" /><br /> <span class="icon">Previous</span></a></td> <td align="center" valign="top"><a href="security_mgmt.htm"><img width="24" height="24" src="../../dcommon/gifs/rightnav.gif" alt="Go to next page" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </td> <td style="font-size: 90%" align="center" class="copyrightlogo"><img width="144" height="18" src="../../dcommon/gifs/oracle.gif" alt="Oracle" /><br /> Copyright © 2000, 2009, Oracle and/or its affiliates. All rights reserved.<br /> <a href="../../dcommon/html/cpyr.htm">Legal Notices</a></td> <td align="right"> <table class="icons oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="245"> <tr> <td align="center" valign="top"><a href="../../index.htm"><img width="24" height="24" src="../../dcommon/gifs/doclib.gif" alt="Go to Documentation Home" /><br /> <span class="icon">Home</span></a></td> <td align="center" valign="top"><a href="../../nav/portal_booklist.htm"><img width="24" height="24" src="../../dcommon/gifs/booklist.gif" alt="Go to Book List" /><br /> <span class="icon">Book List</span></a></td> <td align="center" valign="top"><a href="toc.htm"><img width="24" height="24" src="../../dcommon/gifs/toc.gif" alt="Go to Table of Contents" /><br /> <span class="icon">Contents</span></a></td> <td align="center" valign="top"><a href="index.htm"><img width="24" height="24" src="../../dcommon/gifs/index.gif" alt="Go to Index" /><br /> <span class="icon">Index</span></a></td> <td align="center" valign="top"><a href="../../dcommon/html/feedback.htm"><img width="24" height="24" src="../../dcommon/gifs/feedbck2.gif" alt="Go to Feedback page" /><br /> <span class="icon">Contact Us</span></a></td> </tr> </table> </td> </tr> </table> </div> <noscript> <p>Scripting on this page enhances content navigation, but does not change the content in any way.</p> </noscript> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de