setting retention on a lob/blob column
Am running 11.2.0.3. I do a desc on my table. The column type says "blob". In DocID 1507116.1 I see
query#1 alter table schema_name.table_name modify lob lob_column_name retention;
Q1 In query#1 do I replace lob with blob? Or just leave lob and assume it will operate against datatype blob.
Q2 When I desc my table, the column name has two character strings separated by a period. example "col1.sub". Do I simply enter "alter table schema_name.table_name modify lob col1.sub retention;" to have it reread/reset the undo_retention value?
0