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:


Blog Archive

The Learner

My photo

a crafty cat who loves food, linux, anime and crafting.

business analyst by day, blogger by night. also a frustrated artist.