DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle Designer6

  1. #1
    Join Date
    Jan 2000
    Location
    san jose
    Posts
    149
    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

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    Designer 6i

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

  3. #3
    Join Date
    Jan 2000
    Location
    san jose
    Posts
    149
    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?

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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...
    Reddy,Sam

  5. #5
    Join Date
    Jan 2000
    Location
    san jose
    Posts
    149
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width