Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    121

    Unanswered: change tbs page size

    how do we change tablespace pagesize in a database having data ?
    we want to change from 4k to 8k.
    I tried but did not find any option in 'alter tablespace ..' statement.

    If we backup tablespace with 4k and restore on tablespace created with 8k will work ? Or while we restore 4k tbs backup onto 8k tbs it will make it again 4k ?

    Please guide .

    TIA.

  2. #2
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186
    you cannot change the pagesize, your would need to create a 8k tablespace and export/load the data back in.
    David Quigley

  3. #3
    Join Date
    Nov 2003
    Posts
    121

    Thanks ! no other way around ??

    this is cumbersome!!

Posting Permissions

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