Did you set it just to French, or did you specify a particular character set?
From the symptoms you're describing, it sounds like your data file has
problems. The French characters may be encoded using a different character
set than the Japanese characters. If you want to load the file, you'll
Justin,Thanks for your reply.
When the French characters are loaded properl I did set NLS_LANG=French
-Original Message-
Justin Cave
Sent: Friday, January 02, 2004 7:14 PM
To: Multiple recipients of list ORACLE-L
When the French characters are loaded properly, are you setting NLS_LANG to
When the French characters are loaded properly, are you setting NLS_LANG to
FRANCE_FRENCH.UTF8, or are you using a different character set?
Justin Cave
At 01:39 PM 1/2/2004, [EMAIL PROTECTED] wrote:
Dear All,
Happy New Year!
I have to load both French and Japanese characters from the same data
How about just committing every n rows, instead of trying to fit the
whole thing into one transaction? This is why they have the ROWS=
option on the command line and in the parameter file.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Sat, 15 Nov 2003, Stephane Faroult wrote:
> [EMAIL
[EMAIL PROTECTED] wrote:
>
> Dear Gurus,
>
> I have a problem loading data from flat file using SQL*Loader. The problem is unable
> to extend rollbacksegment. Is there a way to assign BIG rollback segment to
> SQL*Loader transaction? If not what is the work around to load huge volume of data
>
1) Write a perl script which will rewrite the control file on the fly.
2) Write a script which will generate a symbolic link for the file du jour.
3) Do PURGE *.txt/KEEP=1 (I couldn't resist, it was the best OS ever).
--
Mladen Gogala
Oracle DBA
> -Original Message-
> From: [EMAIL PR
PROTECTED]Subject: Re: sql loader log file
problem
Hi!
You probably have 8842 separate rows in your input text
file.
But your sqlloader knows how to extract several
database records from one physical text file row, depending on your
controlfile.
Thus, in some cases it makes
Title: Message
Hi!
You probably have 8842 separate rows in your input text
file.
But your sqlloader knows how to extract several database
records from one physical text file row, depending on your
controlfile.
Thus, in some cases it makes multiple records out of single
row and here comes t
Stephen,
I was using CHAR for the LONG column the error is actually on the
field in the file FOLLOWING the LONG column... I was getting a message
that the data was too large. So I did the following and it seems to be
working, although I can't get it to work via direct path this way:
I changed
Rachel,
I do not claim to be a guru, but I do happen to have Jonathan's book
here.
The first thing is what field type are you using for this memo field?
The book says you should use CHAR for VARCHAR2, CHAR, LONG and other
related.
What error are you getting?
Can you post the lines from the ctl
Another nifty trick is to use external tables. Believe it or not, you can
even
specify /*+ parallel */ in those babies.
--
Mladen Gogala
Oracle DBA
-Original Message-
Stephane Faroult
Sent: Thursday, August 14, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L
another table
If y
If you load your data into a table with an enable foreign key, it will be checked on
the fly by SQL*Loader with the conventional path. In direct mode it disables
constraints, and I am unsure whether it checks them when reenabling them (something
which you can optionally get); any way it would le
ltiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: SQL Loader problem
Date: Tue, 29 Jul 2003 15:09:29 -0800
Sliced bread or not, the syntax problem will be the same since external
tables are modeled on SQL*Loader syntax... :-)
Anna, I suspect that there is confusion on the SQL*Loader
Sliced bread or not, the syntax problem will be the same since external
tables are modeled on SQL*Loader syntax... :-)
Anna, I suspect that there is confusion on the SQL*Loader concepts of
"external datatypes" and "internal datatypes", which incidentally is shared
by external tables currently. S
Try with external tables. The best thing since sliced bread.
On 2003.07.29 17:39, Anna Li wrote:
Hi All,
I'm trying to use SQL Loader to load data from a text file into a table.
However, I always get error as column SKILL_DESCRIPTION field in data file
exceeds maximum length where the column SK
Ok. I must be legally blind :) Can this happen to anyone or just me?
I will try this again with my bifocals on.
Thank you for pointing it out kindly!!
Saira
-Original Message-
Sent: July 8, 2003 8:46 AM
To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Saira
It looks like your index is
Saira
It looks like your index is being created on the LOC column, right?
CREATE UNIQUE INDEX LCI_LOC ON
LC_F(LOC)
So your change to the lc_rid column did not fix this problem.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, July 08, 2003 9:29 AM
To:
After reading some archives on google, I came up with this solution:
Drop the index.
Use sqlldr to append to the table - for the id column, use:
(lc_rid sequence (max,1) ...)
Recreate the index.
However, when I did this, I received an error message saying that I
can't have duplicates in the index
Thursday, July 3, 2003, 5:40:37 AM, you wrote:
bnini> SQL*Loader reads a set of records from a file, generates INSERT
bnini> commands,
This is the key right here. A conventional path load
generates INSERT statements. A direct path load does not. A
direct-path load passes preformatted blocks to the
Since direct path loads do an append, I would say the answer shown is
incorrect.
<[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/03/2003 02:40 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:sq
No. We are still with 8i.
--- [EMAIL PROTECTED] wrote:
> Are you on 9i?
>
> If so, setup the sql_load.txt file as an external
> table, and you
> can then use SQL and/ora PL/SQL to load your table
> the
> way you would like.
>
> Don't think you can do what you're asking directly
> from sqlldr.
>
Are you on 9i?
If so, setup the sql_load.txt file as an external table, and you
can then use SQL and/ora PL/SQL to load your table the
way you would like.
Don't think you can do what you're asking directly from sqlldr.
Jared
Bob Robert <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/26/
Bob
If you were on Unix, I would suggest you have a script that split your
input file into multiple files using one of the Unix utilities, then
executed SQL*Loader against each of those. Since you are on Windows, perhaps
someone has a suggestion that will apply there. I know there are Windows
ve
> Sent by: Subject: Re: SQL Loader
>
>
Title: RE: SQL Loader
If SQL loader loads a table it takes the first record in the file and stuffs it in the top of the table... like a stack... last in, first out so if you were to read the table like you read the sequential file, it is in there with the "bottom" record in t
by: Subject: Re: SQL Loader
[EMAIL PROTEC
I think the query is displaying data from the table in the order in which rows were inserted by SQL*Loader.
Whereas, the query to read the same data from the external table is reading the file from the first physical record. So it appears reversed..
- Kirti Stephen Andert <[EMAIL PROTECTED]> wr
Pradeep,
I don't know what you mean when you say SQL*Loader is "starting from
the 50,000th record and going up". If there are 50k records, are you
saying it is not loading them? Or is it reading them from 50,000 then
49,999 (i.e. in revers order)? How are you determining what order they
are be
Hi Jonathan
Thanks for answering my question. I diddnt realise you could
querry colums ahead of the current line.
Ive applied functions (in a ctl file) to the current column, but diddnt
realise I could || the next column
My working ctl file
Thanks again
bob
LOAD DATA
INFILE 'F:\11NETS
Hello Bob,
My first thought is to try something like:
...
log_date CHAR
"TO_DATE(:log_date || ' ' || :log_time,'ddMon hh:mi:ss'",
log_time FILLER char,
...
I may not have the syntax just right, and I can't take time
to test it until later this evening (shouldn't be reading
ORACLE-L now any
Rick,
Assuming sqlldr is installed on your client machine, you should
be able to run it locally.
HTH,
Peter Schauss
-Original Message-
Sent: Wednesday, March 19, 2003 8:24 AM
To: Multiple recipients of list ORACLE-L
Hi All,
Rick
You sure can -- as long as you can establish SQL*Net connection to the
instance on the remote machine. All you have to do is specify
"[EMAIL PROTECTED]" either on the command line or in your parameter
file.
If the OSs are exectly the same, you can even use direct path inserts
Kevin
-Or
Rick, am i missing something in the picture here??, why not use
sqlloader(you'll need it on your local PC) and send it across sql*net?
joe
> Hi All,
>
>
Sure, you can do it.
Just use Oracle Net8 connect string to connect to the remote database when specifying
userid for sqlldr.
- Kirti
-Original Message-
Sent: Wednesday, March 19, 2003 7:24 AM
To: Multiple recipients of list ORACLE-L
Hi All,
sqlldr username/[EMAIL PROTECTED] control=controlfilename
I do it all the time
sqlnet works for all Oracle utilities (sqlldr, exp, imp)
--- [EMAIL PROTECTED] wrote:
> Hi All,
>
>
>
Should not be a problem:
sqlldr control= data=
userid=/@remote_machine
where "remote_machine" is an entry in your local/client tnsnames file.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, Ma
JL,
When you describe the field type in the SQLLoader file set the
CHAR(4000)
as the field description. You are correct in saying that the default is
CHAR(255).
As an example;
col1 terminated by "," ,
col2 CHAR(4000) terminated by ","
...
Ron
>>> [EMAIL PROTECTED] 03/13/03 01:44PM >>>
Hi...
I w
Hello Nirmal,
The FILLER command is available in sqlloader to allow you to miss a field
out
something like
LOAD
(field 1 ...
field2 ...
dum_rec FILLER,
field3
)
may work but I am not sure that this will work in 7.3 of Oracle as I think
FILLER came out in 8.0x
However an easy way ( I was going t
Sqplus works well for this as long as the file is not too large.
Spooling to a file in sqlplus is quite slow.
C or, ahem, Perl, are much faster.
Jared - OCP and Part Time Perl Evangelist ;)
On Thursday 05 September 2002 11:44, [EMAIL PROTECTED] wrote:
> It's called SQL Plus. Set the heading
Thanks. Now I need to get M$ just to get Oracle to work for me.
ltiu
Farnsworth, Dave wrote:
>Hate to say it but the M$ DTS utility works really nice for moving data between
>different platforms. You can move data directly from DB2 to Oracle if you want. It
>is not good for the very huge ta
set heading off
set pagesize 0
set linesize 200
set feedback off
set termout on
select '"'|| e.empno || '",'
|| '"' || e.mgr || '",'
|| '"' || e.deptno || '",'
from emp e where rownum <=10 ;
> It's called SQL Plus. Set the heading off, pagesize = 0,
> linesize = 200, set
Thanks. Good one.
Deshpande, Kirti wrote:
>Click on "Dump Tables To Flat File" at http://www.cybcon.com/~jkstill/util/
>
>- Kirti
>
>-Original Message-
>Sent: Thursday, September 05, 2002 2:12 PM
>To: Multiple recipients of list ORACLE-L
>exports
>
>
>OK. Very good. Wow!!
>
>Yes, this
Dave:
Your moving data from relational to relational DB. What about from
hierarchical to relational?
Thanks,
Ken Janusz, CPIM
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, September 05, 2002 2:36 PM
exports
Hate to say it but the
Hate to say it but the M$ DTS utility works really nice for moving data between
different platforms. You can move data directly from DB2 to Oracle if you want. It
is not good for the very huge tables though. But if you need a quick transfer I can
have a DTS setup in a minute or two.
Dave
-
Click on "Dump Tables To Flat File" at http://www.cybcon.com/~jkstill/util/
- Kirti
-Original Message-
Sent: Thursday, September 05, 2002 2:12 PM
To: Multiple recipients of list ORACLE-L
exports
OK. Very good. Wow!!
Yes, this is what I am looking for. Thank you very much.
ltiu
[EM
OK. Very good. Wow!!
Yes, this is what I am looking for. Thank you very much.
ltiu
[EMAIL PROTECTED] wrote:
>It's called SQL Plus. Set the heading off, pagesize = 0, linesize = 200,
>set record delimiter = ',' or '|' and set feedback off; and termout on.
>This should produce an ASCII file onc
So Oracle thinks that people will only move into Oracle and not out of
Oracle.
Which makes me think. Is there a utility available in other DB's that
can extract Oracle data out in plain text?
To put this question in another way, how do you transfer data between
different database vendors? Are
It's called SQL Plus. Set the heading off, pagesize = 0, linesize = 200,
set record delimiter = ',' or '|' and set feedback off; and termout on.
This should produce an ASCII file once you supply your own query.
RWB
ltiu <[EMAIL PROTECTED]>@fatcity.com on 09/05/2002 01:05:07 PM
Please resp
No such beast. But you can roll your own... :)
Tom Kyte has a page that directly addresses this:
http://govt.oracle.com/~tkyte/flat/index.html
-- Philip
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, September 05, 2002 2:05 PM
exports
I find that the worst problems I have with SQL*Loader tend to be
language related. The same goes with export/import. I wish there were
better documentation on the NLS parameters.
and yes, it was characterset. What I didn't understand was why when I
selected from NLS_DATABASE_PARAMETERS it showed
On Mon, 26 Aug 2002 13:41:50 -0800, Rachel wrote:
>I am not, by any means, a SQL*Loader expert (Jonathan, I keep meaning
>to get your book!)
Sounds like you've solved this one already, but since you invoked my
name (and in vain too, since I was of no help ), I'll just chime
in to say that my bes
gee, this is so cool. The authors I used to read in flesh and blood, and
actually giving away a signed copy!
I'm gonna make sure I drop everything and answer the next query Rachel puts.
(And then pray hard its right and I get a copy too!)
With Warm Regards,
Manav.
- Original Message -
T
Dick,
But I DID put it that way originally... in my initial email. Which was
at the bottom of yours :)
Besides, my goal is to make programmers who speak English actually
learn to use the language
Rachel
--- [EMAIL PROTECTED] wrote:
> Rachel,
>
> Then why did you not put it that way in th
Rachel,
Then why did you not put it that way in the first place? Damn I hate those
$1,000,000,000 words that I don't understand.
Dick Goulet :-)
Reply Separator
Author: Rachel Carmichael <[EMAIL PROTECTED]>
Date: 8/27/2002 5:58 PM
accents over
No, the default is US7ASCII. See table 3-2 at
http://docs.oracle.com/cd_a97630/server.920/a96529/ch3.htm#56354. That's
why you're losing the extended characters.
Gary
-Original Message-
Sent: Tuesday, August 27, 2002 5:13 PM
To: Multiple recipients of list ORACLE-L
See, this is why t
Rachel,
If you did not solve it allreddy set your unix environment variable
NLS_LANG. This should eliminate your loading problem.
Hope this helps
Shaibal
>From: Rachel Carmichael <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>S
See, this is why this stuff confuses me.. shouldn't UTF8 accept the
diacritical marks?
argh... in any case, it's working now
Rachel
--- "SARKAR, Samir" <[EMAIL PROTECTED]> wrote:
> Rachel,
>
> The Unix server generally looks for the character set
> AMERICAN_AMERICA.UTF8 unless you specify it
Rachel,
The Unix server generally looks for the character set AMERICAN_AMERICA.UTF8 unless you
specify it explicitly otherwise by setting the environmental
variable
before the installation commences.
Samir
Samir Sarkar
Oracle DBA
SchlumbergerSema
Email : [EMAIL PROTECTED]
Phone : +44 (0)
Rachel,
I think that you are seeing this behavior, because when on Unix, if NLS_LANG
is not set in the environment, it defaults to US7ASCII, which does not
include the extended characters. The characterset shown in
NLS_DATABASE_PARAMETERS is the database's characterset, not the charset
which the
Ron,
You were dead on correct (send me your snail mail address offlist and
I'll send you a signed copy of Oracle9i DBA 101)
Anjo, you were right too but you already have, or should be getting, a
copy of the book. I'll buy you a beer at the next conference :)
Very strange. I was loading ON th
I don't think NLS_LANG is set at all, or if it is, it's the default
value.
The database DOES handle the characterset, when we 'cause when we try
put the data in via an insert statement, it goes in correctly.
I forgot (sigh) more info:
9.2 db, Solaris
I am running the load ON the server, not
I don't think NLS_LANG is set at all, or if it is, it's the default
value.
The database DOES handle the characterset, when we 'cause when we try
put the data in via an insert statement, it goes in correctly.
I forgot (sigh) more info:
9.2 db, Solaris
I am running the load ON the server, not
Make sure your environment NLS_LANG matches how the data is encoded in your flat file.
Also, does the database characterset handle whatever special characters you are trying
to import?
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
If A = B and B = C, then A = C, except where void or prohibited by
Hi Rachel,
I have attached the sample data and controlfile, which we are using to load the data.
It is loading the line feed characters('\x0d\x0a') as it is. Oracle should store it as
Line Feed while loading through SQL*Loader.
When I select this column it should displays something like this.
check the utilities documentation, specifically the Field List section
and the "terminated by" clause.. you can override the default
terminator of line feed. You can also concatenate multiple lines
together
--- "Mandal, Ashoke" <[EMAIL PROTECTED]> wrote:
> Greetings,
>
> We have one column in a
BDY.RTF
Description: RTF file
Did you, perchance, mean to specify "I:\dvh\tuppy.txt"?
-Original Message-
Sent: Tuesday, June 11, 2002 7:58 AM
To: Multiple recipients of list ORACLE-L
Hallo
I am running this script but gets this errormessage: Why is it so?
I get the errormessage
The system cannot find the file spec
path problem. you set wrong.
> The system cannot find the file specified.(I:dvh\tuppy.txt)
try full path I:\dvh\tuppy.txt or I:/dvh/tuppy.txt
--
Alexandre
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alexandre Gorbatchev
INET: [EMAIL PROTECTED]
Fat City Networ
You don't have a \ after I: That may be a Problem.
HTH
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
Live to learn... forget... and learn again.
=
Roland
It should be "I:\dvh\tuppy.txt"
Amazing..
Mark
-Original Message-
[EMAIL PROTECTED]
Sent: 11 June 2002 12:58
To: Multiple recipients of list ORACLE-L
Hallo
I am running this script but gets this errormessage: Why is it so?
I get the errormessage
The system cannot find the fi
By default all records are loaded is only true if there are no errors. The
default ERRORS is 50 which means that the load is automatically aborted when
50 records are rejected due to errors. To assure that all records can be
loaded you need to set ERRORS to a higher number than the total number
Hi,
Why don't you just copy and paste those 100 records to other file and load from that
new file.
Sinardy
-Original Message-
Sent: 05 June 2002 12:28
To: Multiple recipients of list ORACLE-L
The parameters LOAD and SKIP determine how many records to load and skip. By
default ALL rec
The parameters LOAD and SKIP determine how many records to load and skip. By
default ALL records are loaded. HTH.
Regards:
Ferenc Mantfeld
Senior Performance Engineer
Siebel Performance Engineering
Melbourne, 3000, VIC, Australia
> * +61-412-232-056
> * use mobile please
Please note 17 hour time
Terry,
Type SQLLDR at the command prompt, and all the help is displayed.
The answer to your question is :
sqlldr load=50 will load only 50 records.
Another option is to copy your data file and delete everything except for
the number of records to load for testing purposes.
Hope this helps.
Get a copy of SQL*Loader the Definitive Guide by Gennick & Mishra /
O'Reilly.
You can use command-line parameters in the control file via a the OPTIONS
command. For example:
OPTIONS (parameter=value[,parameter=value...])
You can use:
SKIP=logical_record_count
LOAD=logical_record_count (the nu
It is supported on the machines that have implemented RPM
instruction in their CPUs.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 04, 2002 12:08 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: SQL*
$ sqlldr help=y
userid ORACLE username/password
control Control file name
log Log file name
bad Bad file name
dataData file name
discard Discard file name
discardmax Number of discards to allow
skipNumber of logi
Terry - Use Unix head command to create a small test file.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, June 04, 2002 10:39 AM
To: Multiple recipients of list ORACLE-L
Oracle 8.1.6.3 on Sun 2.6.
I have tried reviewing the docs, but I didn't s
why not just create a smaller input file?
head -100 ...filename... > testfilename
and use the test file?
--- "Ball, Terry" <[EMAIL PROTECTED]> wrote:
> Oracle 8.1.6.3 on Sun 2.6.
>
> I have tried reviewing the docs, but I didn't see anything that
> answered the
> question. Is it possible to
I don't know of any such option in sqlloader. But, you can do one thing copy
the 100 records from the file and create a new file and try to load that
one. Hope this helps.
Regards,
Inder
-Original Message-
Sent: Tuesday, June 04, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L
I don't know if you can load the first 100 records, but you could load
the last 100 by setting the "skip" value to the total - 100.
HTH,
Beth
-Original Message-
Sent: Tuesday, June 04, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L
Oracle 8.1.6.3 on Sun 2.6.
I have tried rev
How about using external table?
You define the table as external having one field.
I think that select * from such table will bring you the lines in order
and then you can do whatever you want with the data.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L
Client is not accepting to use the utl_file for reading data from the file.
i have to fetch each line from the file and process it for storing the
information in various tables. so apart from sql loader can u suggest other
method (excluding utl_file) for doing the same operation.
Best Regards,
Sh
>Hi friends,
>I have to load a input file into a oracle
>table . The table has only
>one field which will store each line as a single
>row . The order of the file
>is very important for my further process.
Perhaps you should re-read a paper published in 1970 in 'Communications of the ACM
Hello Shankar,
You can'n rely on rowid in your case. It would be much better to add
additional field into your table and write rownum to it.
You can generate record number automatically by SQL Loader.
Here is simple example how to do it:
LOAD DATA
INFILE 'yourfile.dat'
BADFILE 'load.bad'
INSERT
Trang,
I had a similar problem a while back and the answer was to have the
clause
"TERMINATED BY WHITESPACES" as the option for the last column. Yours
continues to the next line because of the termination and enclosed
clause.
You might be confusing the load by saying it is TERMINATED BY and
ENCL
f Mercadante,
> Thomas F
> Sent: Monday, April 08, 2002 12:57 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: SQL*Loader
>
>
> Dave,
>
> I bet you the single quotes around the data string are messing
> you up. You
> could try the following:
David,
In the FIELD clause, shouldn't it be OPTIONALLY ENCLOSED BY ?
-Original Message-
Sent: Monday, April 08, 2002 12:16 PM
To: Multiple recipients of list ORACLE-L
I am trying to user SQL*Loader to load some tables in my 8i database. The
data will not load. It seems to have to do
ot,
David Ehresmann.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of John Hallas
> Sent: Monday, April 08, 2002 12:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: SQL*Loader
>
>
> David,
> What does your log
Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of John Hallas
> Sent: Monday, April 08, 2002 12:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: SQL*Loader
>
>
> David,
> What does your log file show as the reason for failure?
>
Dave,
I bet you the single quotes around the data string are messing you up. You
could try the following:
DATETESTED char "rtrim(ltrim(to_date(:DateTested,'mm/dd/ hh:mi:ss
pm'),),)",
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: M
Hum, I could be reading this wrong but it looks like you are converting a
char to a date and then putting it into a char column If its a char on
the table then don't convert it to a date first. Otherwise change the data
type to date.
DATETESTED char "to_date(:DateTested,'mm/dd/ hh:mi:ss
David,
What does your log file show as the reason for failure?
John
-Original Message-
Sent: 08 April 2002 17:16
To: Multiple recipients of list ORACLE-L
I am trying to user SQL*Loader to load some tables in my 8i database. The
data will not load. It seems to have to do with the format.
seems like You are loading data from one version of database to the other
version , try to use the version compatible tool like
sqlldr80, sqlldr73. sqlload.
I guess this may be your problem
-Original Message-
Sent: Tuesday, March 26, 2002 4:30 PM
To: Multiple recipients of list ORACLE-L
Hi Roland,
You could do this via the OEM job system.
Or whatever batch scheduling system exists in your environment
John
[EMAIL PROTECTED] wrote:
>Hallo,
>
>How is it possible to schedule an sql loader script, which is running on network(not
>unix). Let us say this should run at 6 pm ever
what does running on a network(not unix) mean? any way you can use a
scheduler. There are alot of free ones avaiable.
On Mon, 18 Mar 2002 [EMAIL PROTECTED] wrote:
> Hallo,
>
> How is it possible to schedule an sql loader script, which is running on network(not
>unix). Let us say this should r
Not Unix - I will presume NT.
On NT you can use the AT command to schedule task.
Just type AT at the command prompt.
One more thing: activate the scheduling service.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROT
Hi Witold :
You should, to create an function "divide" : divide(12345/100)
result = 123.45
In ControlFile you should include the following sentence :
LOAD DATA
TRUNCATE
PRESERVE BLANKS
INTO TABLE TABLENAME
(
FIELD1 POSITION (1:20) CHAR,
FIELD2 POSITION (21:21) DECIMAL E
Iashraf,
Not knowing what your table desc looks like for the columns in question
and what the actual data, (record 2389 and 885) looks like I can take a
wild guess at the explaination.
Record 2389 the comments column " Delimited data was specified with a
maximun length and the data value exceeded
The first is a SQL loader error:
SQL*Loader-00621 Field in data file exceeds maximum length
Cause: A field exceeded its maximum allowable length. The maximum length is
either the length specified in the SQL*Loader control file, or, for
delimitable fields without a length specified, the maximum len
1 - 100 of 198 matches
Mail list logo
