Hi,
I am using version 19.2. I am trying to use the gui to load data into a table.
Ideally, I want to use the gui to generate me scripts required to load into a table (existing or new). I have been automating this in the past using scripts (windows/unix shell scripts + sqlplus). I know now we have sqldeveloper with cli + sqlcli and can easily get all this done without much sweat.
Was trying out the data import first from the sqldeveloper desktop . Right Click on say a table and then selecting Import Data start a windows to allow me to do this . Entered the required info about the source dataset (an excel *.xlsx in this case - would like to also be able to use a binary spreadsheet i.e *.xlsb ). When it come to choosing the Import Method, I can only see 2 options:
- Insert 2) Insert Script - ( in my sqldeveloper v19.2 - which is version i can only use for work at the moment as i cannot download latest version at work)
Below is a screen shot which I see when I am using version 21.2.1 at home but on the version 19.2 I cannot see the sqloader and external data options (are these the full list I should have?)
Any problems I have for these options not on version 19.2 like a restricted option that has been disabled or maybe is there a concept of roles / privileges (of the target database) that I need to have to use certain option in sqldeveloper? Or is it sqldeveloper install issue or bug or just not Available Yet on 19.2 or just my ignorance how to enable my tool?
So after this generate me some scripts (with sqlloader - not the Insert Option which is good to have for small tables). I was planning (after I am happy with what I see) to then combine this all with sqlcli and shell scripts to automate some load and transformations into a target database. I think the latest version of sqlcli and sqldeveloper will probably do what I dreamt of 15 year ago. . I actually have some other ideas too I want to explore and dream it happening. Database developers and DBAs' life getting easier and more exciting. Wished we had this 15 years ago.
Thank you . Hope I explained what I am trying to do and what the issues I am getting with trying the data import option.