Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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