It's all about the answers!

Ask a question

Can DW ETL user be setup without QUOTA UNLIMITED on the Oracle tablespaces?


ankur sharma (66212228) | 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



permanent link
ankur sharma (66212228) | answered Jan 07 '13, 4:13 a.m.
JAZZ DEVELOPER
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


Register or to post 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.