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

Thread: space management in 8.1.7

  1. #1
    Join Date
    Apr 2001
    Posts
    103

    Unhappy

    Hello,
    We have bought a new NT server with raid5 option. Our oracle db is in a old NT server, we are trying to migrate our database from old to new.
    I created the DB, and I exported the DB from old one and reimported in the new one.
    My user tablespace in the old one is 2G and in the new one it is 4G. I dont understand why it occupies more space.
    If some one can explain me it will be of great help.
    Sorry for my english
    Naeem
    Naeem

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Have you increase your db_block_size in the new DB?


  3. #3
    Join Date
    Apr 2001
    Posts
    103
    yes
    Naeem

  4. #4
    Join Date
    Apr 2001
    Posts
    103
    Is anybody has a reply
    Naeem

  5. #5
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    The other was the reply :-)

    Best regards

    Angel

  6. #6
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166

    Cool

    If you did the export with a compress=y then it will change the initial extent to be the sum of all og the extents, that coupled with the minimum extent parameter being set to something other than 1 would also cause the database to use more space. But certainly a larger block size will increase the amount of allocation for your database.

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