onpladm disable index on multiple load
Posted in 2012
Topics: General Discussion
Hi All,
I am performing multiple load into a table using onpladm. I am able to execute
the command "onpladm run job jobname -fl". It starts with disabling the
constraints and loading works fast. However, at the end of the record being
loaded, it is taking much time because it performs re-enabling the indexes.
What i want to do is to load multiple UNL files into a specific table and
re-create the index after the last file is loaded. would it be possible or is
there any parameter that will set the Indexes not the be enabled at the end of
the loading?
Thank you and have a good day!
i found how to disable the constraints and indexes during loading.. SET CONSTRAINTS FOR tablename DISABLED; SET INDEXES FOR tablename DISABLED; i will enable once all data is loaded. thanks.