Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2002
    Posts
    51

    Question Unanswered: Informix granular table restore

    Hey all, is there a way to restore a single table from an ontape backup instead of doing a blob restore of the entire save? If not with ontape, is there another way to save that allows this sort of granular restore?
    -thanks
    When in doubt just ask your self,
    -WWSBD?-
    (what would Sponge Bob do?)

  2. #2
    Join Date
    Oct 2002
    Posts
    52
    export & import?
    dbunload & dbload?

  3. #3
    Join Date
    Sep 2002
    Posts
    51

    Angry poop...

    I was afraid of that! Thanks for the response.
    -d
    When in doubt just ask your self,
    -WWSBD?-
    (what would Sponge Bob do?)

  4. #4
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    If your table is the only table in a dbspace you can do a dbspace restore.
    rws

  5. #5
    Join Date
    Oct 2002
    Posts
    52
    Hi
    As far as my limited understanding and experience gets, the dbspace restore is good only to divide the restore to blocks. The server might not be consistent if you restore only part of the dbspaces.
    I've tried to restore all but one dbspace, but then I couldn't use that name again in the system. (Could not delete that dbspace from the sysmaster, could not add new one with the name).

Posting Permissions

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