I would like to find the easiest way to create a brand new
database that is an exact copy of another, but with a different
oracle sid. We have the need to occassionaly copy our PREP
database to a TEST database. Currently, we create the new
database with orainst, and then import in the PREP database.
We always seem to have problems with referential integrity on
many of the tables. The alter table add constraint blows up on
31 of the tables being imported.
I was wondering if there was a way to just copy the physical
files that make up the database to another file system, and
then bring up the new database pointed at these new files.
This would be so much quicker. Keep in mind, I do not want
to disturb the original PREP database, but create TEST as
an exact copy. Thanks in advance.
Oracle 7.1.4
AIX 3.2.5 Rs6000-59H