Hi
This is the command
ALTER TABLE PWS.T_VTA_PG EXCHANGE PARTITION P202309 WITH TABLE
PWS.EXEC_T_VTA_PG
INCLUDING INDEXES WITHOUT VALIDATION
Thanks
On Mon, Sep 11, 2023 at 8:45 PM Tim Gorman <tim.evdbt@xxxxxxxxx> wrote:
Can you share the full ALTER TABLE syntax used?
Schema names and table names aren't important, please just mask them as
you wish, but I'm curious what is used for clauses like UPDATE GLOBAL
INDEXES (and are there any global indexes?) or WITH/WITHOUT VALIDATION,
etc?
On 9/11/2023 11:13 AM, Ls Cheng wrote:
Hi
Running 19.15.
I have some batch processes which run exchange partition commands then
run some ETL, sometimes the exchange partition takes minutes instead
of seconds and the ALTER is waiting for the library cache lock. From
ASH we can see that the blocking sessions are running queries against
the partition. I tried to reproduce the issue but in my tests the
exchange partition runs successfully and there is no library cache
lock while the table is being queried.
So I wonder what is exactly causing library cache lock to the
ALTER TABLE exchange partition?
Thanks
--
//www.freelists.org/webpage/oracle-l
