Re: Moving .dbf file from one moun to other mount

From: Pete's <empete2000_at_yahoo.com>
Date: 20 Sep 2004 06:35:40 -0700
Message-ID: <6724a51f.0409200535.5ab9d819@posting.google.com>

umeshoracle_at_yahoo.com (U C) wrote in message news:<fd94e273.0409200246.466bfbad_at_posting.google.com>...
> Hi,
> I am having two mounts where my .dbf files are store
> 1) oracle is first mount: its has near 4 .dbf file which carries data
> of organizatoin. with path as /oracle/data/.dbf
> 2) ora second mount: This mount also has 1 .dbf file which also
> carries data of customers. physical path /ora/.dbf
>
> both mount has different physical path.
>
> Now I want to move .dbf from mount 2 to mount 1 along with data
>
> what steps should i follow to achieve , this is mision critical for
> us.
>
> Please help
>
> regards
> U C

For the datafile(s) you want to move:

1.  Alter tablespace <tablespace> offline;
2.  move the file(s)
3.  alter database rename file
      'source location' to
      'destination location';

4. alter tablespace <tablepace> online;

You may have to do some media recovery before brining the tablespace back online. This is in the Oracle manuals.

HTH,
Pete's Received on Mon Sep 20 2004 - 08:35:40 CDT