We are just considering moving some of our larger customers from workgroup to enterprise, some of these systems have 15-25GB databases spread across 2GB extents. When we move to enterprise and enable large file support what will happen? the two scenarios i can imagine are:
Can anyone tell me what is the correct result of moving to large files?
We are on 10.0b
TIA
Dean
Yeah, the first scenario is what will happen by default if you enable large files.
An alternative is available to scenario 2, though: Backup the current DB, create a new one with larger extents and restore into it.