Skip to Main Content

SQL Developer Web

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Diagram with several schemas and tablespaces in dbaction datamodeler (ords 24.4.0.r3451601)

PaavoJan 22 2025
  1. I have desire to have several schemas in the same datamodeler diagram. E.g. there is need to change schema for certain objects and as well the tablespace and potentially tablespace for indexes as well. But the edit properties dialogs shows those “dropdown” menus as “readonly”.
  2. So is there way to make it happen or is the only way to first create first the object to target schema with correct tablespace and then add it to DM diagram?
  3. It seems that the user/schema as parsing schema for dbactions has to have then grants to such alternative schemas dictionary data?
  4. If so is it recommended to have certain datamodeler schema which is overpowered to fetch such information?
  5. What exact grants are then needed for datamodeler-schema?

rgrds Paavo

Comments

Artan Hajdari Feb 11 2025

Can someone help me in this case please

1 - 1

Post Details

Added on Jan 22 2025
0 comments
44 views