Re: Help

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 Fri Feb 21 2003 - 22:22:54 CST