Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: DBMS_FILE_TRANSFER

Re: DBMS_FILE_TRANSFER

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Thu, 9 Nov 2006 21:44:58 -0500
Message-ID: <c2213f680611091844g333c9dc0tff207118f56c0a4e@mail.gmail.com>


AFAIK, no. You should use RMAN restore to keep it OMF. With DBMS_TRANSFER _you_ control the naming. Thus, no OMF.

On 11/9/06, Ebadi, Abdul <Abdul.Ebadi_at_level3.com> wrote:
> Does anyone know how to copy an Oracle-managed ASM datafile using
> DBMS_FILE_TRANSFER.COPY_FILE keeping the status of the file as
> oracle-managed after the copy/rename? We are get error ORA-15046 when
> trying to do this. We can copy the file to another name and it works just
> fine, but the problem is it is no longer an oracle-managed file, which is
> not what we want. Any suggestions?

-- 
Best regards,
Alex Gorbachev

The Pythian Group
Sr. Oracle DBA

http://www.pythian.com/blogs/author/alex/
http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 09 2006 - 20:44:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US