Re: Hello:

>Well... > >The only way to change the size of logical logs is to re-initialize the >instance... as in: unload all data, reinitialize the engine, recreate >the database(s), load data. > This isn't true. The section you cite applies to changing the ONCONFIG parameters themselves, which determine the log configuration AT INITIALISATION TIME! The last paragraph of this section states ".... to change the size of the log files, it might be easier to add logs of the desired size and drop the old ones". It's a perfectly valid exercise to subsequently alter the size and/or number of logical logs. Page 23-7 describes how to move a logical log from one dbspace to another; this technique is equally applicable to changing the log size. > > >Sometimes it pays to read the manual... > Quite! Neil Truby Chase Manhattan Bank Bournemouth, UK