I am a junior .NET developer that has recently started work at a company that use Oracle as their Database. They make use of Toad a lot, so I thought I better starting learning Oracle and Toad.
I have worked with MS SQL Server previously, so I’m OK* with Oracle, but Toad is proving a little more difficult.
I came to this website to learn more on how to use Toad effectively as a Developer. I am watching this video, but got stuck straight away!
The video instructor gets many options when he does a right-click on the table, e.g. (ER Diagram), I don’t get such options ! All I get when I right-click is shown in the screen-shot below:
I am a junior .NET developer that has recently started work at a company that use Oracle as their Database. They make use of Toad a lot, so I thought I better starting learning Oracle and Toad.
I have worked with MS SQL Server previously, so I'm OK* with Oracle, but Toad is proving a little more difficult.
I came to this website to learn more on how to use Toad effectively as a Developer. I am watching this video, but got stuck straight away!
The video instructor gets many options when he does a right-click on the table, e.g. (ER Diagram), I don't get such options ! All I get when I right-click is shown in the screen-shot below:
Yep I can go to Database > Report > ER Diagram, though I see a blank, huge grid with no ER Diagrams in.
I am not sure what User Files are ?! What do they do? And what are they good?
UPDATE: I think I have figured out the reason! It turns out that I am in a different Schema and when I was doing the right-click, I was not doing it on the table, but rather on a synonym that linked together two different Schemas!
Is there a way I can get Toad to do an ERD on a Synonym that is linking to a different Schema within the same database?
The reason it’s blank is you have to add something to an ER diagram – they are empty until you drag-and-drop some tables from object palette into an er diagram.
Yep I can go to Database > Report > ER Diagram, though I see a blank, huge grid with no ER Diagrams in.
I am not sure what User Files are ?! What do they do? And what are they good?
UPDATE: I think I have figured out the reason! It turns out that I am in a different Schema and when I
was doing the right-click, I was not doing it on the table, but rather on a synonym that linked together two different Schemas!
Is there a way I can get Toad to do an ERD on a Synonym that is linking to a different Schema within the same database?
In the video, the instructor simply does a right-click on the table, then he chooses ER Diagram, and that generates the related ERD as deep as the referential integrity of that particular table is concerned.
