Reorganizing big table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Reorganizing big table

  1. #1
    Join Date
    Mar 2001
    Posts
    131

    Unhappy

    I have a table in a tablespace spanning mulitple datafiles. The table size is 11 GB but my OS file size limit is 2 GB. Pl. Help me in reorganizing the table !

    Thank You

  2. #2
    Join Date
    Mar 2001
    Posts
    40

    re

    I don't think that there are any relationship between TABLE and DATAFILE. u can create a 12GB TABLESPACE whitch span 6 Datafile of 2G. hope it is useful to u.
    BTW, for performence, maybe u like to partation the Table.

  3. #3
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Since you have a 2Gb filesize limitation, you can either:
    1. continue adding dbf to the ts as the table grows OR
    2. partition the table and keep 'x' no. of partitions per ts.

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