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 |