Post is stopped due to ORA-01683 as shown below:
Notice 2009-01-28 03:46:17.628436 16809 2931817376 Poster: ORA-01683: unable to extend index OWNER.INDEX_NAME partition PARTITION_NAME by 8192 in tablespace TABLESPACE_NAME. (posting from SOURCE_SID, queue queue_name, to TARGET_SID) [module osp]
Error 2009-01-28 03:46:17.631362 16809 2931817376 Poster: Unexpected Oracle error: ORA-01683: unable to extend index OWNER.INDEX_NAME partition PARTITION_NAME by 8192 in tablespace TABLESPACE_NAME. (object name: "OWNER"."TABLE_NAME") (posting from SOURCE_SID, queue queue_name, to TARGET_SID) [module opo]
Info 2009-01-28 03:46:18.103491 16007 4141389504 Poster exited with code=1, pid = 16809 (posting from SOURCE_SID, queue queue_name, to TARGET_SID)
Oracle is not able to extend the tablespace associated with the index.
Oracle is not able to extend the tablespace associated with the index named OWNER.INDEX_NAME. To resolve the problem, add more space to the tablespace in question by “ALTER TABLESPACE ADD DATAFILE……”. Then restart the Post process.
Here is the description of the Oracle error ORA-01683:
ORA-01683 unable to extend index string.string partition string by string in tablespace string
Cause: Failed to allocate an extent for index segment in tablespace.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center