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

Thread: Update table definitions

  1. #1
    Join Date
    Dec 2003
    Posts
    21

    Update table definitions

    What is the best way for update table definitions in Oracle database?

    I have one database that I use for development. When I change some table definitions in that database I have to update my production database with those tables.
    I have to change only tables definitions in my production database and leave the data as it is.

  2. #2
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    Just use the "alter table add/modify" to update the definition of the tables in production.

    If you have a high volumne of tables, that need to be synced with development.... you can use Quest's TOAD to do a compare, and generate a script to sync any 2 databases.

  3. #3
    Join Date
    Dec 2003
    Posts
    21
    What are you saying?

    Oracle does not have utility for that?
    Something like Export-Import?

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    LOracle has the application "Change Manager" to propagate object definition changes, but it's all based on generation of SQL DDL statements. They are ultimately the methodology that is used, whether it's manually generated or generated through a gui tool.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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