1

Topic: DDL ALTER TABLE.

Good afternoon colleagues,
There is Paketnik PKG_1 in it there is Function FUNC_1 which 1000 times a minute, and in it select. certain table TABLE_1 are caused almost.
All select is written thus

select column_name from TABLE_1

instead of as

select * from TABLE_1

Question such: If I add a new column on this table that it does not affect handlings of the request of Function?
That is at ALTER -  tables it is not broken function operations?
For everyone answer I will be grateful.

2

Re: DDL ALTER TABLE.

proxy_911;
possibilities were not?
Will be  functions with compilation at the first reversal.

3

Re: DDL ALTER TABLE.

proxy_911 wrote:

the Question such: If I add a new column on this table that it does not affect handlings of the request of Function?
That is at ALTER -  tables it is not broken function operations?

The new column will be empty or by something is filled?
If it is necessary to fill a column,   , and the table big, on it to be necessary some time, a your function will hang at this time.
Since oracle 10, there was a useful
The DBMS_REDEFINITION package provides an interface to perform an online redefinition of tables.
https://docs.oracle.com/database/121/AR … m#ARPLS042

4

Re: DDL ALTER TABLE.

Aliona wrote:

if it is necessary to fill a column,   , and the table big, on it to be necessary some time, a your function will hang at this time

??

5

Re: DDL ALTER TABLE.

[quote = - Eugene-] it is passed...
??

arise,  smile