Yes, Keep a lookout for your tempfiles. RMAN however, is the new paradigm... you can duplicate to new name, or restore to same name on new server, but cannot 'duplicate' to same name on same server, (because it requires the source database to be up). To same name on same server is a little easier the old fashioned way, (user written backups). (but then again... how much of a hindrance is that)? Other combos are beyond scope. Joel Patterson Database Administrator joel.patterson@xxxxxxxxxxx x72546 904 727-2546 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of genegurevich@xxxxxxxxxxxx Sent: Monday, May 19, 2008 2:57 PM To: oracle-l Subject: rename a database Hello : I need to rename an existing database (10.2.3). In the past (about 10 years ago and oracle 7) I was able to take the create controlfile command (via alter database rebuild controlfile to trace), replace the filesystem name and the database name with a new instance name, rename all the filesystems accordingly, execute the create controlfile command and be done. As I said I have not done it in about 10 years. Can this still be done like that? Am I missing anything? thank you Gene Gurevich -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l