export & import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: export & import

  1. #1
    Join Date
    Feb 2000
    Location
    phoenix, AZ,USA
    Posts
    20
    I have a set of history tables and main tables. I move records from the main table to the history table at regular intervals and export from the history tables.

    How do I restore the records back into the main table and not history table?

    Thank You

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    (Assuming you have a table called HISTORY and a table called MAIN). You can't. You will have to import back into the HISTORY table and then insert to the MAIN table.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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