Data Integration Solution Architect / Data Architect

Looking for challenges. Contact me on Linkedin.

ERwin How to Set Owner (Schema Prefix in Oracle Database)

Three options to get schema prefix in DDL SQL scripts generated in ERwin.

1. Global Setting

Erwin main menu Model -> Model Properties -> Set Default Owners…

2. Local Override in the Model

Open Physical view in the model

Right click on the table “Table Properties…” to open Oracle Table Editor. There is a column “Owner”. Press F2 and type in the name.

3. Local override in Forward Engineering Screen

In physical view open Forward Engineering dialog box.

At the bottom there is “Owner Override…” button.

DDL Generated Script