Error while loading to oracle

[jusami25]

We are using Oracle Enterprise Stage and have this error:

"Oracle: Access to sys.dba_data_files is required but is not available;
please see your database administrator for select privileges. "

However, when we Load with ODBC Enterprise with same user, the load is correct. So we are wondering why we are getting this error message.

Could you please let me know any possible reasons for this?

Thanks in advance

[OddJob]

Try using the search facility on this forum using 'sys.dba_data_files' as your search term

[sureshabbisetti]

Hi,

Your DBA has to give the permissions to Datastage server.
CREATE ROLE DSXE;
GRANT SELECT on sys.dba_extents to DSXE;
GRANT SELECT on sys.dba_data_files to DSXE;
GRANT SELECT on sys.dba_tab_partitions to DSXE;
GRANT SELECT on sys.dba_tab_subpartitions to DSXE;
GRANT SELECT on sys.dba_objects to DSXE;
GRANT SELECT on sys.all_part_indexes to DSXE;
GRANT SELECT on sys.all_part_tables to DSXE;
GRANT SELECT on sys.all_indexes to DSXE;

Regards
Suresh

[OddJob]

That won't help unless you then grant the role to each of the users as required:

GRANT DSXE to <oracle user id>;

[keshav0307]

read the pre requirement of using Oracle Enterprize stage.
the oracle user need access to sub sys tables abd views.