Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2004
    Posts
    10

    Unanswered: table in table space

    Is it possible to insert a already existing table into a tablespace with an SQL ?

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by Klp
    Is it possible to insert a already existing table into a tablespace with an SQL ?
    Do you mean move a table from one tablespace to another?

    Unfortunately, no. You need to export-drop-create-import/load.
    --
    Jonathan Petruk
    DB2 Database Consultant

  3. #3
    Join Date
    Dec 2004
    Posts
    10
    The table already exists but not in a tablespace ( or the default one )

  4. #4
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    All tables exist in a tablespace, it's likely in USERSPACE1, the default SMS tablespace.

    Same answer applies, unfortunately, it can't be moved without a drop & re-create.
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

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