Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2008
    Posts
    96

    Unanswered: moving table from 4k to 16k tablespace

    Hi All,

    OS:AIX 5.3
    DB2 V8.1 FP14

    Can I move a table from 4k tablespace to a 16k tablespace by using the following command?

    Alter table <tablename> set tablespace <tablespace_name>

    Thanks

    Rangupt

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    No. You will have to create the new table space, then re-create the table in the new table space and copy over the data.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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