Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1169
  • Last Modified:

Upload data from csv to Oracle [ using Oracle Client ] ..

Hi,

I've a csv file and need to upload that data to Oracle Database.
The table already exist and i need to append these data into that existing table.
If append is not possible then also i can manage with insert with new since very less data is existing there.

The Server is at a remote loaction and i've Oracle Client installed on my system.
Is it possible to upload the data using Oracle client ?? ( i donna have a DBA privileges ).
But i can insert the data in the same table available using the Oracle Client.

Please help me out.
Regards
0
aashish_bg
Asked:
aashish_bg
1 Solution
 
andrewstCommented:
0
 
sujit_kumarCommented:
if you have TOAD (Free download from quest.com) you can do it in the most easy fashion. Otherwise you will have to do it by SQL Loader as stated above.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now