You can use the following:

# where the datafiles are located now.

create directory source_dir as '+ASM_GRP/';

# where the datafiles will be moved to

create directory dest_dir as '/oradata/';

# Offline the tablespace to move

Alter tablespace data1 offline;

# Copy the datafile

exec dbms_file_transfer.copy_file('SOURCE_DIR','data01.dbf', 'DEST_DIR','data01.dbf');

# Rename the datafile

ALTER DATABASE RENAME file '+ASM_GRP/data01.dbf' TO '/oradata/data01.dbf';

# Put tablespace online

ALTER TABLESPACE data1 online;

Database is open and users can access other tablespaces.


Yves Leonard,
Chef de Projet - DBA / Project Leader - ABD,
DDS / SDD,
Centre de Technologie d'Oracle / Oracle Technology Center,
RH Coats, 13-I
Téléphone / phone : 613-951-3233,
couriel / email : yves.[Email address protected]


-----Original Message-----
From: George [mailto:oracledba-ezmlmshield-x26567879.[Email address protected]
Sent: April 29, 2008 9:10 AM
To: LazyDBA Discussion
Subject: Migrating data from ASM to non-ASM Instance

Hello everyone,

I've been tasked with creating a new 10g database (on Linux) using raw
partitions, which will replace an existing 10g installation using ASM. The
purpose of the task is to eliminate ASM from the current environment. Is
exporting/importing the 400+ GB of data between the two databases my only
option? Any suggestions would be greatly appreciated.

Regards,
George
*****************************************************************
<<<Disclaimer>>>

In compliance with applicable rules and regulations, Instinet
reviews and archives incoming and outgoing email communications,
copies of which may be produced at the request of regulators.
This message is intended only for the personal and confidential
use of the recipients named above. If the reader of this email
is not the intended recipient, you have received this email in
error and any review, dissemination, distribution or copying is
strictly prohibited. If you have received this email in error,
please notify the sender immediately by return email and
permanently delete the copy you received.

Instinet accepts no liability for any content contained in the
email, or any errors or omissions arising as a result of email
transmission. Any opinions contained in this email constitute
the sender's best judgment at this time and are subject to change
without notice. Instinet does not make recommendations of a
particular security and the information contained in this email
should not be considered as a recommendation, an offer or a
solicitation of an offer to buy and sell securities.

*****************************************************************



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page