Skip to Main Content
  • Questions
  • How to copy the csv files from the shared path to HP-Unix server Data base directory

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question.

Asked: July 29, 2020 - 12:14 pm UTC

Answered by: Connor McDonald - Last updated: August 05, 2020 - 3:13 am UTC

Category: PL/SQL - Version: 9i

Viewed 100+ times

You Asked

Hi Sir,

I'm using the Oracle 9i database in the HP-UNIX system.
The directory name is "XX_DATA"
Shared network path "\\mkees01\public\Details.csv"

May you please help me by providing the code for below scenario.

From the Shared network path file - Details.csv how to copy to the oracle database directory?

Regards,
Sankar

and we said...

Sorry - isn't this just

  UTL_FILE.FCOPY(src_location  => 'MY_DIR',
                 src_filename  => 'Details.csv',
                 dest_location => 'MY_OTHER_DIR',
                 dest_filename => 'Details.csv');


and you need to ensure the oracle account has access to the share/mapped drive ec

More to Explore

PL/SQL

Check out more PL/SQL tutorials on our LiveSQL tool.