Oracle List Tables¶
Lists all tables available in a specified Oracle schema. If no schema is provided, it lists tables in the current user’s default schema. Returns a human-readable summary and structured JSON of the discovered tables.
Usage¶
Use this node to quickly inventory tables in an Oracle database when exploring data sources, validating access, or building subsequent queries. Typically placed early in a workflow to discover available tables before fetching columns or running queries against specific tables.
Inputs¶
| Field | Required | Type | Description | Example |
|---|---|---|---|---|
| credentials_path | True | STRING | Path or reference to the stored Oracle database credentials to authenticate requests. | |
| timeout | True | INT | Maximum time in seconds to wait for the operation before timing out. | 30 |
| schema_name | True | STRING | Target Oracle schema to list tables from. Leave empty to use the current user’s schema. | HR |
Outputs¶
| Field | Type | Description | Example |
|---|---|---|---|
| text | STRING | Readable summary of tables found in the schema. | Oracle Tables in Schema: HR Total: 12 - EMPLOYEES - DEPARTMENTS - LOCATIONS ... |
| json | STRING | JSON-encoded result payload containing the list of tables and associated metadata (if provided by the service). | {"tables": ["EMPLOYEES", "DEPARTMENTS", "LOCATIONS"], "schema": "HR"} |
| html | STRING | HTML representation (if available). For this operation using default formatting, this is typically empty. | |
| xlsx | STRING | Serialized XLSX content or reference (if available). For this operation using default formatting, this is typically empty. | |
| STRING | Serialized PDF content or reference (if available). For this operation using default formatting, this is typically empty. |
Important Notes¶
- If schema_name is left empty, the node queries the current user’s default schema.
- Requires valid Oracle credentials; ensure the credentials file or reference is accessible and correctly formatted.
- The timeout applies to the remote request; large schemas or slow connections may require higher values.
- Output includes a text summary and a JSON string; other formats are generally empty for this operation.
Troubleshooting¶
- No tables returned: Verify schema_name is correct or try leaving it empty to use the current user’s schema. Confirm the user has privileges to view tables.
- Authentication error: Check credentials_path and ensure the credentials are valid and permitted to list tables.
- Timeouts or network errors: Increase the timeout value and verify network connectivity to the Oracle service.
- Invalid schema name: Use the exact schema identifier as defined in the database, respecting case-sensitivity and permissions.