Post is encountering ORA-00972. (4362173)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Post is encountering ORA-00972.
Description

Post has stopped and is encountering "Poster: ORA-00972: identifier is too long".

Error 2022-07-07 15:03:33.148422 20928 3669763840 s:3 Poster: que/seq = 3/ 0 seqno/offset = 2557/716304 Unexpected Oracle error: ORA-00972: identifier is too long (object name: "<schema_owner>"."<table_name>(<column1>,<column2>") (posting from o.ora11g, queue splexsupl133, to o.ora11g) [module opo]
Cause

Can be caused by the following:

1. Incorrect syntax used in the config file, e.g. no space between table name and defined vertical partitioned column list.

user.table_name (column1,column2) user.table_name(column1,column2) target_server@o.TARGETSID

In the above example, there is no space between the target table and list of Vertically Partitioned columns.

Below example shows correct syntax with the space in place.

user.table_name (column1,column2) user.table_name (column1,column2) target_server@o.TARGETSID

2. Column name longer than 30 characters defined in the config file where target compatibility is Oracle 11g.
Resolution

1. Ensure that syntax is correct in config file, verify and activate it again.

2. Exclude columns of more than 30 characters from replication by excluding them in the config, verify and activate it again.
Additional Information

This issue only occurs in SharePlex 10.0. In higher versions, this may cause an "ORA-00942: table or view does not exist" error.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title