Are Oracle courses required for Oracle Certification now?

Oracle would so blatantly make you take their over-priced courses. But maybe I'm just naive. Cheers, Kieran Murray CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray INET

RE: Primary Key Constraints

subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Password_grace_time and JDBC

their password. Unfortunately, the client DBAs are adamant that the profiles cannot be changed (which is fair enough), but does anyone have any idea how we could handle this situation on the Program/JDBC side? Thanks a lot, Kieran Murray Cardbase Technologies, Crofton Road, Dun Laoghaire, Co. Dublin

RE: Automation of Migration to Oracle9i

you think it would be possible for me to come up with scripts to automate this to run on all the client sites with minimal user intervention (assuming identical file systems)? It sounds too good to be true. Cheers, Kieran Murray CardBASE Technologies Limited® Crofton Road Dun Laoghaire Co

Automation of Migration to Oracle9i

and how have you got on? Do you think it would be possible for me to come up with scripts to automate this to run on all the client sites with minimal user intervention (assuming identical file systems)? It sounds too good to be true. Cheers, Kieran Murray CardBASE Technologies Limited® Crofton Road

Back to the Future - Migration from 7.2 to 9i!!!

Hi folks, just got asked about looking into migrating a production database from 7.2 to 9i, will I need to add a flux capacitor to the server to achieve this ;-) If not, can I migrate from 7.2 - 8i - 9i or are there additional steps involved. Kieran Murray CardBASE Technologies® BIM House

UTL_FILE limitation

(setting max_linesize to 32767) but to no avail. The strange thing is, if I run a wc -c on any of the lines created they average about 170 bytes, which doesn't even come close to the 1023 bytes limit. Would anyone know of a workaround? Cheers, Kieran Murray Norkom Technologies, 43 Upper Mount

Workaround for using NTILE function in Oracle8i

I need to run this on is Oracle 8i. Does anyone know of a workaround I could use to get this to work. Cheers, Kieran Murray Database Administrator, Norkom Technologies, Dublin 2, Ireland Tel:- +3531 2403221 declare cursor cr_main is select customer_id, work_tn_extno, ntile(4