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

Thread: Export column data in a table from one dev db to test db

  1. #1
    Join Date
    Sep 2014
    Posts
    2

    Export column data in a table from one dev db to test db

    I modified a column of datatype clob in a table in dev db . Now i have to move all my modifications to the prod db. How do i go about it. The table is there in the prod db with the same column. I just have to sync both the columns.

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool

    And what would be the problem of doing it with an update over database link?
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    In addition to what LK Brown said, it seems like you are talking about replication. Which you can setup replication accross a DB Link both
    using built in packages and using the merge command. You may also need a familiarity with Google.

    https://www.google.com/?gws_rd=ssl#q...n+step+by+step

  4. #4
    Join Date
    Sep 2014
    Posts
    2

    Exporting clob data

    I tried to export the table data to a export.sql . but the clob data is not getting exported . what can be done to export the clob data?

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