Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What state... to rename datafile
In article <3A268699.335661E6_at_ensib.NICHT-SPAM.ee>,
Juhan Kundla <juhan_at_ensib.NICHT-SPAM.ee> wrote:
> Well...I'm not sure and I don't have the option to test it, but AFAIK
> when your database is in mounted stage and not opened, then the
instance
> does not know anything about tablespaces. You have to use "alter
> datafile 1 rename" or something similar.
>
> HTH,
> Juhan
>
> johna_at_digisys.net wrote:
> >
> > Hello,
> >
> > We are using Oracle8i on NT4, and need to rename a datafile.
> >
> > I thought I would bounce the datbase. ie do a shutdown (immediate)
on
> > the database, then open it to the "mounted" state.
> >
> > Then when I run the command "Alter tablespace dog_index rename
> > datafile1 to datafile2; I get errors.
> >
> > This doesn't seem to work though, any ideas why??
> >
> > Thanks,
> >
> > John
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
> --
> +-----------------+
> |NB! Please remove|
> | .NICHT-SPAM |
> | when replying |
> | to get my |
> | *REAL* |
> | e-mail address! |
> | |
> | Cheers, Juhan |
> +-----------------+
Hi all
steps are
shutdown the database
start & mount the database
copy the datafile at os level to the destination
issue
alter database rename 'old_datafile' to 'new_datafile';
then open the database
I am sure it works
Rohit
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Dec 01 2000 - 17:51:10 CST