Re: 2 gb file limit [SUMMARY]

Susan Elliott (ISG) wrote in message <706bvi$ni6$1@news.xmission.com>... > >The object of the exercise is export and import the database, as all my >extents are SUPER high. ..... Alter fragment is also not an option, as I just don't have the disk space >spare.... As a workaround could you not: 1. Use the 6GByte file system you have to create a 6GByte dbspace for the server 2. Alter fragment a large table into the new dbspace 3. Alter fragment the same table back into the original dbspace 4. Repeat 2 and 3 until satidfied 5. Drop dbspace created in 1. ? Just an idea Neil aracnet Limited Weybridge, UK