getting ORA-01555 ERROR with query Duration=0 sec
We are getting ORA-01555 Query Duration=0 sec.Any help will be appreciable.
select /*+ parallel(a 8) */ * from FCT_IN_DATA_CS5_stg partition(DATE_20140725170000) a
Sat Jul 26 17:39:30 2014
ORA-01555 caused by SQL statement below (SQL ID: 1mjp09hsuhrzt, Query Duration=0 sec, SCN: 0x0b3c.bda472ba):
/* SQL Analyze(1) */ select /*+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */to_char(count("SERVICECLASS_ID")),to_char(substrb(dump(min("SERVICECLASS_ID"),16,0,32),1,120)),to_char(substrb(dump(max("SERVICECLASS_ID"),16,0,32),1,120)),to_char(count("ACCOUNTGROUP_ID")),to_char(substrb(dump(min("ACCOUNTGROUP_ID"),16,0,32),1,120)),to_char(substrb(dump(max("ACCOUNTGROUP_ID"),16,0,32),1,120)),to_char(count("ACCOUNTVALUEBEFORE_AMOUNT")),to_char(substrb(dump(min("ACCOUNTVALUEBEFORE_AMOUNT"),16,0,32),1,120)),to_char(substrb(dump(max("ACCOUNTVALUEBEFORE_AMOUNT"),16,0,32),1,120)),to_char(count("ACCOUNTVALUEAFTER_AMOUNT")),to_char(substrb(dump(min("ACCOUNTVALUEAFTER_AMOUNT"),16,0,32),1,120)),to_char(substrb(dump(max("ACCOUNTVALUEAFTER_AMOUNT"),16,0,32),1,120)),to_char(count("FAMILYANDFRIENDS_ID")),to_char(substrb(dump(min("FAMILYANDFRIENDS_ID"),16,0,32),1,120)),to_char(substrb(dump(max("FAMILYANDFRIENDS_ID"),16,0,32),