DomainKey-Signature: a=rsa-sha1; c=nofws;        d=gmail.com; s=gamma;        h=mime-version:sender:date:x-google-sender-auth:message-id:subject         :from:to:content-type;        b=OGvXkWCEVXj9lEOLdHYT3Tc6g91FH8UgF+s0O+6yJWPcFImLZWIdlze/rIJFLOPk+M         zMypYqlt2HtMnKf7r9er4SJ29hNshxvZQD4lcXGGKmtJnPqKnGCVCZkua0U4yeKMN3zk         koL9SE5i52mfR0ORG3m/wS/vAmVhI/mNwMbvc=
MIME-Version: 1.0
Date: Wed, 3 Feb 2010 14:42:25 +1100
Message-ID: <77a615a71002021942u487319dcqca46f782a52dad3b@mail.gmail.com>
Subject: cloning subset with RMAN and partitioned tables
From: Jack van Zanen <jack@vanzanen.com>
To: oracle-l@freelists.org
Content-Type: multipart/alternative; boundary=001636b14dcfbb8371047eaa01fd
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: jack@vanzanen.com
--001636b14dcfbb8371047eaa01fd
Content-Type: text/plain; charset=ISO-8859-1

Hi,


I have the following issue

I have been asked to clone a subset of a very large database. Sofar nothing
tricky and this works fine,

however...this database has a partitioned table with sub partitions spread
over multiple tablespaces. some of which have not been cloned across as the
requirement was the last few months worth of data.

RMAN clone command was succesful till the last bit where it tried to drop
the tablespaces that were skipped. After that the database opened fine but
subsequent selects on the table complain about missing datafiles
(understandably) but I have no idea how to solve the problem.

I have tried offlining the tablespace (no error but does not solve the
problem)
I have tried dropping the partition "ORA-14268: subpartition 'SYS_SUBP437'
of the partition resides in offlined tablespace"
I have tried dropping the sub partitions  but get error  ORA14616 table not
partitioned by List method"
I have tried offline the datafiles that are missing, but this does not solve
the problem (mount and open mode).
I have tried offline drop the datafiles that are missing, but this does not
solve the problem (mount and open mode).
I have tried to recreate the controlfile without the missing datafiles, no
luck

Any other suggestions?

-- 
Jack van Zanen

-------------------------
This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient. If you are not the intended recipient,
please be aware that any disclosure, copying, distribution or use of this
e-mail or any attachment is prohibited. If you have received this e-mail in
error, please contact the sender and delete all copies.
Thank you for your cooperation

--001636b14dcfbb8371047eaa01fd
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div>Hi,</div>
<div>=A0</div>
<div>=A0</div>
<div>I have the following issue</div>
<div>=A0</div>
<div>I have been asked to clone a subset of a very large database. Sofar no=
thing tricky and this works fine, </div>
<div>=A0</div>
<div>however...this database has a partitioned table with sub partitions sp=
read over multiple tablespaces. some of which have not been cloned across a=
s the requirement was the last few months worth of data.</div>
<div>=A0</div>
<div>RMAN clone command was succesful till the last bit where it tried to d=
rop the tablespaces that were skipped. After that the database opened fine =
but subsequent selects on the table complain about missing datafiles (under=
standably) but I have no idea how to solve the problem.</div>

<div>=A0</div>
<div>I have tried offlining the tablespace (no error but does not solve the=
 problem)</div>
<div>I have tried dropping the partition &quot;ORA-14268: subpartition &#39=
;SYS_SUBP437&#39; of the partition resides in offlined tablespace&quot;</di=
v>
<div>I have tried dropping the sub partitions=A0 but get error=A0 ORA14616 =
table not partitioned by List method&quot;</div>
<div>I have tried offline the datafiles that are missing, but this does not=
 solve the problem (mount and open mode).</div>
<div>I have tried offline drop the datafiles that are missing, but this doe=
s not solve the problem (mount and open mode).</div>
<div>I have tried to recreate the controlfile without the missing datafiles=
, no luck</div>
<div>=A0</div>
<div>Any other suggestions?<br></div>
<div>=A0</div>
<div>-- <br>Jack van Zanen<br><br>------------------------- <br>This e-mail=
 and any attachments may contain confidential material for the sole use of =
the intended recipient. If you are not the intended recipient, please be aw=
are that any disclosure, copying, distribution or use of this e-mail or any=
 attachment is prohibited. If you have received this e-mail in error, pleas=
e contact the sender and delete all copies.<br>
Thank you for your cooperation <br></div>

--001636b14dcfbb8371047eaa01fd--
--
http://www.freelists.org/webpage/oracle-l