In the United States, Oracle still comes with a default date format of 'dd-Mon-yy', why they do that is beyond me, but they don't do that in other countries like Canada. It is set to the ISO (International Organization on Standardization) format of 'YYYY-MM-DD'. Yeah for Oracle Canada...
You are right about the one controller and the contension. Splitting the files across serveral subdirectories under your D drive is not going to buy you anything. You are in a raid 5 configuration, so OFA and all that other neat suff is gone. You are not relying on the Raid 5 configuration to...
The owner of the stored procedure (in this case, the owner is SYSTEM) must have whatever access that is being used (in this case it is SELECT) against the oject within the stored procedure (in this case, it is the SCOTT.DEPT table) via direct access and not through a ROLE.
SYSTEM has by default...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.