|
|
|
|
Re: Can we use constraints and Index in external table in oracle 10g [message #601302 is a reply to message #601264] |
Tue, 19 November 2013 07:14 |
|
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
suja_k13 wrote on Mon, 18 November 2013 23:38Hi,
Am new to external tables and my lead told me to try constraints and views in external table. when i serached i found that it couldnot be possible.
so just want to confirm from experts in this forum.
thanks for yours help.
thanks,
sujatha
Sounds like either
(1) your "lead" is in serious need of further education, or
(2) your "lead" was deliberately sending you on a snipe hunt.
Think about the mechanism of external tables. They are os files outside of the database. The "external table" is really just a sqlldr description of that file. The file itself can (and usually is) swapped out for a different file (different contents) on a regular basis. Oracle really does not know what is in the file. It simply reads it and delivers the results when queried.
Now, how would oracle maintain an index or enforce a constraint on such a file?
It is important that you understand why thing are as they are.
|
|
|