I have a requirement where I have to load like below,
Table A->intermediate table 1->intermediate table 2->table B
running above statements between BTET.have to collect stats after table1 loaded as well as table2 loaded.how we can achieve this.
If you can provide more details, then it will be easy, reasons, what is there in intermediate etc.. etc... You can refer to the link
and I think it will answer most fo the questions. Also some of Carrie's blog like
COLLECT STATS is considered a DDL statement -> it can only be the final statement within a transaction.
So you can't collect stats after TableA was loaded.
Are you sure you need to run the load as a single transaction?