What is the correct syntax to use with the db import utility for selecting specific tables in TIBCO BusinessEvents (BE)?
Article ID: KB0088611
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessEvents Enterprise Edition | - |
| Not Applicable | - |
Description
Resolution:
Description
=========
What is the correct syntax to use with the db import utility for selecting specific tables in TIBCO BusinessEvents (BE)?
Environment
==========
BusinessEvents 4.x and 5.x
Resolution
=========
In BE 4.x and 5.x:
The db import utility expects two columns and the columns are schema_name, table_name.
e.g., select ‘BE_USER’, table_name from user_tables where table_name like ‘BE_%’
Also, the schema_name is case-sensitive (upper-case).
Description
=========
What is the correct syntax to use with the db import utility for selecting specific tables in TIBCO BusinessEvents (BE)?
Environment
==========
BusinessEvents 4.x and 5.x
Resolution
=========
In BE 4.x and 5.x:
The db import utility expects two columns and the columns are schema_name, table_name.
e.g., select ‘BE_USER’, table_name from user_tables where table_name like ‘BE_%’
Also, the schema_name is case-sensitive (upper-case).
Issue/Introduction
What is the correct syntax to use with the db import utility for selecting specific tables in TIBCO BusinessEvents (BE)?
Feedback
Yes
No
Powered by
