1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc)

ORACLE Tutorials

Schema Object Management,Schema Management in Oracle


Schema Object Management,Schema Management
Where do you find information about partitioned tables?
The dba_tab_partitions view gives detailed information on partitioned tables.
SQL>select table_name,partition_name,subpartition_count from dba_tab_partitions;
What is splitting a partition?
Splitting a partition takes the data in the existing partition and distributes it between two partitions.SPLIT PARTITION clause is used to achieve it.
SQL>alter table table-name split partition partition-name at(column-value) into (partition partition-name1,partition-name2);
What is merging a partition?
Merging a partition combines the contents of two adjacent partitions.We use MERGE PARTITIONS command to achieve this.
SQL>alter table tab-name merge partitions par1,par2 into partition par-merged;

Reviews and Comments


PMP, CAPM, PMI is a registered certification mark of the Project Management Institute, Inc

Copyright © www.techfaq360.com 2016


About US | Contact US | Privacy Policy | Terms and Conditions  | Website disclaimer  | Cancellation and Refund Policy  | Shipping & Delivery Policy