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

Last updated on JULY 27, 2022

Applies to:

Symptoms

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

1.loaded gsmtelephony plan, created a couple of accounts with that plan
2.Now in 2 parallel sessions, executed 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 is seen

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

Cause

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