Re: Help

From: Hari <hari_prasad_k_at_hotmail.com>
Date: Sat, 22 Feb 2003 18:39:57 +0530
Message-ID: <b37spv$1iboq2$1@ID-137434.news.dfncis.de>

Thanks a lot . It worked.

Regards
Hari.

"CSP" <cspp2201_at_netscape.net> wrote in message news:3E571704.9020803_at_netscape.net...
> Hari,
>
> Do the following:
>
> 1. Alter tablespace <tablespace_name> OFFLINE; #-- I am assuming you
> database is in Archive log mode.
> 2. !mv /opt/oracle/data/<file_name> /opt/oracle/<file_name>
> 3. alter database rename file <from> to <new_location>;
> 4. alter tablespace <tablespace_name> ONLINE;
>
> HTH
> CP
>
> Hari wrote:
> > Hi Guys ,
> >
> > I am SQL Server / Sybase DBA. Currently managing an Oracle 8.1.7 server.
> >
> > The issue is I have created a table space in \opt\oracle\data (solaris
> > server).
> >
> > But due to some space constrains I need to move the table space physical
> > file to \opt\oradata.
> >
> > How can I do this ?
> >
> > Regards
> > Hari.
> >
> >
> >
> >
> >
> >
>
Received on Sat Feb 22 2003 - 07:09:57 CST