From: <paul_at_paulpowell.plus.com>
Date: Tue, 27 Jan 2009 07:28:39 -0800 (PST)
Message-ID: <4eb2204c-0697-4152-b68e-30b69151fa52_at_h16g2000yqj.googlegroups.com>

We have recently upgrade one of our systems to a new server which has a different file structure in both location and size.

 Is there a way to split a single datafile over many datafiles when using RMAN clone features.

For Example

Source file INDEX_01.dbf size 20GB

Destination file(s) INDEX_01.dbf size 10GB and INDEX_02.dbf size 10GB


set newname for datafile 1 to 'e:\Oracle\oradata\INDEX_01.DBF','e: \Oracle\oradata\INDEX_02.DBF';


Many Thanks for all your advice. Received on Tue Jan 27 2009 - 09:28:39 CST

Original text of this message