Add new field to existing DSO which contains data

[Former Member]

Hi Folks,

we have the request to add a field to an existing write-optimized DSO. Normally there is no problem. Add field in dev system and transport it to productiv.

But the DSO contains 130 Mio. records. The questions is if we can simple transport this change or is there a better way to deal with this change?

Kind Regads,

Stephan

[Former Member · Accepted solution]

You don't want to drop the data in Production in order to move transport since this is the EDW layer of storing raw data and more over you are adding new field than deleting.

You can still transport with new field,but it may take several minutes for the transport to move successfully.Since the DSO has to adjust with new structure for that 130 million records.

[former_member184494 · Accepted solution]

Also when you transport - make sure that your Undo Tablespace has enough space so that Undo Table Space >= Active table of your ODS...

and with 130 Million records - the transport will take some time and not 3-4 minutes - I would say that you budget for about 15 minutes or so....

[Former Member]

Hi Stephan

You should be able to transport the DSO without any issues and without deleting the data as long as you are not changing the key fields. However the transport will take much longer than usual as it has to execute a Modify table for each of the 130 mn records present in the DB in order to add the new fields to the records.

Regards,

Ninad

[Former Member]

Hi Stephan ,

As long as the field which you are going to include is not a key field you can transport the request without deleting the data. Yes certainly the transport would take longer than regular transport.

Regards

Venky