Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: pctfree,pctused

Re: pctfree,pctused

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 19 Jul 2006 23:20:29 +0200
Message-ID: <rf8tb2523vcfveto39fu90p2nhhf9jpt73@4ax.com>


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 DBA
Received on Wed Jul 19 2006 - 16:20:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US