Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2003
    Posts
    62

    Unanswered: renaming tablepace

    Helo,

    Is there an easy way to rename tablespaces ?

  2. #2
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    Hi,

    I don't even think there is a hard way to rename the tablespace.

    Do you need it for transportable tablespaces? If so, I believe there is a TABLESPACE= parameter to help.

    The only way I know is to create a new tablespace and move the contents.

    Hope it helps,
    Breen.

  3. #3
    Join Date
    Aug 2003
    Posts
    62
    I need it because my production database and my development one has different tablespace name.

    I just want my development and my production bases has the same structure.

  4. #4
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    Hi,

    Do you have the space to create a new tablespace and then:

    alter table TABLE_NAME move tablespace NEW_TABLESPACE;

    Then drop the old one?

    Rgs,
    Breen.

  5. #5
    Join Date
    Aug 2003
    Posts
    62
    Thank you for you help

Posting Permissions

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