Loading Data into a PX Job from Oracle
Posted: Mon Nov 15, 2004 11:54 am
We are currently trying to load data into Datastage with a px job. The job runs fine if we run it as a server job with a user defiend query. However when we run it as a px job we get the following warning followed by the following error:
main_program: An NLS map <ISO-8859-1> is specified, but NLS_LANG is not set. The NLS map must be set to an ICU codepage which is equivalent to the character set specified by NLS_LANG
Oracle_Enterprise_8: Access to sys.dba_extents required but not available. Please see your dba for select privileges
main_program: An NLS map <ISO-8859-1> is specified, but NLS_LANG is not set. The NLS map must be set to an ICU codepage which is equivalent to the character set specified by NLS_LANG
Oracle_Enterprise_8: Access to sys.dba_extents required but not available. Please see your dba for select privileges