Why do we do partition of tables & how

Any articles that I can read?

-----Original Message-----
From: Ofer Harel
[mailto:oracledba-ezmlmshield-x80758101.[Email address protected]
Sent: Wednesday, May 31, 2006 3:30 AM
To: LazyDBA Discussion
Subject: RE: How to check the partitions for a table

Good morning Kiran

There are few table is the dba_ or user_ division

dba_part_tables (for all tables) or user_part_tables for a specific user
give you information about the partition table itself
dba_part_tables or user_part_tables give you information for all
partitions of partition tables

There are many other tables.
Those who start with dba_part... give you information for the object
itself (such as dba_part_indexes, dba_part_lobs, etc.)
While those with name of dba_..._partitions, dba_..._subpartition give
you the information for every partition

HTH
Ofer

-----Original Message-----
From: kiran
[mailto:oracledba-ezmlmshield-x47050733.[Email address protected]
Sent: Tuesday, May 30, 2006 1:51 PM
To: LazyDBA Discussion
Subject: How to check the partitions for a table

Hello DBAs,

is there any query or table to check the partitions for a given table

please help me...

Thanks in advance

Kiran Pulibandla
Tata Consultancy Services Limited
International Tech Park,
Innovator, 11th Floor,
Whitefield Road,
Bangalore - 560066,Karnataka
India
Mailto: kiran.[Email address protected]
Website: http://www.tcs.com
=====-----=====-----=====
Notice: The information contained in this e-mail message and/or
attachments to it may contain confidential or privileged information. If
you are not the intended recipient, any dissemination, use, review,
distribution, printing or copying of the information contained in this
e-mail message and/or attachments to it are strictly prohibited. If you
have received this communication in error, please notify us by reply
e-mail or telephone and immediately and permanently delete the message
and any attachments. Thank you




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html




**********************************************************************
The information contained in this e-mail message may be
privileged and confidential. The information is intended only
for the use of the individual or entity named above. If the
reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying
of this communication is strictly prohibited. If you have
received this communication in error, please notify us
immediately by telephone, or by e-mail and delete the message
from your computer. Thank you!
Unless otherwise stated, any views or opinions expressed in
this e-mail are solely those of the author and do not represent those of

Barak I.T.C (1995) The International Telecommunications Services Corp.
Ltd.
**********************************************************************



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page