DSXchange

While using the "Import Orchestrate Schema" utility and selectiong the following options

Checked - Database table (via orchdbutil)
Name of database table - LIAB_ADJ_TYPE_REF
For owner: SOSSTG
DBMS type: Oracle
Database name: grey out
Database server: XXXXX
User name: XXXX
Password: XXXXX


I get the follow error message from "Output fromserver command" box - see below


##I TUTL 000031 08:38:59(002) <main_program> The open files limit is 100; raising to 1024.
##I TCDB 000003 08:39:00(000) <main_program> Oracle: loaded
##I TCDU 000009 08:39:00(001) <main_program> Database connect options: dbname= <unspecified>, server='XXXXX',
dboptions='{user='SOSSTG',password='XXXXX'}'.
##I TCDU 000005 08:39:00(002) <main_program> Database connect options: dbname= <unspecified>, server='XXXXX',
dboptions='{user='SOSSTG',password='SSSSS'}'DB type 'oracle' presumed to be oracle.
##E TCDU 000017 08:39:00(003) <main_program> Unable to get a schema for show.

Does anyone know on why I'm getting the above error?

Thanks.

Possibly the user does not have SELECT privilege to the Oracle system tables in which the metadata are stored.

Are you saying the user's id has to have access to oracle objects where owner is 'SYS' ?

Thanks.

Some of them - eight from memory - yes. Which ones is documented in one of the manuals, but I can't check which one at the moment (in airport lounge). Maybe the Oracle Connectivity Guide.