OraFAQ Forum: Server Administration » How Can Create Table With diffrent TableSpaces in oracle 10g

Home » RDBMS Server » Server Administration » How Can Create Table With diffrent TableSpaces in oracle 10g

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

How Can Create Table With diffrent TableSpaces in oracle 10g [message #256700]

Mon, 06 August 2007 07:00

jainarayan5484
Messages: 38
Registered: August 2006
Location: DELHI

Member

Sir
Can Create Table With diffrent TableSpaces in oracle 10g

Jai

Report message to a moderator

Re: How Can Create Table With diffrent TableSpaces in oracle 10g [message #256705 is a reply to message #256700]

Mon, 06 August 2007 07:05

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

You can't

Report message to a moderator

Re: How Can Create Table With diffrent TableSpaces in oracle 10g [message #256708 is a reply to message #256700]

Mon, 06 August 2007 07:11

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

Senior Member
Account Moderator

Unless you partition the table.

Regards
Michel

Report message to a moderator

Re: How Can Create Table With diffrent TableSpaces in oracle 10g [message #256721 is a reply to message #256708]

Mon, 06 August 2007 07:59

Noemi
Messages: 12
Registered: August 2007
Location: Hungary, Budapest

Junior Member

http://www.psoug.org/reference/iot.html

Report message to a moderator

Re: How Can Create Table With diffrent TableSpaces in oracle 10g [message #257660 is a reply to message #256700]

Wed, 08 August 2007 23:29

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

As Michel said by partitioning you can achieve this.But I recommend you don't do that.

Report message to a moderator

Re: How Can Create Table With diffrent TableSpaces in oracle 10g [message #257680 is a reply to message #257660]

Thu, 09 August 2007 00:23

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

Senior Member
Account Moderator

Why?

Regards
Michel

Report message to a moderator

Re: How Can Create Table With diffrent TableSpaces in oracle 10g [message #257944 is a reply to message #257680]

Thu, 09 August 2007 11:54

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

I guess table Is small. Wink

is It ARJU?

Report message to a moderator

Previous Topic:	block size
Next Topic:	Transaction table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 20:45:16 CDT 2024