procopy and prodb

[raviraju]

i have doubt that procopy makes a exact db of yurs and prodb do the same thing so what is the basic differece between these two?prodb creates new db by source db but what are the diffrenrce between them

 

[RealHeavyDude]

Personally I always use procopy because the syntax is more like an OS copy syntax, specifying the source as first and the target as the second parameter, whereas prodb needs these parameters in reversed order.

It depends what you define as "exact copy" for a database. For one you have the content of the database, the individual database blocks. Procopy ensure that the content copy is an exact copy of the source database in that it copies all database block as they are. But, you can change the physical layout of the database using procopy - exactly you can change the physical layout of the individual extents ( size, location, and whether they are fixed or variable ) of the given storage areas, but you cannot change the storage areas. In that sense procopy might not produce and "exact copy" of the source database as the database blocks may be arranged differently.

What is your definition of "exact copy"?

Heavy Regards, RealHeavyDude.