Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

Questions
Tags
Users
Badges
ankur sharma
JAZZ DEVELOPER (662●1●22●28) 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?

0 votes

1 answer
4,953 views
0 votes

One answer

Permanent link
ankur sharma
JAZZ DEVELOPER (662●1●22●28) Jan 07 '13, 4:13 a.m.
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

0 votes

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 2,357
× 42

Question asked: Jan 07 '13, 4:11 a.m.

Question was seen: 4,953 times

Last updated: Jan 07 '13, 4:14 a.m.

Related questions
Confirmation Cancel Confirm