DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: tablespaces

  1. #1
    Join Date
    Dec 2000
    Posts
    21

    Wink

    Happy New Year to All!

    I have two tablespaces and each contains 8 datafiles with size 50M. I want to make these two tablespaces contain two datafiles on each tablespace with size 2G in the same location. What is a safe and quick way to accomplish this goal? Thanks!

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    drop and recreate tablespace

  3. #3
    Join Date
    Dec 2000
    Posts
    2

    Exclamation

    before you drop and recreate tablespace,
    export the tablespace ( all segments in it), drop tablespace with contents.
    Then delete the datefiles, recreate tablespace with the same name, do import.

  4. #4
    Join Date
    Dec 2000
    Posts
    21

    to dwang and pando

    Thanks for your respond and 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
  •  


Click Here to Expand Forum to Full Width