oracle11g - Oracle 11G, external tables and .csv file -

-

having issue external tables in oracle 11g. i'm using db artisan run query. create , organization code executes successfully, when run select statement getting error. .csv file set same way layout external_table header such.

create table external_table (     col1 number(14),      col2 varchar2(10),      col3 varchar2(3),      col4 varchar2(3),      col4 varchar2(4),      col6 number(4,0),      col7 varchar2(20),      col8 varchar2(20),      col9 number(3)     ) organization external  (     type oracle_loader     default directory folder1     access parameters     (            records delimited newline         fields terminated ','         missing field values null         (col1 char(14),     col2 char(10),     col3 char(3),     col4 char(3),     col4 char(4),     col6 char(4),     col7 char(20),     col8 char(20),     col9 char(3)                                       )     )     location ('filename.csv') --name of flat file. ) reject limit 0;

running:

select * external_table

gives error:

 ora-29913:error in executing odciexttableopen callout ora-29400:data cartridge error kup-04027:file name check failed: a:\job\job\filename_1234_5566.log

kup-04027:file name check failed means file location not valid.

so, given file name ...

a:\job\job\filename_1234_5566.log

... several thoughts occur:

  1. as @jonearles points out, a: traditionally reserved floppy disk drive. database server (i.e. machine hosts database) have a: drive? if not should correct that.
  2. does drive really have root directory called job sub-directory called job? or typo in path of directory object folder1?
  3. also, sample code gives file name 'filename.csv'. doesn't match file name in error message. specify file name in external table definition?
  4. the exact causes of kup-04027 specific operating system, because file naming conventions peculiar each os. guess database resides on remote unix server you're trying read file local windows pc. if scenario won't work: you'll need upload file database server.

Comments

Post a Comment

Popular posts from this blog

java - Run a .jar on Heroku -

-
i trying run .jar file on heroku, , can't find instructions anywhere on how this. have read wants me compile uploading heroku. possible, , if is, how this? if helps, trying run minecraft craftbukkit server, , don't have pom.xml file yet. you didn't provide details i'll try give , people reaches question way it. first of all, create heroku account , create heroku application (assumed have done that). second, need generate application jar , upload heroku. so, open terminal , install heroku cli (assuming unix terminal): $ sudo npm install -g heroku-cli you need have npm , nodejs installed, can check link: https://www.digitalocean.com/community/tutorials/how-to-install-node-js-on-ubuntu-16-04 once done that, can use npm update node version acceptable heroku-cli: $ sudo npm install -g n $ sudo n 7.10.0 and run: $ sudo npm install -g heroku-cli in order deploy jars, need install deploy plugin: $ sudo heroku plugins:install heroku-cli-deploy ...
Read more

java - Jtable duplicate Rows -

-
Image
when add new rows in jtable duplicate rows many times this method update jtable public final void tableaucomande(){ ((defaulttablemodel)tabcommande.getmodel()).getdatavector().clear(); session s=hibernateutil.getsessionfactory().opensession(); criteria cr1= s.createcriteria(commande.class); list <commande> lcs=cr1.list() ; criteria cr2= s.createcriteria(lignecommande.class); list <lignecommande> lck=cr2.list() ; if(lcs.size()!=0 && lck.size()!=0) { (commande lc:lcs) { for(lignecommande lig:lck){ ((defaulttablemodel)tabcommande.getmodel()).addrow(new object[]{ lc.getid_cmd(),lc.getnumcmd(),lc.getdate_cmd(),lc.getclient().getnomprenom(), lig.getproduit().getlib_prd(),lig.getquantite(),lig.getproduit().getid_prd() }); } } // tabcommande.setrowselectioninterval(tabcommande.getrowcount()-1,tabcommande.getrowcount()-1); } } this code add add data rows displaye...
Read more

validation - How to pass paramaters like unix into windows batch file -

-
i need pass various parameters .cmd file unix format file.cmd -configuration=value -source=value -flag but, try this: startlocal @echo off cls setlocal set cmdline=%* set configuration= set source= set badargs= set validation= goto main :splitargs echo splitargs(%*) if "%*" neq "" ( /f "tokens=1,2,* delims== " %%i in ("%*") call :assignkeyvalue %%i %%j & call :splitargs %%k ) goto :eof :assignkeyvalue echo assignkeyvalue(%1, %2) if /i %1==-configuration ( set configuration=%2 ) else if /i %1==-source ( set source=%2 ) else ( rem append unrecognised [key,value] badargs echo unknown key %1 set badargs=%badargs%[%1, %2] ) goto :eof :validate echo validating set validation=fail if defined configuration ( echo -configuration ok if defined source ( echo -source ok if not defined badargs ( set validation=success ) ) ) goto :eof :main cl...
Read more