Home » SQL & PL/SQL » SQL & PL/SQL » Reg tablespaces (Oracle,10g,Linux)
icon10.gif  Reg tablespaces [message #318167] Tue, 06 May 2008 00:07 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,
I need to create tablespace for single column for table.

My scripts:
create table test
(id number(23),
name varchar2(33))
tablespace onlinetbs;

but i need to create tablespace for id columns only.

How can resolve this issues?

Thanks,
Michael
Re: Reg tablespaces [message #318169 is a reply to message #318167] Tue, 06 May 2008 00:18 Go to previous messageGo to next message
paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan
Member
why you are that concern for creating tablspace for single column...i think it has no concern with tablespaces
i created it......
SQL> create tablespace xyz datafile 'd:\xyz.dbf' size 1m;

Tablespace created.

SQL> create table xyz(i number) tablespace xyz;

Table created.
Re: Reg tablespaces [message #318177 is a reply to message #318169] Tue, 06 May 2008 00:45 Go to previous messageGo to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,
the id columns has 25000000 records.the id columns is used in many scenario.What i feel means, for better performance we have created the tablespace for id columns only.


Thanks,
Michael
Re: Reg tablespaces [message #318179 is a reply to message #318167] Tue, 06 May 2008 00:56 Go to previous message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ A non-partitioned table belongs to 1 tablespace only. In any case (but special ones, LOB, iot overflow...) all column are in the same tablespace

2/ What make you think you will have better performances with a column in another tablespace?
Do you have special disks for this column?
Don't you access the other columns at the same time?

Regards
Michel

Previous Topic: send sms
Next Topic: A function to replace CAPS
Goto Forum:
  


Current Time: Wed Dec 07 03:10:21 CST 2016

Total time taken to generate the page: 0.25489 seconds