Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> craete table space uniform size?
Hi,
I am using the following query to create a tablespace, but it is giving
me an error, I thik it is becaue of the uniform size. Any help? The
error says "atleast 5 blocks ". So how do i increase the blocks?
CREATE TABLESPACE INDEX02
DATAFILE 'c:\oracle\product\10.2.0\oradata\INST1\INDEX02.dbf'
SIZE 2M
REUSE
AUTOEXTEND ON NEXT 500K MAXSIZE 5M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 4K PERMANENT ONLINE;
thanks. Received on Mon Oct 31 2005 - 09:59:49 CST
![]() |
![]() |