LIST TABLES

Use LIST TABLES to list all tables in the database that match the specification provided with the command argument. Use the DBLOGIN command to establish a database connection before using this command. If logging into an Oracle multitenant container database, log in to the pluggable database that contains the tables that you want to list.

If you want to list all the tables that are enabled for auto capture, then use the auto_capture option. This option is only valid for Oracle Database 20c or higher. You need to establish a database connection (using DBLOGIN command) before using this command. If you are unable to establish a connection or don't have the required privileges, the option will not work.

Syntax

LIST TABLES table

The following syntax applies when using the auto_capture option.

LIST TABLES [container.]owner.table [AUTO_CAPTURE]

table: The name of a table or a group of tables specified with a wildcard (*).

[container.]owner.table: The command accepts a two-part name in non-CDB mode and a three-part name in CDB mode. Supported wildcards are ? and * for single and zero or more character matching respectively. In GGSCI, container/schema/table can have a wildcard specified. In Admin Client, both the schema/owner and container name cannot contain a wildcard character. Table name can have wildcards. When the command is successful, the output shows the list of tables enabled for auto capture matching the input criteria.

Example

The following shows a LIST TABLES command and sample output.

list tables tcust*
FINANCE.TCUSTMER
FINANCE.TCUSTORD

Example

The following example shows a LIST TABLES command listing tables enabled for auto capture:

LIST TABLES k1.tab*  AUTO_CAPTURE
Output:
K1.TAB1
K1.TAB3