what are different types of partitioning in oracle ?

Answers were Sorted based on User's Feedback



what are different types of partitioning in oracle ?..

Answer / sabeena

In Oracle you can partition a table by

• Range Partitioning
• Hash Partitioning
• List Partitioning
• Composite Partitioning

Is This Answer Correct ?    42 Yes 3 No

what are different types of partitioning in oracle ?..

Answer / msb.dwh

HASH
RANGE

Is This Answer Correct ?    7 Yes 11 No

what are different types of partitioning in oracle ?..

Answer / sachs

Partition by good bad
Partion by rich poor
Partition by boy girl
Partition by right wrong

Is This Answer Correct ?    4 Yes 30 No

Post New Answer

More Data Warehouse General Interview Questions

Explain the difference between keylokup and joiner?

0 Answers  


What is the difference between metadata and data dictionary?

0 Answers  


What is data analysis?

0 Answers  


What are the mapping paramaters and maping variables?

0 Answers  


How can you communicate with web server (apache or iis) from coldfusion?

0 Answers  






Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

0 Answers  


How to know the time taken for particular report execution?

0 Answers  


What is the extension of file to save template?

0 Answers  


What is hash partition?

3 Answers   TCS,


What are aggregate tables and aggregate fact tables?

0 Answers  


Who needs data warehousing?

0 Answers  


Explain multivalued dependency?

0 Answers  


Categories