what are different types of partitioning in oracle ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of data warehousing?

727


What are the differences between star and snowflake schema?

737


Explain what is the advantages data mining over traditional approaches?

830


Explain what is a staging area? Do we need it? What is the purpose of a staging area?

761


How to get the first 100 rows from the flat file into the target?

944


What is the metadata extension?

771


What is partitioning? What are the types of partitioning?

793


What are the stages of datawarehousing?

771


What is dimension modeling?

720


What are universe requirements?

744


Explain why are oltp database designs not generally a good idea for a data warehouse?

814


How to reduce warnings?

743


What are non-additive facts in detail?

774


Explain the definition of normalized and denormalized view and what are the differences between them?

732


What is batch processing?

800