OraFAQ Forum: SQL & PL/SQL » Future Partitions

Home » SQL & PL/SQL » SQL & PL/SQL » Future Partitions (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Future Partitions [message #608519]

Thu, 20 February 2014 08:06

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

Hi,

How to check for the tables(OR Table list) that may need future partitions?
Can we get from data dictionary tables?

Regards,
SRK

Report message to a moderator

Re: Future Partitions [message #608522 is a reply to message #608519]

Thu, 20 February 2014 08:11

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Oracle does not know which data you will insert.
It can only tell you which ones you have inserted.
dba_tab_partitions gives you the current partitions.
If you have partition by date range then you should investigate in interval partitioning, there Oracle will create the partitions when needed.

Report message to a moderator

Re: Future Partitions [message #608526 is a reply to message #608522]

Thu, 20 February 2014 08:23

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

Thanks a lot

Report message to a moderator

Previous Topic:	alias name in where clause
Next Topic:	how to get previous row value?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 11:54:23 CDT 2024