-
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
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|