Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL script
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 Thu Oct 22 1998 - 10:43:15 CDT