Can DW ETL user be setup without QUOTA UNLIMITED on the Oracle tablespaces?
![]()
ankur sharma (662●1●22●28)
| asked Jan 07 '13, 4:11 a.m.
JAZZ DEVELOPER edited Jan 07 '13, 4:14 a.m.
Is the 'QUOTA UNLIMITED' necessary while defining the tablespaces in Oracle dB for the data warehouse setup?
|
One answer
![]()
https://jazz.net/wiki/bin/view/Main/MoreControlOverTheOracleDataWarehouseSetup has more information on how the Oracle dB is setup for data warehouse.
If the dB policy does not allows 'QUOTA UNLIMITED' then it can be skipped and the commands would look like ALTER USER <etl db user> QUOTA <size> ON VNF_32K; l |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.