New Database creation

venkad1110 · New User Joined: 23 Feb 2005 Posts: 7

I have an existing database A which has 100 Tablespaces with one table in each Tablespace.

My requirement is to create a new database B with same number of tablespaces and tables.

Is there any way we can do with few commands instead of running 100 DDL statements.............

satyender · Posted: Wed May 27, 2009 2:02 am

Venkat, if you are using control center then, i think you can do it by Restoring it to the new database.

Try it.