Home » SQL & PL/SQL » SQL & PL/SQL » Question about tablespace (Oracle 10G on HP-Unix)
Question about tablespace [message #376790] Thu, 18 December 2008 09:53 Go to next message
developer69
Messages: 6
Registered: September 2008
Junior Member
I am creating a table with the following definition:

CREATE TABLE USER_DATA
     (id NUMBER,
      name VARCHAR2 (60))
   TABLESPACE TS_1
   PARTITION BY HASH (id)
   PARTITIONS 4 
   STORE IN (TS_DATA01,TS_DATA01,TS_DATA01,TS_DATA01);

so, In this case all the data is stored in the partition TS_DATA01, am wondering what will be stored in tablespace TS_1 Is it just the table definition?

Thanks in advance,
Sam
Re: Question about tablespace [message #376792 is a reply to message #376790] Thu, 18 December 2008 09:57 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Check this link.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_7002.htm#i2128666

Regards

Raj
Re: Question about tablespace [message #376799 is a reply to message #376790] Thu, 18 December 2008 10:14 Go to previous message
developer69
Messages: 6
Registered: September 2008
Junior Member
Found the answer I was looking for "Tablespace storage specified at the table level is overridden by tablespace storage specified at the partition level"

Thanks Raj for the quick reply and the link.

Sam
Previous Topic: Problem with SQL Space and Quotes
Next Topic: PLSQL to SQL
Goto Forum:
  


Current Time: Tue Dec 06 16:05:18 CST 2016

Total time taken to generate the page: 0.04834 seconds