OraFAQ Forum: Performance Tuning » New User Help Me Out (merged 2)

Home » RDBMS Server » Performance Tuning » New User Help Me Out (merged 2) (Oracle 11gR2, Linux)

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

New User Help Me Out (merged 2) [message #548127]

Tue, 20 March 2012 08:11

shehzaadkareem
Messages: 3
Registered: March 2012
Location: india

Junior Member

Friends i am a new user on this forum .

Sorry i couldnt post in appropriate Topic as i couldnt judge to post my question in which topic so posting here .Moderators Sorry for this.

My Questions is:

I want to insert 10mb of data into a database named db1

I want the 10mb arrangement of data in such a way that the first 3 mb should go in tablespace named ts1

Next 4mb should go in tablespace named ts2.

remaining 3mb should go in tablespace named ts3.

Can anyone help me out how can i make it happen.The motto is how can a user allocate specific amount of data to a particular tablespace and remaining to other tablespace.

Thanks In Advance Smile

Report message to a moderator

Re: New User Help Me Out (merged 2) [message #548130 is a reply to message #548127]

Tue, 20 March 2012 08:24

cookiemonster
Messages: 13965
Registered: September 2008
Location: Rainy Manchester

Senior Member

Any given table can only have one tablespace.
So unless you want to insert each block of data into a different table this simply isn't possible.
Why are you trying to do this?

Report message to a moderator

Re: New User Help Me Out (merged 2) [message #548144 is a reply to message #548130]

Tue, 20 March 2012 08:58

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

Senior Member
Account Moderator

Or you can partition your table in a way that 1/3 of rows come into each partition.

Regards
Michel

Report message to a moderator

Re: New User Help Me Out (merged 2) [message #548199 is a reply to message #548144]

Tue, 20 March 2012 13:30

shehzaadkareem
Messages: 3
Registered: March 2012
Location: india

Junior Member

Cookiemonster:

Very well said that one can assign a table only to a tablespace once at a time.

But is that possible that i can exactly divide the data as per my memory requirements

and any query which automatically assign a table with other tablespace once the 2mb memory gets filled

Is there any automation query or script by which a table after assigning 2mb of data should be assigned to second tablespace and fill it with 5 mb

likely after completion of 5mb the table should automatically switch to tablespace 3.

Michel Cadot:

Thanks for the reply brother !

Can u help me with my above specified automation task ?

Report message to a moderator

Re: New User Help Me Out (merged 2) [message #548201 is a reply to message #548199]

Tue, 20 March 2012 13:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

the requirements make *NO* sense.
why are you obsessed with desiring data go into different tablespaces?
what problem are you really trying to solve?

Report message to a moderator

Re: New User Help Me Out (merged 2) [message #548202 is a reply to message #548199]

Tue, 20 March 2012 13:42

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

Senior Member
Account Moderator

in 11.2 you can choose system partitioning and choose the partition where you want to insert your data.
I don't see why you want to do that maybe if you explain what is your final goall we can tell you how to achieve this.

Regards
Michel

[Updated on: Tue, 20 March 2012 13:42]

Report message to a moderator

Re: New User Help Me Out (merged 2) [message #548209 is a reply to message #548202]

Tue, 20 March 2012 15:45

shehzaadkareem
Messages: 3
Registered: March 2012
Location: india

Junior Member

Thanks alot guys thou i dont have any speicifc goal but i just got a doubt whether it can happen or not

yes Michel using partitioning we can accompalish

Thanks you Once again guyx

Report message to a moderator

Previous Topic:	Materialized View, which should refresh every Tuesday and Friday at 5am. (merged 2)
Next Topic:	TABLESPACE EXTENT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 21 03:19:19 CST 2025