Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Location
    Melbourne, Australia
    Posts
    53

    Unanswered: Moving tables from one dbspace to another

    I have an Informix Server v9.30UC2x1 on an AIX server with HDR and i need to move some tables from one dbspace to another. What is best way to do it?

    Appreciate your help.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

    I think that a one form is using:
    ALTER FRAGMENT ON TAPE xxx INIT IN new_dbspace.

    Gustavo.

  3. #3
    Join Date
    Aug 2003
    Posts
    68
    Quote Originally Posted by gurey
    Hi,

    I think that a one form is using:
    ALTER FRAGMENT ON TAPE xxx INIT IN new_dbspace.

    Gustavo.

    Gustavo is correct, but the syntax would be:



    "ALTER FRAGMENT ON TABLE <tablename> INIT IN <new_dbspace>;

Posting Permissions

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