It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787
×2,338
×94
×42
×14

question asked: Jan 07 '13, 4:11 a.m.
question was seen: 4,400 times
last updated: Jan 07 '13, 4:14 a.m.

Related questions

FAQ - How this Forum works

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

0
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

Most liked answers|Newest answers|Oldest answers ↓

0
permanent link
ankur sharma (662●1●22●28) | 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.