Oracle Designer6

[bxr556]

Is there anybody who are using oracle designer?
is it useful, in my opinion, it has too many bugs.
or i use it in wrong way?

tell me if you are comfortable with using it!

Thanks

[sreddy]

We do not use extensively but, its okay...

[bxr556]

I can convert ER to database.

after that, how should i sync ER with database?

for example.
let's say we need to design a database,
first, we draw ER relationship between dept and emp.
then it will generate sql script which is used to generate
database structure.
after that, if we need add one more table named "manager"
what i did is just go to sqlplus and "create table manager..."
and then add foreignkey etc.
as time goes by, i created a lot of table which is not in ER
one day, my manager ask me to give him a picture
how each table is related, i have no idea how to do that.

can you give me some suggestion?

[sreddy]

Take export and dump it to Designer and Reengineer the current database. You can enable version control and periodically do reengineering for every quarter.

You can retrieve all your quaterly changes at the end of year, if you enable version control. No big deal...

[bxr556]

since i don't know anything about Designer can you tell me that:

1
do you mean that oracle design can accept
Oracle export file and convert it to ER

2.
when do say "reengineer" what do you mean?