On Mon, May 19, 2008 at 11:57 AM, <genegurevich@xxxxxxxxxxxx> wrote: > 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? > > It still works. Look at the docs for 'alter database backup controlfile to trace' You can also specify the filename to send it to, as well as a few other options. -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist