Re: Making a copy of a database

> > Can anyone suggest a technique for copying an OnLine database to the > same server? > > An archive attempts to restore to the dbspace - I don't know if this > can be overridden. > > A tbunload/tbload is OK, but the copy database will have been re-blocked > and defragmented, and therefore not an exact physical copy of the > original. > > Thanks > > Neil Truby > NJLG, London The obvious solution is to use dbexport followed by dbimport having changed the names of the database. It won't be a TRUE copy due to extent fragmentation etc. None of the other methods will work. If you need any more info please give me a call on the number below and I can talk you through your options. Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc