Win a copy of Svelte and Sapper in Action this week in the JavaScript forum!

John Dinglasan

Greenhorn
+ Follow
since Oct 19, 2004
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by John Dinglasan

Hi Nick! Thanks for the quick response.

Well, I'm thinking to get 1Z0-007 and not 1Z0-042 because we are using Oracle 9i in our office and I'm planning to review during break and idle times, and maybe 1-2 hours after work in the office.

Thanks.
Hi!

I'm planning to get certified for OCA.
I just checked out the exam outline from Oracle's site and I think 1Z0-001 has more contents than 1Z0-007.
One of my objective for taking this certification is learn more about Oracle.

So which exam do you think I should take?

I also read that Oracle will be retiring Oracle 8i certification by the end of the year but Im planning to get it by Jan 05. Will this affect the validity of 1Z0-001? Will 1Z0-001 still be a substitue for 1Z0-007 come 8i's retirement.

Thanks a lot guys!
15 years ago
Hi!

I'm planning to get certified for OCA.
I just checked out the exam outline from Oracle's site and I think 1Z0-001 has more contents than 1Z0-007.

One of my objective for taking this certification is learn more about Oracle.

So which exam do you think I should take?

I also read that Oracle will be retiring Oracle 8i certification by the end of the year but Im planning to get it by Jan 05. Will this affect the validity of 1Z0-001? Will 1Z0-001 still be a substitue for 1Z0-007 come 8i's retirement.

Thanks a lot guys!
In addition, I've tried createing a batch file which calls the sql loader.

This batch file is executed by Runtime.exec(). After exection, records loaded was down to 192.

Summary:
Total records : 1030
Manual call to sql loader : 1030
Runtime.exec calls sql loader : 512
Runtime.exec calls batch file : 192

I'm also using the same user account for all execution.

And I'm running under Windows 2003 Server, Oracle 9i and Java 1.4.1

Thank you very much! =)
15 years ago
Hi guys!

I'm having a problem with running sql loader using Runtime.exec.
Actually, the records are loaded but only up to 512 records.

There is no Exception and inside the log file geenrated by SQL loader it says that all records were successfully loaded.

I tried loading the same file manually using SQL Loader and there was no problem.

I'm using "Oracle 9i" and "Java 1.4.1".

Here is the String inside Runtime.exec:
sqlldr tmt_final/tmt_final@shogun control=C:\eclipse\workspace\TMT_Final\Archive_Files\20040825_raw.csv.gz.ctllog=
C:\eclipse\workspace\TMT_Final\Archive_Files\20040825_raw.csv.gz.log skip=2

And my control file
LOAD DATA
INFILE 'C:\eclipse\workspace\TMT_Final\Archive_Files\Historical_Raw_Data\20040825_raw.csv'
BADFILE 'C:\eclipse\workspace\TMT_Final\Archive_Files\20040825_raw.csv.gz.bad'
REPLACE
INTO TABLE ARCHIVE_HIST_RAW_VALUE
FIELDS TERMINATED BY ","
(
fk_measurement,
fk_hist_kind,
year,
month,
day,
hour,
minute,
raw_value,
raw_quality,
update_date "TO_TIMESTAMP(:update_date,'YYYY/MM/DD HH24:MI:SS')",
update_user,
date_time "TO_DATE( ate_time,'YYYY/MM/DD HH24:MI')"
)


Any input is appreciated.

Thank you very much.

EJ

[ Jess added a carriage return so the text wouldn't stretch the screen ]
[ October 19, 2004: Message edited by: Jessica Sant ]
15 years ago