Re: 2 gb file limit [SUMMARY]
Susan Elliott (ISG) wrote:
> The object of the exercise is export and import the database, as all my
> extents are SUPER high. [...]
> I cannot consider using unonload as I want to change the initial extent
> size.
Susan,
why is it so important for you to change the initial extent size? The
result would be rather cosmetic, since onload will load all extents of
a table into one contiguous extent, no matter what number and size the
original extents were before the onunload.
So in fact, each one of your tables will only have one extent after
you did the onunload/onload. To avoid future fragmentation, you can do
an "ALTER TABLE NEXT SIZE xxx" afterwards. Maybe that could save you
a lot of work.
HTH,
Richard
--
+--------------------------+------------------------------------------+
| Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de |
| EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3413 |
| Klinikum Grosshadern | FAX : +49-89-7095-8886 |
| 81366 Munich, Germany | GSM : +49-172-8933578 |
+--------------------------+------------------------------------------+