Toad World® Forums

Table attributes PCT_FREE and PCT_USED shifted

Hi

Toad 14.1 and 15 also.

SQL> create table raulkaubi.proov2(id number) tablespace users pctfree 0;
Table created.

SQL> col owner for a15;
col table_name for a15;
select owner, table_name, pct_free, pct_used from dba_tables where table_name in ('PROOV2');

OWNER           TABLE_NAME        PCT_FREE   PCT_USED
--------------- --------------- ---------- ----------
RAULKAUBI       PROOV2                   0

SQL> set pagesize 0
set lines 200
set long 90000
set feedback off
set echo off
select dbms_metadata.get_ddl('TABLE','PROOV2','RAULKAUBI') from dual;

  CREATE TABLE "RAULKAUBI"."PROOV2"
   (    "ID" NUMBER
   ) SEGMENT CREATION DEFERRED
  PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  TABLESPACE "USERS"


So PCT_USED is DEFAULT (40% seems like DEFAULT value for oracle)!
And PCT_FREE is specified 0.

Here is what TOAD shows me.

image

When I alter table, seems like something is just the opposite.
image

This is quite interesting. Toad indeed shows correct information for some tables. But whenever I create a new table, this is what happens at the moment.

Regards
Raul

Whenever I create first row, this information is corrected, at least for PCT_FREE.
PCT_USED is still wrong, it is not 0 actually (dbms_metadata.get_ddl shows me 40, which is default value).
Also PCTUSED parameter is somewhat irrelevant these days. Is it possible to turn off displaying this parameter at all (at least when using ASSM - which should be the one to use these days)..?

SQL> insert into raulkaubi.proov2(id) values(1);
SQL> commit;

image

image

Raul

Thanks Raul.

I'm not working today but I've made a note of this to look when I get back.

-John

Hi

Is there an update regarding the issue..?

Regards
Raul Kaubi

Hi Raul,

It was fixed in the most recent beta. Sorry that I did not update this thread. 15.1 is planned for release near the end of January.

-John