Generate Oracle Database in ERWin

1. about connecting to the Oracle database

①, Normally connected to generate the database

Of course, you must connect to Oracle before creating a database.

1. First select the DataBase type: DataBase ---> Choose DataBase:

2. Establish a connection:

DataBase --> DataBaseConnection:

At the beginning, I had no idea what to fill in for the Connection. In fact, enter your Oracle service name:

VARDENOR =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = VARDEN)
(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = dedicated)
(SERVICE_NAME = VardenOrcl)
)
)

The name here is VARDENOR.

Click Connect.

②. The problem solved now is that the Connection under Services cannot be successful even though the pop-up interface is the same!

To be resolved !!!

**************************************** ************************

An error occurred while generating !!!!!!!

Generate Oracle Database Report ORA-00902 in ERWin: Invalid Data Type

The following error is reported when the database is generated in ERWin 7.2.5 today:

ORA-00902: An invalid data type

Execution Failed!

Alter table T_RoleToAuthority
ADD (CONSTRAINT to foreign key (role_ID) REFERENCES T_Role (role_ID ))

ORA-00902: An invalid data type

Execution Failed!

The corresponding physical model diagram:

1: N

Solution:

1. At first, the default Foreign Key Constraint Name is to or null.

2. Make sure to change the Link name in the logical model !!!

3. Generally, it is changed from R/21 to the desired English name. Remember to Click Reset to assign a value to or empty. Otherwise, an error will be reported !!

Like this:

Alter table T_RoleToAuthority
ADD (CONSTRAINT to foreign key (role_ID) REFERENCES T_Role (role_ID ))

ORA-00902: An invalid data type

Execution Failed!

Write it here for now !! Even though the pop-up interface for clicking Connection under Services is the same, it cannot be successful!