How to export list of tables with Toad for Oracle

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.)

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.