Partitions and tablespaces

Author: asktom.oracle.com | Published: 21st Aug 2006 | Visited: 154 times | Add Comment
Filed in: Oracle FAQ

I have an application that collects different data from several probes. Data are processed and written to the database, where analysis is performed. Data once written are never updated, only queried. Data will be store in a FiberChannel SAN using SAM...

Read Article

Sponsored Links

• Partitioning tables with unequal partitions. Hi Tom, We have data coming into our application from different entities/agencies and being loaded into several different tables. Each transmission contains data that belongs to a unique entity. We can also receive a new transmission for each ent ...

• warehouse partitions and execution plans hi tom in oracle we have two types of histograms height based and width based. why we have two types of histrograms? do these two histograms effect execution plan. because histograms represents data skewness. does data skewness in both the histog ...

• partitions and parallel processing hi tom thanks for this wonderful forum I have a question regarding oracle parallel processing and partition. before oracle 9.2 parallel processing is not possible without partitioning and DOP was equal to number of partitions. however this beh ...

• Database Partitions Task Database Partitions for SSIS is a new Control Flow Task for managing database partitions in SQL Server 2005. Key features are - . Create partition table based on target table. Insert partition table into target table. Remove partition from target table. Combine smaller partitions into a larger ...

• Is there any way of virtualizing tablespaces? Hi I am working on some schema creation scripts. The target production environment has many tablespaces defined as you would expect, but I am prototyping the scripts against a local XE environment (on VMWare Linux). It would be convenient if ther ...

• "Selective" Indexing of Partitions Hi Tom, Do you know of any plans to allow indexing of only selected partitions, not all of them? For example, if partitions are significantly different in size or if data in one of them is skewed it may be beneficial to have an index on one and n ...

• Questions on Table Partitions Hi Tom, Thanks for opening link to ask questions I have couple of questions 1.I have a partitioned table and each partition on different tablespace.I want to determine how much of tablespace is full for each partition.And one tablespace may ...

• Move partitions to different tablespace Hi Tom, I need to move partitioned table partitions to different tbs, but I get error:- alter table TEST move tablespace TEST_TBS; alter table TEST move tablespace TEST_TBS * ERROR at line 1: ORA-14511: cannot perform operation o ...

• PARTITIONS vs seperate tables Hi Tom , we have an application which uses range partitions on begin dates and end dates (just 2 fields) . almost always we run a query which has a between 2 dates clause in where part of eg begin_dt > input 1 and end_dt < input 2 TAbl ...

Next: Sql query