Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2005
    Posts
    102

    Unanswered: Moving tables to 32k tablespace

    Hi All,

    I need some help in the process being followed for moving some of the larger tables to a 32k tablespace. Currently all our tables are defined with 4k and 16k tablespaces.

    I don't know if I can just alter the table by assigning it to a 32k tablespace or do I need to follow some other process.

    ENV: DB2 UDB v8.2 FP 7, AIX 5.2

    Thanks

    Anks

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You'll need to drop and re-create the table.

  3. #3
    Join Date
    Jul 2005
    Posts
    102
    Thanks for the reply.

  4. #4
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170
    Export all those tables.
    Drop the tables from DB
    Import them to the new Tablespace

Posting Permissions

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