I managed to export data from a table in an Oracle database in .csv format using SQL Plus.
I have this file locally.
Now I need to import this same .csv file into another table in another Oracle database.
The version of Oracle here at work is 11.2 and does not have the SQL Loader utility.
What can I use to perform this import?
I thought about creating a script that has a truncate and a code to take line by line from the CSV file and insert it into the database. How do I do this?
Thank you
Asked by Joyce Ferreira
(13 rep)
Dec 19, 2024, 04:42 PM
Last activity: Dec 20, 2024, 12:32 PM
Last activity: Dec 20, 2024, 12:32 PM