Re: rename a database
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: genegurevich@xxxxxxxxxxxx
- Date: Mon, 19 May 2008 12:21:14 -0700
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
Other related posts:
