Re: Online partition move 12.2.0.1
From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Thu, 4 Oct 2018 13:35:14 +0700
Message-ID: <CAP50yQ9yj_LauNgsp7wr-koXQQz3WKEY3oTOdHrDV3BWhthMgw_at_mail.gmail.com>
Date: Thu, 4 Oct 2018 13:35:14 +0700
Message-ID: <CAP50yQ9yj_LauNgsp7wr-koXQQz3WKEY3oTOdHrDV3BWhthMgw_at_mail.gmail.com>
What is the exact script / statement you're running? Are you setting ddl_lock_timeout? It might need to wait for any open transactions and may time out?
On Thu, Oct 4, 2018 at 11:57 AM, samrat roy <SAMRAT277_at_hotmail.com> wrote:
> Hi,
> I am trying online sub partition move but it fails with ORA-00054 resource
> busy error. Isn’t 12.2.0.1 claims that online move is possible while writes
> are going on the same segment. Writes are from goldengate replicate. Once
> replicats are stopped obviously it works. But is the expectation of 12c
> online move is “read online” ?
>
> -Samrat
-- // zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework! Visit us at zztat.net | _at_zztat_oracle | fb.me/zztat | zztat.net/blog/ -- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 04 2018 - 08:35:14 CEST