For a parallel job, even if the job is reading or writting to a NON-partitioned Oracle table, does the job still need to access the the following Oracle system tables?
DBA_EXTENTS
DBA_DATA_FILES
DBA_TAB_PARTITONS
DBA_OBJECTS
In other words, regardless what type of Oracle table is accessed, the select privilege on the above system tables must be granted for a parallel job, is it true?
Your help is greatly appreciated...
Accessing NON-partitioned Oracle table
Moderators: chulett, rschirm, roy
Hi,
Look into this post.
Yes, regardless of what type of Oracle table is accessed, the select privilege on the above system tables should be granted in order for a parallel job using Oracle Enterprise stage to execute successfully.
HTH
Rich
Look into this post.
Yes, regardless of what type of Oracle table is accessed, the select privilege on the above system tables should be granted in order for a parallel job using Oracle Enterprise stage to execute successfully.
HTH
Rich