Recent content by MikeTruscott

In case anyone reads this and wondered if it solved the problem. ------------------------------------------------ Haven't posted a reply until now as the problem went by itself. Now it's back! Restarting only the service of the database didn't work either. SQLPlus and the enterprise manager...

Right....update! I've been splitting the csv file up by size (of file) which meant that some lines were being cut off. When I go into the new file and delete the incomplete records completely it works, but when I try to copy and paste the missing parts of lines back, to create complete...

Hello.... Have tried changing the READSIZE variable and I get a different error: ------------------------------------------------ ERROR at line 1: ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error KUP-00554: error encountered while parsing access...

Hi Mufasa....we meet again! :-) My code is below. ----------------------------------------------- CREATE TABLE EXT_MT ( MT1 VARCHAR2(255), MT2 VARCHAR2(255), <etc up to MT100> ) ORGANIZATION EXTERNAL ( TYPE oracle_loader DEFAULT DIRECTORY EXTERNAL_DATA ACCESS...

Hi everyone, I have a csv file with 6 million records in. When I split it into quarters I can import it (via an external table) to my ORACLE database with no problems. However, when I try to import the whole lot I get the error: "KUP-04020 Found record longer than buffer size reported" I get...

Morning, So I came in yesterday to try out my awesome function to pad out the lines, and received an email saying that I should just be able to use 'TRAILING FIELDS NULL' in my control file. Did a google search for this and couldn't find anything, so thought he meant 'TRAILING NULLCOLLS'...

So would it go something like this? I've cutted and pasted from what examples I've managed to find! ------------------------------------------------- DECLARE n_file UTL_FILE.FILE_TYPE; v_file UTL_FILE.FILE_TYPE; v_NewLine VARCHAR2(51000) <----POSSIBLE? BEGIN v_file :=...

Mufasa that's a great idea! Not sure if I can use it though as I was told that if I opened the csv file in excel I'd lose some decimal places in my numbers. Some of them are lats and longs so accuracy is quite important. Of course, the other problem here is that excel can only handle 65000...

Balls..... :-) I hoped it would cope with it as all of the fields are of the same data-type. I thought it might populate the first x columns and then stick nulls in the remaining ones. It wouldn't be a problem if the csv file was small. I could write some vba in a few mins that would add the...

Tharg, Thanks for all your help so far! I finally got the external structure in place (got confused with the PROMPT and ACCEPT bits) but it's not importing anything. All of the file is going straight into the BAD file, but at least it's producing a BAD and LOG file so I know the process is...

...and another thing (!) In the .bad file it's inserted little rectangles (carriage returns?) in random places. Also, new lines are starting in random places so what should be the first piece of data on a line appears somewhere else. Not sure if the .bad file is meant to have any structure to...

Hello..... Just a quick update....I created the control file by typing the SQL into a .txt file and renaming it. Not sure if this is how you're meant to do it! Went into DOS and typed in the line DAGON mentioned above and it didn't work....maybe due to spaces in the directory paths. So I moved...

Hi Tharg, I tried restarting the service of ARCHIVE, stopped the other services and also stopped & restarted the listener service....but it still didn't work. Couldn't connect through SQLPlus or the OEM. It only took two restarts this time though. :-) Cheers Mike

Dagon....thanks for the quick response! The table that I import the data to....does it have to exist in the database or will the control file create it for me? If I've got to generate some cort of set of column names then I'll do it through Excel and paste the text into the control file. They...

Hi everyone..... I basically have a csv file with millions of rows in, which I want to stick into an oracle database. I'm hoping that, if I'm not fussy (see below) it's a one or two line job....but I'm not an ORACLE expert! The csv file: 1:Has no headings 2:Is comma delimited 3:Has a couple...