You should almost always index foreign keys. The only exception is when the matching unique or primary key is never updated or deleted. For more information take a look on Concurrency Control, Indexes, and Foreign Keys.
The sql file which will generate these indexes is created for you
| Table Name | Constraint name | Columns |
|---|---|---|
| TABLE1 | t1t2fk | COLUMN3 |
Invalid object does not mean a problem sometimes. Sometimes will fix itself as is is executed or accessed. But if there is an error in USER_ERRORS table, you are in trouble then...
The sql file which will compile these objects is created for you.
| Object name | Type | Error | At line |
|---|---|---|---|
| IOFT_VENCODING | TRIGGER | PL/SQL: ORA-00933: prikaz SQL neni radne ukoncen | 3 |
| IOFT_VENCODING | TRIGGER | PLS-00103: nalezen symbol "end-of-file" v situaci, kdy se predpokladala jedna z nasledujicich moznosti:
begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
| 4 |
| IOFT_VENCODING | TRIGGER | PL/SQL: SQL Statement ignored | 2 |