Oracle Enterprise stage

[krisna]

In oracle enterprise stage when I click on view data iam getting this error

Error executing View Data command
##E TDOR 000172 15:15:30(002) <Oracle_Enterprise_0> Access to sys.dba_extents is required but not available; please


##I TFCN 000001 15:15:29(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.2
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved


##I TUTL 000031 15:15:29(001) <main_program> The open files limit is 100; raising to 65536.
##I TOSH 000002 15:15:29(002) <main_program> orchgeneral: loaded
##I TOSH 000002 15:15:29(003) <main_program> orchsort: loaded
##I TOSH 000002 15:15:29(004) <main_program> orchstats: loaded
##I TFSC 000001 15:15:29(005) <main_program> APT configuration file: /data1/Ascential/DataStage/Configurations/Multinode.apt
##W TFPA 000017 15:15:29(006) <main_program> Warning: the value of the PWD environment variable (/export/home/dsadmin) does not appear to be a synonym for the current working directory (/data1/Ascential/DataStage/Projects/test). The current working directory will be used, but if your ORCHESTRATE job does not start up correctly, you should set your PWD environment variable to a value that will work on all nodes of your system.
##W TCOS 000049 15:15:30(000) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E TDOR 000172 15:15:30(002) <Oracle_Enterprise_0> Access to sys.dba_extents is required but not available; please
>see your database administrator for select privileges.
>##E TOPK 000000 15:15:30(005) <_PEEK_IDENT_> Input dataset does not have field: "A".
>##E TOPK 000000 15:15:30(006) <_PEEK_IDENT_> Input dataset does not have field: "B".
>##E TFSR 000019 15:15:30(008) <main_program> Could not check all operators because of previous error(s)
##W TFOR 000000 15:15:30(009) <Oracle_Enterprise_0> When checking operator: The modify operator has a binding for the non-existent output field "A".
##W TFOR 000000 15:15:30(010) <Oracle_Enterprise_0> When checking operator: The modify operator has a binding for the non-existent output field "B".
##W TFOR 000000 15:15:30(011) <Oracle_Enterprise_0> When checking operator: The modify operator keeps field "A" which is not present in the output interface.
##W TFOR 000000 15:15:30(012) <Oracle_Enterprise_0> When checking operator: The modify operator keeps field "B" which is not present in the output interface.
>##E TCOS 000029 15:15:30(013) <main_program> Creation of a step finished with status = FAILED.
>

[mahadev.v]

Code: Select all

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

Looks like you don't have select privileges.

[keshav0307]

not only sys.dba_extents select priviledge but some other sys table access is needed to use oracle enterprise stage, Read the online manual for list of tables.