How to export list of tables with Toad for Oracle

Bart Gawrych - Dataedo Team Bart Gawrych 2019-04-11

Table of Contents:


    In this tutorial I will show you how to export list of all tables in Toad for Oracle.

    Option 1: By Schema Browser

    In toolbar, find Database and select Schema Browser.

    Next, depend on your Schema Browser view option do:

    • for TreeView select Tables in your schema
    • for Dropdown/Tabbed view select Tables as tab and select all objects in explorer (CTRL + A)

    Now in both cases you can select which tables you want to copy (CTRL + A to select all) and by right click and select:

    • Copy Selected to Clipboard as HTML - copies selected area as table in HTML
    • Copy Selected to Clipboard as Text - copies selected area as tabbed text - you can paste it to other tool (e.g. to Excel)

    Option 2: By Object Search

    From toolbar select Search -> Object Search.

    In new opened Object Search window:

    • leave Search term blank
    • select Occurs anywhere
    • in Schemas to search select from which schemas you want list of tables
    • check Search object names and in this section check Tables
    • uncheck Search column names and Search source

    Click Search button (green triangle icon).

    In the result you can group tables by schema name (owner). To export result right click on any row and select Export Dataset…

    To export it choose export format (e.g. Excel, HTML Table or JSON ) In Data Masking you can change names of column headers (Object Name, Object Type etc.)

    0
    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.
    Accept