My Oracle Support Banner

Replicate Seed data errors with: Ora-20000: Ora-01653: Unable To Extend Table Jtf.Jtf_qual_usgs_all (Doc ID 312549.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Territory Management - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Purpose


Replicate seed data program erroring with the following

declare
*
ERROR at line 1:
ORA-20000: ORA-01653: unable to extend table JTF.JTF_QUAL_USGS_ALL by 128 in
tablespace JTFD:ad_morg.replicate_table_data(JTF_QUAL_USGS_ALL,284):INSERT INTO
JTF_QUAL_USGS_ALL (QUAL_USG_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, APPLICATION_SHORT_NAME,
SEEDED_QUAL_ID, QUAL_TYPE_USG_ID, ENABLED_FLAG, QUAL_COL1, QUAL_COL1_ALIAS,
QUAL_COL1_DATATYPE, QUAL_COL1_TABLE, QUAL_COL1_TABLE_ALIAS, PRIM_INT_CDE_COL,
PRIM_INT_CDE_COL_ALIAS, PRIM_INT_CDE_COL_DATATYPE, SEC_INT_CDE_COL,
SEC_INT_CDE_COL_ALIAS, SEC_INT_CDE_COL_DATATYPE, INT_CDE_COL_TABLE,
INT_CDE_COL_TABLE_ALIAS, COLUMN_COUNT, SEEDED_FLAG, CONVERT_TO_ID_FLAG,
DISPLAY_TYPE, LOV_SQL, FORMATTING_FUNCTION_FLAG, FORMATTING_FUNCTION_NAME,
SPECIAL_FUNCTION_FLAG, SPECIAL_FUNCTION_NAME, ENABLE_LOV_VALIDATION,
DISPLAY_SQL1, LOV_SQL2, DISPLAY_SQL2, LOV_SQL3, DISPLAY_SQL3, RULE1, RULE2,
DISPLAY_SEQUENCE, DISPLAY_LENGTH, JSP_LOV_SQL, USE_IN_LOOKUP_FLAG, ALIAS_RULE1,
ALIAS_RULE2, ALIAS_OP_LIKE, ALIAS_OP_BETWEEN, ALIAS_LINE_ITEM, OP_E"

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
 

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