AUTOMATIC IMPORT DATA FILES

[mgpr]

I HAVE TO DEVELOP AN AUTOMATIC IMPORT PROCESS WHERE CSV-FILES WILL BE IMPORTET.
WITH SQLLOADER YOU CAN IMPORT THAT MANUELL BUT I WOULD NEED A METHODE TO IMPORT THEM AUTOMATIC SO I CAN RUN APPLICAITON ON A SERVER(HPOX) WHERE DATA WILL BE IMPORTET AT NIGHT.
I HEART ABOUT SOMETHING WHERE YOU CAN IMPORT DATA DIRECT WITHOUT SQLLOADER.

THANKS FOR YOUR TIME!

 

[mgpr]

WOULD NEED THEM FOR CLOB'S AND FOR BLOB'S DATES!

FUNCTION TO RUN A JOB DURING NIGHT ON SERVER(HPoX-Unix) WOULD BE ALSO A REAL GOOD ADD.

 

[mgpr]

SOME TIPS ON WHICH FUNCTION I
SHOULD LOOK, WOULD ALSO HELP

 

[DoubleH]

Hi,
The best thing is that write a Unix/awk/perl script to do that. You can generated the exact control files, sqlldr statement using Unix/awk/perl. Then You can also write statements in Unix/awk/perl to invoke the sqlloader. This will make Your process automatic. Even if Your data format is going to be diferent from one feed to the another You can generate the exact control files and the sqlldr scripts. This would be helpful to You in a long run. Thanks & Regards,
DoubleH

 

[mgpr]

thanks for your help DoubleH

 

[kllick123]

You can use UTL_FILE to load the data into tables.

Also you can submit a JOB which will run as per your need
any time..


Arun Tayal

 

[Turkbear]

Hi,
Just a netiquette tip..ALL CAPS is shouting, so unless you have only caps , please do not use them so much