Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2006
    Posts
    53

    Unanswered: How to export data containing timestamp

    In a database supplied by a vendor, I'm trying to export to our test database several tables to which we've added data but I keep running into an error 'trying to insert row version column'. The vendor has included a timestamp column in every table. What I need to do is exclude that column from the export-hopefully without writing explicit SQL for every table.

    Suggestions?

  2. #2
    Join Date
    Feb 2003
    Location
    India
    Posts
    216
    how r u exporting data? try using DTS. i have seen DTS not complaining about timestamp column.

  3. #3
    Join Date
    Mar 2006
    Posts
    53
    Yep, using DTS (Integration Services in '05). Both source & destination DB contain the table. I've tried both appending the rows to the destination table & replacing them (deleting the rows in the destination table before doing the export). If I remember correctly I got duplicate key errors when appending the rows, and row version errors when replacing them-but I'll run thru it again both ways to document what I'm getting, then post back. Thanks.
    Now back on Oracle. The more things change, the more they stay the same.

Posting Permissions

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