Tuesday, July 31, 2007

Things I learned about using Oracle Designer

1. There are a lot of things that user "SYSTEM" can do so be careful. Just like in Linux, you have a super user. SYSTEM is like that.
2. Save and close everything in Designer before exiting.  If you don't, your session will be seen as in progress, hence locking the diagrams you've just made.
3. Kill the session in case the bad news in #2 happens to you. Useful commands:
     3.1. select sid,serial#,username from v$session
     3.2. alter system kill session '<session id>,<serial#>';
The commands should be run when you're logged in as user SYSTEM.
4. There is an autolayout button.
5. You could check out various tips on using Designer. Some of the useful tips are here: http://ourworld.compuserve.com/homepages/Peter_Koletzke/tip.htm

It's not really the nicest tool out there but it works.

No comments:

Labels

Blog Archive

Connect