Re: Making a copy of a database
trubyn@aol.com wrote:
>
> 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
A solution to this is to first do a dbschema with the -ss option,
allowing
you to get the physical info on the database. Then run an export of the
database. Before you dbimport, change the .sql file (database schema)
to
the one you got from the dbschema command with -ss option. Then run your
dbimport.
--
-----------------------------------------------------------
Timothy Jones T# 978-6293 tojones@gate.net
DD&C Inc. B# 813-883-0910 www.dbdoc.com
-----------------------------------------------------------