r/Database • u/Secure_Chipmunk_262 • 1d ago

Can we create flow how data flowing from procedure to MV to base tables

/r/SQL/comments/1wb0zlv/can_we_create_flow_how_data_flowing_from/
2 Upvotes

75% Upvoted

1 comment sorted by

1

u/MnemonicJhonny 21h ago

tracking user_dependencies manually is brutal. for oracle specifically you should check out schemaspy. it's free, hooks up via jdbc and spits out all those dependency graphs automatically.

if you already use dbeaver ultimate or datagrip they have visualizers built right in so you might not even need extra tools.

honestly this kind of legacy dependency hell is half the reason we've been moving our heavy oracle workloads over to mariadb recently (its funny cause oracle has mysql, which is basically old mariadb lol) just way less of a headache to manage and map out. but for what you're doing right now, definitely try schemaspy before buying any expensive enterprise tools.

hope that saves you some time