Oracle List Tables¶
Lists all tables available in an Oracle schema using the provided database credentials. If no schema is specified, it lists tables from the current user's default schema. Returns a human-readable summary along with structured JSON data.
Usage¶
Use this node to explore the available tables before building queries or performing data operations. Typical workflow: test connection -> list schemas (optional) -> list tables (this node) -> get table info or run queries.
Inputs¶
| Field | Required | Type | Description | Example |
|---|---|---|---|---|
| credentials_path | True | STRING | Path to the stored Oracle credential configuration that includes connection details. | /configs/credentials/oracle.json |
| timeout | False | INT | Maximum time in seconds to wait for the operation before it is aborted. | 30 |
| schema_name | True | STRING | Target Oracle schema to list tables from. Leave empty to list tables in the current user's default schema. | HR |
Outputs¶
| Field | Type | Description | Example |
|---|---|---|---|
| text | STRING | A formatted, human-readable summary of the listed tables, including the schema context. | Oracle Tables in Schema: HR Total: 7 |
| json | JSON | Structured result containing the list of tables and related metadata. | {"tables": ["EMPLOYEES", "DEPARTMENTS", "JOBS"], "schema": "HR"} |
Important Notes¶
- Schema handling: Leaving schema_name empty will list tables from the current user's default schema.
- Permissions: The connected user must have privileges to read metadata for the specified schema; otherwise, the list may be empty or error.
- Case sensitivity: Oracle stores unquoted identifiers in uppercase; table names in results may be uppercase.
- Large schemas: Listing a very large number of tables may take longer; consider increasing the timeout if needed.
Troubleshooting¶
- Empty results: Verify schema_name is correct and the user has permissions to access that schema.
- Timeouts: Increase the timeout input value if the database is slow or the schema is large.
- Authentication errors: Ensure credentials_path points to a valid Oracle credential configuration and the credentials are correct.
- Network connectivity: If requests fail, confirm network access to the Oracle database and any required gateways or services.