Oracle Designer - Table Implementation Problem

[rgupta]

In the Design Editor - DB Admin tab, there is:

1. Oracle Database (Default Database) and then Users for that database

2. Server Model Definitions and then Table Definitions under it

I generated tables using the Database Design Transformer under my 'User' account. The tables show under Table Definitions but not under Table Implementations (which is under Schema Objects for the user).

What are the Table Implementations for and why don't the tables show up here?

thanks
rgupta@seta.com

 

[DCH]

The idea is that you describe your tables in the server model, and that you decide to put them (some or all) in one or several databases in the dB admin part.

In a few words, now that you have some tables in the server model part, go to the dB admin part and:
- create at least one Oracle database
- create at least one user in that database
- explore the schema objects node for that user
- try adding some table implementations there: you will only be able to add some that exist in your server model

And now if you generate that user (right-click with the mouse when that user is selected will do), the scripts you might elect to generate will only take into account the table implementations you just defined for that user.

HTH - Didier