Hello everyone,

I am a newcomer to Lazydba as well as a beginner dba. I have a question re cloning databases.

I was trying to clone a test database (version 9.2.0.6) from a production database (same version). I copied all dbf files over to the test database server. Recreated the control file and setting it to a new name (using create controlfile set database "test" resetlogs...). Then do the following:
alter database open resetlogs;
alter tablespace temp add tempfile '...' reuse;

The db opened ok but the last statement gave me the error:
ora-00604:error occurred at recursive SQL level 1
ORA-06553:PLS-801:internal error[56319]

I next tried:
drop tablespace temp
and get the same error.

In fact, it gave me the same error even when I tried to change a user's password!

Any ideas what's going on here?

Can I ask what others do to quickly clone a database without having to go thru db creation?

Thanks.
Rosanna



Oracle LazyDBA home page