Use powerdesigner to export the physical data model structure from the Oracle database

Step:
1. Choose File> reverse engineer> database...
2. In the pop-up window, select the relational database type. Here, use Oracle9i and click "OK.
3. Select using a data source in the new window and click the button at the end to select the data source. If this is the first time you need to add a new data source
4. Select connection profile for the data source and click the "Configure..." button below.
5. Click Add data source in the new window.
Connection profile name: name of the file for saving data source information according to the business
Connection Type: Native: Select Local
DBMS type: oracle9i: select the database vendor and version you are connected
Service name: Enter the service name configured for your Oracle client (for example, later)
Database Name: the database name is the SID of oracle.
User name: Database User Name
Password: Database User Password
The service name is
For example, the Oracle client access configuration is as follows:
Businessdb =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = 134.224.40.73) (Port = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
In this data source configuration, service name: businessdb, Database Name: orcl
After configuration, you can test whether the database is connected successfully.
After configuring the data source, you can export the table structure from the database.