Re: [Q] sql loader problem while load record more than one line???

2004-01-29 Thread Krishna Kakatur
, 2003 - Day after Thanksgiving December 24, 2003 - Christmas Eve December 25, 2003 - Christmas Day January 1, 2004 - New Year's Day January 19, 2004 - Martin Luther Ki Does there has way to pass around? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Krishna

Re: Problem with jobs

2004-01-27 Thread Krishna Kakatur
Im thinking on shutdown down database but I want It to be the last option. I hope you can help me Thanks Mauricio -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Krishna Kakatur INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: [Q] create tablespace with different block size error???

2004-01-23 Thread Krishna Kakatur
autoextend on 3 next 1280k 4 maxsize unlimited 5 extent management local 6 segment space management auto 7 uniform size 128k; Tablespace created. Does anyone know why?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Krishna Kakatur INET

Re: Anyone run into this strange ORA-00904 error ??

2003-12-02 Thread Krishna Kakatur
NUMBER(3) . . . SQL select * from ispownre3.individual_names; select * from ispownre3.individual_names * ERROR at line 1: ORA-00904: invalid column name -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Krishna

Re: SQL*Plus errors... how to hide?

2003-11-06 Thread Krishna Kakatur
') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Krishna

Re:

2003-01-16 Thread Krishna Kakatur
to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Krishna Kakatur INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Datafile with no extension using sqlldr

2002-12-28 Thread Krishna Kakatur
Hi, Oracle 8.1.7 on SUN Solaris 5.8 I want to load a datafile with no extension into Oracle using SQL*Loader. But it looks for a file with a .dat extension. This is the exact error message I got: SQL*Loader-500: Unable to open file (emp.dat)SQL*Loader-553: file not foundSQL*Loader-509:

OCM

2002-12-16 Thread Krishna Kakatur
Hi there! Wondering if it is worth becoming Oracle Certified Master, considering the investment for Oracle University courses and Fee for the Practicum. I estimate 2*$1500 for courses and $2000 for practicum totaling to $5000. Any opinions? Also, I have two questions: (1) There are

Can we capture all errors through SQLERRM ?

2001-06-13 Thread Krishna Kakatur
Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Krishna Kakatur INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: OCP Model Questions

2001-06-04 Thread Krishna Kakatur
On Sun, 03 Jun 2001 22:10:45 Krishna Kakatur wrote: Hi All, I have compiled some model questions for OCP DBA Test at http://www.oraref.com (mirrored at http://smart_and_handsome.tripod.com/oracle.html). If you have more, I will be happy to add them to the Web Page. -- Krishna

OCP Model Questions

2001-06-03 Thread Krishna Kakatur
_ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Krishna Kakatur INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California