Good morning
I’ve a small question for You. Maybe you could help please?
I have one task in which I have to change database (Oracle 11) It goes like this:

The primary key partner_id in PARTNERS table should be changed from number(15) to number(19).

There are many dependent tables, view and plsql routines, which refer to the primary key in PARTNERS. All these occurrences have to be changed using number(19).


Maybe you know some trick how to do it automatically not manually? executing few statements, rather than change every structure separately?

Could You please write an answer if it’s possible?

cheers,

Jan