move from workgroup to enterprise does large file move need

Posted by deanmacken on 26-Nov-2010 08:18

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:

  1. The last extent continues to grow past 2GB leaving the older full extents in place (preferable to us)
  2. The database needs a dump and reload in order to move to large file support

Can anyone tell me what is the correct result of moving to large files?

We are on 10.0b

TIA

Dean

All Replies

Posted by kevin_saunders on 30-Nov-2010 08:02

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.

This thread is closed