Re: SQL script

S_at_lut,

I m not sure to understand your problem: Do you want to grow your table with data ?
if you can use system dictionnary tables (dba_tables and dba_tablespaces)

SQL>desc dba_tables

 Name                            Null?    Type
 ------------------------------- -------- ----
 OWNER                           NOT NULL VARCHAR2(30)
 TABLE_NAME                      NOT NULL VARCHAR2(30)
 TABLESPACE_NAME                 NOT NULL VARCHAR2(30)
 CLUSTER_NAME                             VARCHAR2(30)
 PCT_FREE                                 NUMBER
 PCT_USED                        NOT NULL NUMBER
 INI_TRANS                       NOT NULL NUMBER
 MAX_TRANS                       NOT NULL NUMBER
 INITIAL_EXTENT                           NUMBER
 NEXT_EXTENT                              NUMBER
 MIN_EXTENTS                              NUMBER
 MAX_EXTENTS                              NUMBER
 PCT_INCREASE                             NUMBER
 FREELISTS                                NUMBER
 FREELIST_GROUPS                          NUMBER
 BACKED_UP                                VARCHAR2(1)
 NUM_ROWS                                 NUMBER
 BLOCKS                                   NUMBER
 EMPTY_BLOCKS                             NUMBER
 AVG_SPACE                                NUMBER
 CHAIN_CNT                                NUMBER
 AVG_ROW_LEN                              NUMBER
 DEGREE                                   VARCHAR2(10)
 INSTANCES                                VARCHAR2(10)
 CACHE                                    VARCHAR2(5)
 TABLE_LOCK                               VARCHAR2(8)


SQL>desc dba_tablespaces
 Name                            Null?    Type
 ------------------------------- -------- ----
 TABLESPACE_NAME                 NOT NULL VARCHAR2(30)
 INITIAL_EXTENT                           NUMBER
 NEXT_EXTENT                              NUMBER
 MIN_EXTENTS                     NOT NULL NUMBER
 MAX_EXTENTS                     NOT NULL NUMBER
 PCT_INCREASE                    NOT NULL NUMBER
 STATUS                                   VARCHAR2(9)
 CONTENTS                                 VARCHAR2(9)

Alexandre Mavel
amavel_at_partenr.auchan.com

Serge Montet wrote in message <70nj5e$h7g_at_work.wanadoo.com>...
>Hello,
>
>I've made a temporary table which contains these columns :
>TABLE_NAME,NUMBER_OF_ROWS,TABLESPACE,DATAFILE
>
>But I don't know the best way to get the values for TABLESPACE and
DATAFILE.
>Maybe I could use a cursor or PL/SQL commands ?
>
>Someone has an idea ?
>
>Thanks.
>
>
Received on Fri Oct 23 1998 - 04:23:17 CDT