This looks like the Mendix runtime metadata and the physical database schema are out of sync because the first deployment was interrupted while creating the database structure.
Since this is a fresh Development environment and there is no business data yet, I would not try to manually clean Mendix system tables. The safer approach is:
Mendix will recreate the required tables and metadata during initialization.
The reason you see: key not found: UUID is usually not a missing business table issue, but a partially generated Mendix model/database mapping caused by the failed deployment.
For production environments, I would avoid dropping the schema and instead recover from backup or investigate the exact missing metadata. But for a clean DEV environment, a fresh schema recreation is normally the cleanest fix.
Also, make sure the Oracle tablespace sizing is sufficient before redeploying, because the initial deployment creates all Mendix runtime tables and indexes.
Kindly mark this as the accepted answer if it helps.