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]
Click Here to Expand Forum to Full Width