Oracle Enterprise : Fatal Error: Invalid open command
Posted: Tue Apr 12, 2011 6:30 pm
Hi,
I have requirement to truncate data and drop index before loading data into one of the oracle table.
I used Oracle Enterprise stage and given to statements in open command (first i tried both statements seperated by semicolon, and also without semicolon) but fot the error
Oracle_Enterprise_24,1: Fatal Error: Invalid open command: call truncate_tabs('MCFDS_AGENT_XREF_HIST')
call PRC_DROP_INDEX ('CFDSYSDB','IX1_MCFDS_AGENT_XREF_HIST').
Can any one suggest how to use multipule statement in open command option in Oracle Enterprise Stage.
Regards
Suresh Angadi
I have requirement to truncate data and drop index before loading data into one of the oracle table.
I used Oracle Enterprise stage and given to statements in open command (first i tried both statements seperated by semicolon, and also without semicolon) but fot the error
Oracle_Enterprise_24,1: Fatal Error: Invalid open command: call truncate_tabs('MCFDS_AGENT_XREF_HIST')
call PRC_DROP_INDEX ('CFDSYSDB','IX1_MCFDS_AGENT_XREF_HIST').
Can any one suggest how to use multipule statement in open command option in Oracle Enterprise Stage.
Regards
Suresh Angadi