Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: craete table space uniform size?
<mail2atulmehta_at_yahoo.com> a écrit dans le message de news: 1130774389.035731.126370_at_g14g2000cwa.googlegroups.com...
| 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.
|
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14219/toc.htm
Regards
Michel Cadot
Received on Mon Oct 31 2005 - 10:25:49 CST