Page 1 of 1
Using Before & After Sql in ORacle Stage
Posted: Wed Dec 01, 2004 2:06 pm
by ashcar
I have a Server job ..where i drop Indexes and build Index in after and before Sql in Oracle stage...but since going to Parallel Extender...i cannot find a similar screen in Oracle Enterprise stage....
how do i put in the before and after SQL for dropping indexes ???
Posted: Wed Dec 01, 2004 3:45 pm
by T42
Several ways.
1. You can use the Open Command/Close Command. Click on "Options" within the Oracle stage and you'll see those options available.
2. Do a Before Job & After Job routines using sqlplus calls.
3. Use ExecuteCommand in the job sequencer to make sqlplus calls. (This is RECOMMENDED since if the job fails, the above 2 options still get executed, especially the before job/open command. Within job sequencer, you can control whether indexes can be preserved/dropped/et cetera.)
Posted: Thu Dec 02, 2004 4:11 am
by l_homme_de_rio
Hi,
If you use "Load" as a "write method" you have in the "options"/"Index mode" several options to rebuild, maintain etc ... indexes
All the best