Why tables are created with the available table spaces, than the one I specified

mathewhai · #1 (**permalink**) 11-03-11, 06:24

Hi,
I created a database, connected to that and specified the table space to be 32k

Code:

CONNECT TO myDB;

CREATE BUFFERPOOL my_32k SIZE 250 PAGESIZE 32 K;

CREATE TABLESPACE my_32k  PAGESIZE 32 K MANAGED BY SYSTEM USING ('my_32k') BUFFERPOOL my_32k  ;

CREATE TEMPORARY TABLESPACE my_temp_32k PAGESIZE 32 K MANAGED BY SYSTEM USING ('my_temp_32k ') BUFFERPOOL my_32k;

CONNECT RESET;

If I have a table column with varchar more than 3000, the table is created with my_32k page size. However a table with all columns less than varchar 1000 , the page size corresponds to USERSPACE1.

How I can make all the tables to use the default table space of 32k i.e. my_32k

Thanks in advance.

przytula_guy · #2 (**permalink**) 11-03-11, 07:09

whenever creating a table : ALWAYS specify the tablespace(s) to use for this
in that case you are not depending on any defaults....
you could use : grant use on tablespace ...
in that case the users are only allowed to use that tablespace
see :GRANT (Table Space Privileges)

Internet Services

Web Development

Digital Marketing

Consumer Tech