Making database clone (without data)
Posted on 2007-10-17
I am newbie in Oracle administration. I am using Oracle 10g database. I would like to clone database i.e. make an exact copy of tablespaces, tables, indexes, triggers, functions etc but without data.
What is the most efficient way to do it.?
Currently I am doing it in the way that taking sql scripts from 1st database and I am creating users, roles, tablespaces on the second database an than I am importing using dump files schema by schema (taken from 1st database). It takes a lot of time, and there are many errors that appears, so sometimes I need to perform import few times to be sure that I have everything in the new database.
Is there any other faster and more automatic way to have the same result?
Thanks for any advice