Table of Contents:

    Exporting descriptions to Oracle

    Applies to: 9.x (current), Article available also for: 8.x, 7.x

    Dataedo allows exporting descriptions (from Description field) back to Oracle database itself.

    Rich text fields

    Some descriptions in Dataedo are entered in rich text format, including formatting, lists, tables, images etc. This is saved in Dataedo repository as HTML. Export function removes formatting and writes only plain text.

    String length

    Databases have different limitations in terms of maximum string length. Dataedo fields are longer and it is possible that descriptions exported to your database may be trucated if their lenth exceeds database capabilities.

    Required permissions

    COMMENT ANY TABLE privilege.

    Exporting descriptions

    If you want to export descriptions please choose Export documentation in the ribbon. In dialog box choose Export comments to database.

    Export wizard

    Click Next and provide connection details (you will see connection details you provided at import/update).

    Connection details

    In next step you can filter objects you want to export to specific modules.

    Choose modules

    Now you can filter specific object types.

    Choose object types

    When ready click Export button.

    Congratulations, descriptions have been saved in your database.

    Export finished

    Found issue with this article? Comment below
    There are no comments. Click here to write the first comment.

    By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy (updated 28-04-2020).