TASK-DB-001 — Oracle Database Inventory (Worker Report)
Date: 2026-07-21
Method: READ-ONLY metadata collection via python-oracledb THIN mode against Oracle
catalog views only (USER_TABLES, USER_VIEWS, USER_OBJECTS, USER_PROCEDURES,
USER_TAB_COLUMNS, USER_CONSTRAINTS, ALL_DEPENDENCIES). One connection per schema
using that schema's own credentials.
Compliance reconfirmation
- No DML executed (no INSERT/UPDATE/DELETE/MERGE).
- No DDL executed (no CREATE/ALTER/DROP/TRUNCATE).
- No application procedures executed.
- No business/application data read — only catalog/metadata views (names, counts, types).
- No secrets printed — credentials read from
.env, used only forconnect(); the generated catalog stores host/port/service name only, never user/password.
Instance
- Host:
192.168.0.100Port:1521Service:dev(credentials excluded) - Backend confirmed Oracle (ODP.NET / stored-procedure style; no SQL Server / T-SQL).
Connection results
All 4 schemas connected successfully. No connection or query failures.
Per-schema summary
| Schema | Tables | Views | Columns | Procedures* | FUNC | PROC | PKG/BODY | TRIGGER | SEQ | Constraints (P/R/U/C) | X-schema out-edges |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ASPNET_TEST38 | 23 | 5 | 217 | 34 | 31 | 2 | 1/1 | 0 | 6 | 23/17/2/71 | 0 |
| INFOCAD_TEST38 | 2628 | 1551 | 148453 | 8407 | 128 | 3161 | 4/4 | 4889 | 1367 | 2328/1324/1800/10896 | 885 |
| REQUESTCENTER_TEST38 | 60 | 28 | 1168 | 524 | 2 | 345 | 5/5 | 28 | 33 | 50/68/6/131 | 321 |
| DEM_TEST38 | 30 | 3 | 176 | 268 | 2 | 127 | 3/3 | 13 | 19 | 28/30/8/59 | 8 |
* Procedures = USER_PROCEDURES row count (includes package member subprograms).
INFOCAD also has JOB=2, SYNONYM=36, TYPE=7, LOB=2271, INDEX=6391 objects.
Cross-schema dependencies (ALL_DEPENDENCIES, referenced_owner among the 4 schemas)
- INFOCAD_TEST38 -> 885 edges: ASPNET_TEST38 (671), DEM_TEST38 (140), REQUESTCENTER_TEST38 (74).
- REQUESTCENTER_TEST38 -> 321 edges: DEM_TEST38 (217), INFOCAD_TEST38 (104).
- DEM_TEST38 -> 8 edges: REQUESTCENTER_TEST38 (6), INFOCAD_TEST38 (2).
- ASPNET_TEST38 -> 0 edges (no outbound cross-schema deps to the other 3).
INFOCAD is the hub schema by size and by outbound dependency count. ASPNET is a leaf (depended-upon by INFOCAD but declares no cross-schema deps itself). Full edge samples (up to 25 per schema) and per-ref-owner aggregates are in the generated catalog.
Output artifacts
docs/_generated/database-catalog.json— full per-schema metadata: counts, object-name lists by type, per-table column-count map, constraint-type counts, cross-schema edge totals + samples, instance host/service (no credentials).docs/_evidence/TASK-DB-001/report.md— this report.