DBA Data[Home] [Help]

APPS.GMA_PURGE_DDL dependencies on USER_TAB_COLUMNS

Line 617: from user_tab_columns

613: l_kdbt NUMBER;
614:
615: CURSOR l_table_cols_size_cur(c_tablename user_tables.table_name%TYPE) IS
616: select sum(data_length + decode(floor(data_length/250),0,1,3))
617: from user_tab_columns
618: where table_name = c_tablename;
619: l_table_cols_size NUMBER;
620:
621: l_db_free_space NUMBER; -- holds free space in DB block after header