Increase the size of Tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Increase the size of Tablespace

  1. #1
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Hi
    Can any one help me to increase the size of Tablespace without allowing Fragementation to happen.

    Presently I have 256MB size. I want to add 100 MB. What is the best way of doing it.

    My Oracle Block size is 8KB. Do I need to consider any thing else.


    Thanks
    Kishore Kumar

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    alter database datafile 'path_name' resize 356M;

  3. #3
    Join Date
    Mar 2000
    Location
    india
    Posts
    54
    Use an alter tablespace add datafile followed datafile name with size u want

  4. #4
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Thanks for that. My question is, will that ensure that for the next insertsions, it does not do any Fragmentation
    Thanks
    Kishore Kumar

  5. #5
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Most likely there won't be frag. in the ts.

  6. #6
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Thanks Halo
    Thanks
    Kishore Kumar

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