Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: MFGlobalDBA
- Order by date
-
date format not accepted???
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...- MFGlobalDBA
- Post #6
- Forum: Oracle: All versions
-
Multiple Instances on One Server
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...- MFGlobalDBA
- Post #5
- Forum: Oracle: All versions
-
specifying owner of table in table reference of procedure
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...- MFGlobalDBA
- Post #4
- Forum: Oracle: All versions
