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
Printable View
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
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.
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.