This is disscuss about nothing.
Question about using pro*c (pro*ada, pro*fortran ...) or pl/sql doesn't exists.
We usually have only one basic question:
What kind of system architecture we are going to build:
- with havy client's component
- whth thin client
- mixed model (with balance between client and server(s))
- with deditated application servers.
- platform depended
- platform independed
when we decided for ourself this problem (or problems) we may make choises of
languges, tools ... what ever.
only 1 sql query can make a degradation of perfomance whole application in pl/sql.
only 1 loop in pro*c or struture of objects or memory allocation/deallocation procedure in c, can kill whole programm.
This sounds like Shakespeare 'much do about nothing';
You are right, if you start a new project you look in a global scope.
But in a running project if a module/program works to slow
you have to ask yourself if you have choosen the right tool/Language for the Solution.
Sometimes you have to deal with the detail-area very much.
It's correct. But...
In this case u should ask another question. Like:
"how i can use pl/sql (or bla, bla...) if i have ... problems with perfomance.
or i have to use another ways for solve this problem ?"
Rule --> if u going to get right anwer u have to ask right question.
NOTE: ur question about ALTER TABLE MOVE - right question.