Re: show table parameters

The following is quite handy for finding out some information on objects

select dbms_metadata.get_ddl('OBJECT_TYPE','NAME','SCHEMA') from dual;

select dbms_metadata.get_ddl('TABLE','AUD$','SYS') from dual;

This turns off some storage parameters.

EXECUTE
DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'STORAGE',false);

select dbms_metadata.get_ddl('TABLE','AUD$','SYS') from dual;

"vertigo" <ax178_at_wp.pl> wrote in message news:co5bon$cjo$1_at_atlantis.news.tpi.pl...
> Hello
> How can i check table parameters (it's actual size, and storage parameters
> such as PCTINCREASE ...) ?
>
> I tried to find my table:
> select * from dba_tables where table_name='test' but did not find, why ?
>
> Thanx
> Michal
>
Received on Thu Nov 25 2004 - 19:39:50 CST