My Oracle Support Banner

EXPLIB_D0002 Message: 'syntax error, unexpected <TABLE_NAME>' Harvesting A Teradata A Foreign Table (Doc ID 2402798.1)

Last updated on MAY 29, 2018

Applies to:

Oracle Enterprise Metadata Management - Version and later
Information in this document applies to any platform.


On Oracle Enterprise Metadata Management (OEMM), while importing from Teradata, OEMM does not recognize any Teradata object that references a foreign table.

[586/main] 2018-04-18 01:34:57 EXPLIB_D0002 Message: 'syntax error, unexpected TABLE_TOKEN'
Context: ' from foreign table'
Location: '(1,2249,1,2254)'
Expression tool type: 'Generic'
Expression database type: 'Teradata'
Expression text: 'replace procedure SBX_DB_SME_DKK_ANALYSE.p_t_NCF_facts(out ret_code int,in parent_session_id char(16))


NOTE: "foreign table" on Teradata is very similar to Oracle "Database links"





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

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

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