You don't need to worry about anything then. Just take full export and full import with rows=n. that should take s care off.

$exp system/**** buffer=9999 full=y rows=n consistent=y
$imp system/**** buffer=9999 full=y rows=n ignore=y

thats all about it, don't forget about precreated tablespaces.


ALTERNATIVE(if you think your database is big for exp/imp) IS:.

Create the new database from cold backup and truncate all the tables data using dynamic sql script.




[Edited by sreddy on 01-18-2001 at 10:00 AM]