Crisis averted ... got the data back from our replication site which just happened to be up for BCP testing ... the fates are smiling on us today :) However ... I'd still like to figure out what happened with the flashback procedure. I've used this successfully in the past so I'm puzzled. The error is: matl_doc_month.LOAD_DATE); * ERROR at line 62: ORA-06550: line 62, column 19: PL/SQL: ORA-00984: column not allowed here ORA-06550: line 37, column 1: PL/SQL: SQL Statement ignored Sorry for the incomplete post earlier ... I was watching the clock run down on my retention window and stressing :) Robyn On 4/12/07, Robyn <robyn.sands@xxxxxxxxx> wrote:
Hello everyone, I'm trying to use flashback query to recover some data, and the procedure I've used in the past is failing. Does anyone else see the error in this code? The column match the table and I've used this in the past. declare cursor flash_recover is select * from matl_doc_month; matl_doc_month_rec matl_doc_month%rowtype; begin dbms_flashback.enable_at_time(sysdate - 60/1440); open flash_recover; dbms_flashback.disable; loop fetch flash_recover into matl_doc_month_rec; exit when flash_recover%notfound; insert into matl_doc_month values (matl_doc_month.ACCT_DOC_FYP, matl_doc_month.MATL_NUM, matl_doc_month.PLANT, matl_doc_month.MOVMNT_TYPE, matl_doc_month.STOR_LOC, matl_doc_month.RCVING_STOR_LOC, matl_doc_month.DEBIT_CREDIT_IND, matl_doc_month.PROFIT_CTR, matl_doc_month.GL_ACCT_NUM, matl_doc_month.BASE_UOM, matl_doc_month.BASE_QTY, matl_doc_month.TRANS_CNT, matl_doc_month.ACCT_DOC_FY, matl_doc_month.ACCT_DOC_FQ, matl_doc_month.ACCT_DOC_FP, matl_doc_month.ACCT_DOC_CY, matl_doc_month.ACCT_DOC_CQ, matl_doc_month.ACCT_DOC_CP , matl_doc_month.ACCT_DOC_CYP, matl_doc_month.SL_INV_GRP, matl_doc_month.COST_CTR, matl_doc_month.LOCAL_CURRENCY_AMT, matl_doc_month.REASON_FOR_MOVMNT_IND, matl_doc_month.LOAD_DATE); end loop; close flash_recover; commit; end; /
-- //www.freelists.org/webpage/oracle-l