Can I clone a Tablespace from one Database into another without using Import?
Posted on 2006-11-17
Hi All, this should be easy. I've know about cloning Databases, but can you clone a Tablespace from one Database to another? The reason I ask is that I have a critical path that requires us to Import a 100+ million row table and Index rebuilds that take over 3 hours.
If cloning this physical Datafile(Tablespace) is possible and both Databases use the same Schema name and Db object name what are the steps so that I can create an environment to test this out.