Role /datafile created Time and Column sizes............

Role Created Time..........

SELECT name AS role, ctime AS created FROM sys.user$

Check The column Size:

select num_rows from dba_tables where table_name='TSS_ORDER_LINES_F';

select AVG_COL_LEN from dba_tab_columns where COLUMN_NAME='WAYBILL_NUMBERS' and table_name='TSS_ORDER_LINES_F';

DataFile Addition date :


col file_name format a65
col tablespace_name format a25
set lin 120
select df.file_id, df.file_name, vdf.creation_time, (df.BYTES/1024)/1024 FILE_SIZE_MB
from dba_data_files df, v$datafile vdf
where df.tablespace_name like 'APPS_TS_SUMMARY'
and df.file_id=vdf.file#
ORDER BY df.tablespace_name, VDF.CREATION_TIME;