ODS activation due to new field taking long time

[Former Member]

Hi,

I have created transport request to transport

DATA MART

ODS (Because i have added two new fields to this ODS which i have to populate by data mart)

Update rule for Data Mart and ODS

Activate dependent object for this ODS

From my Testing server to Production Server

Now after transporting it to my Production server it has some 8 million records on Production server and request is still activating ODS DATA (Readjusting table structure for this new fields and data records).I have down time scheduled in couple of hours

Now my question is

What happens if request is not activated in Production server before down time?

Will i loose entire data on production server?

if yes What can i do to prevent this?

Please inform as it is urgent.

Regards,

Rahul.

[Former Member]

You had a bad idea, if on Oracle watch your tablespaces they might fill up and db crashes.

It's basically building an hidded copy of the ODS

[Former Member]

hi pabloj,

Can you please inform me what can be solution in case it happens?

Can reinit in that case solve the problem or do you have some other idea?

Please inform

Regards,

Rahul.

[Former Member]

Check with your DBA.

Reinit should be able to solve the problem.

Hope this helps