Question Regarding Having Seen Occurrences Of ORA-01466 (Doc ID 2882705.1)

Last updated on FEBRUARY 18, 2024

Applies to:

Symptoms

The issue can be reproduced at will with the following steps:

1. Load gsmtelephony plan, create a couple of accounts with that plan
2. Now in 2 parallel sessions, execute the following:
   Session-1: pin778:
   sqlplus pin778/pin778@pindb
   SQL> @compress_db.sql
   The above script has the following content and takes around 3-4 minutes to execute
   BEGIN
   FOR I IN 1..100 LOOP
   EXECUTE IMMEDIATE 'ALTER TABLE EVENT_T MOVE PARTITION PARTITION_LAST
   COMPRESS PCTFREE 0 ONLINE';
   DBMS_LOCK.SLEEP(2);
   --DBMS_LOCK.SLEEP(.25);
   END LOOP;
   END;
   /
   In the meantime in another window:
   Session-2:pin778
   Select poid_id0 from event_t; (better to execute this from SQL developer because ids are shown in exponential form in unix.
   Select 1 particular id.
   Search for the id in testnap using the script below, after substituting the respective id.
   0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
   0 PIN_FLD_FLAGS INT [0] 768
   0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
   1        PIN_FLD_POID POID [0] 0.0.0.1 /event/session 331630299123300311 0
   0 PIN_FLD_TEMPLATE STR [0] "select X from /event where F1 = V1 "
   0 PIN_FLD_RESULTS ARRAY [*] NULL array ptr

Keep executing the script while the compress script is running, until the below error:

ERROR
-----------------------

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.