Import Orchestrate Schema

[nspi]

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.

[ray.wurlod]

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

[nspi]

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

Thanks.

[ray.wurlod]

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.