Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: pctfree,pctused
On 19 Jul 2006 12:12:24 -0700, agnieszka.sztela_at_gmail.com wrote:
>I make:
>
>CREATE TABLE S1
>(
>CLS_L_ID INTEGER,
>ALBUM_STREAM VARCHAR2(9 BYTE),
>TEACHER_ID INTEGER
>)
>TABLESPACE sss
>PCTUSED 30
>PCTFREE 50;
>
>but in the created table there is: pctused 0,pctfree 50
>Why??
No version, no information about the organisation of the tablespace (could have segment management auto), so no reply.
-- Sybrand Bakker, Senior Oracle DBAReceived on Wed Jul 19 2006 - 16:20:29 CDT