Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to create a table in a specific tablespace

Former Member

‎11-21-2007 9:37 AM

0 Kudos

Hi,

Dear All,

Is it possible to create a table in a particular 'TableSpace'.

I sense someone can give an idea.

with regards

Mahesh

3 REPLIES 3

matt
Active Contributor

‎11-21-2007 9:54 AM

0 Kudos

Yes it is. It's set from SE11, Technical Settings, field "Data Class".

matt

Message was edited by:

Matthew Billingham

Former Member

‎11-21-2007 10:31 AM

0 Kudos

Thanks Matthew.

By chance can we write like the following, i tried by using Native SQL, but its not getting.

CREATE TABLE "SAPONE"."ZVBAK" TABLESPACE "TEMP" AS SELECT * FROM "SAPONE"."VBAK" TABLESPACE "PSAPONE"

with regards

Mahesh

matt
Active Contributor
In response to Former Member

‎11-21-2007 2:42 PM

0 Kudos

If you set the data class in SE11, then when you activate the table, it will automatically be putinto the correct tablespace.

I am not a DBA so I can't help you with your SQL, I'm afraid.

matt