Best way to 'copy' a database??

I need to take an Oracle db I have and basically move a copy of it to a new machine that has just a base Oracle install. I need new tablespaces, schemas, tables, users, permissions, etc. I did, in fact, do this already - but it was a major p.i.t.a. Seemed like I had to create tablespaces manually, then I had to import each of my schemas separately - i.e. I had to run 'imp' once for each schema I had to import.

Is there an easier way? Can I get an script generate by Oracle to set-up tablespaces, etc.? Then, just run 'imp' once?

Thanks. Received on Sat Nov 27 1999 - 14:22:10 CST