Hi !

Refer Chapter -13 "Managing Partitioned Tables and Indexes
of Oracle Administrator's Guide !

Regards
Vijay K


Peace On Earth wrote:

> Could not find much information about partitions on the web so I am
> going to ask a few questions
>
> What is the concept of partitions?
>
> How do you build partitions?
>
> How do you name partitions?
>
> I have heard that partitions can be "activated" and "deactivated".
> What exactly is this?
>
> Is there a maximum # of partitions for a table/tablespace/schema?
>
> Thanks
>
> Riz
>
> Vijay Krishnan wrote:
>
> Hi Riz !
>
> If I clearly understand you have to create the customer
> tables every
> month to store the data in that particular month ! Why cant
> you use the
> table
> partition option to store the data separately in their
> respective
> paritions ! In
> this way you can even dynamically add paritions for the
> respective
> months and at
> the same time you dont have to change the underlaying
> program codes as
> you
> will be logically querying from one table only ! Hope this
> solves your
> problem ! You have to name only the partitions according to
> the months !
>
>
>
> Regards
> Vijay K
>
>
> Peace On Earth wrote:
>
> > I inherited this solution from someone - the date thing
> surely makes
> > sense. However, the second part of the question remains
> unanswered...
> >
> > and a table XYZ where there is no need to have
>
> >
> > columns added to a! ccomodate the extra data
> >
> > Thanks
> >
> > Riz
> >
> >
>
>
> -----------------------------------------------------------------------
> Do You Yahoo!?
> Yahoo! Finance - Get real-time stock quotes
Oracle LazyDBA home page