OraFAQ Forum: Performance Tuning » create dynamic partitions in oracle 9

Home » RDBMS Server » Performance Tuning » create dynamic partitions in oracle 9 (oracle9i/ windows)

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

create dynamic partitions in oracle 9 [message #397394]

Fri, 10 April 2009 08:45

parasuramchekuri
Messages: 32
Registered: March 2007
Location: vishakapatnam

Member

hi all
i need to partition my sales table with intervals of every three months...
can i create every three months

thanks
ram

Report message to a moderator

Re: create dynamic partitions in oracle 9 [message #397395 is a reply to message #397394]

Fri, 10 April 2009 08:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>can i create every three months
I give up. Can you?

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Please, please, please Read & Follow Posting Guidelines above.
Go to the section labeled "Practice" & do as directed.

Report message to a moderator

Re: create dynamic partitions in oracle 9 [message #397398 is a reply to message #397394]

Fri, 10 April 2009 08:50

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes you can... manually (or script).

Regards
Michel

Report message to a moderator

Re: create dynamic partitions in oracle 9 [message #397399 is a reply to message #397398]

Fri, 10 April 2009 08:52

parasuramchekuri
Messages: 32
Registered: March 2007
Location: vishakapatnam

Member

hi
i want create partitions in dynamic manner..
thanks
ram

Report message to a moderator

Re: create dynamic partitions in oracle 9 [message #397401 is a reply to message #397399]

Fri, 10 April 2009 08:55

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

parasuramchekuri wrote on Fri, 10 April 2009 15:52

hi
i want create partitions in dynamic manner..
thanks
ram

And your problem is?

Regards
Michel

Report message to a moderator

Re: create dynamic partitions in oracle 9 [message #397402 is a reply to message #397394]

Fri, 10 April 2009 08:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I want it to stop raining.
Please assist.

Report message to a moderator

Re: create dynamic partitions in oracle 9 [message #397403 is a reply to message #397401]

Fri, 10 April 2009 08:59

parasuramchekuri
Messages: 32
Registered: March 2007
Location: vishakapatnam

Member

hi

My problem is

i am creating the partitions to my sales table to every three months...

if completes the tree months it will be created automatically for next three months....

thanks
ram

Report message to a moderator

Re: create dynamic partitions in oracle 9 [message #397405 is a reply to message #397394]

Fri, 10 April 2009 09:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Just precreate for next decade manually.

Report message to a moderator

Re: create dynamic partitions in oracle 9 [message #397428 is a reply to message #397403]

Fri, 10 April 2009 11:13

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

parasuramchekuri wrote on Fri, 10 April 2009 15:59

hi

My problem is

i am creating the partitions to my sales table to every three months...

if completes the tree months it will be created automatically for next three months....

thanks
ram

And in the process of writing this, where is your problem?
Or are you expecting we write it for you?

Regards
Michel

Report message to a moderator

Re: create dynamic partitions in oracle 9 [message #397490 is a reply to message #397428]

Sat, 11 April 2009 07:25

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

There is no option in 9i to create partitions automatically as they are needed.

You can pre-create them, or you can write a program that creates them for you and schedule it with DBMS_JOB

Ross Leishman

Report message to a moderator

Previous Topic:	Bind variable versus CURSOR_SHARING='SIMILAR'
Next Topic:	TKprof shows fetching taking long time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 18:04:41 CST 2024