What is the correct syntax to use with the db import utility for selecting specific tables in TIBCO BusinessEvents (BE)?

book

Article ID: KB0088611

calendar_today

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).

Issue/Introduction

What is the correct syntax to use with the db import utility for selecting specific tables in TIBCO BusinessEvents (BE)?