![oracle sql developer dump oracle sql developer dump](https://img.dumpsboss.com/7/73025f11-ffeb-4271-b6f9-cdd102ad2e97.png)
We should strive to overcome complex and complicated things in the most simple and efficient way, rather than showing off "skills". The real challenge is: are you interested in just looking cool, having a few terminals with running stuff, or you just want to do the task, as simple and efficient as possible? And I believe this is not necessarily related to IT, rather it's life. or not :)īack in the day, I should have had serious dba skills, Linux knowledge, scripting and so on and so forth. Why, because I love ADW for having all the #AI and #MachineLearing algorithms built in, self-driving the database for me, so I am worrying just to get the data in and run my analytics queries through OAC.Ĭoming back to my data, I am not talking about a table or two, but an entire schema with three years’ worth data. So, I have a local Oracle database needed to be migrated to the latest Oracle Autonomous Data Warehouse (ADW). I am starting with the data (moving OBIEE metadata is going to be covered in a future blog). Still, I embrace the challenge to migrate an ‘old’ on-premise Oracle Business Intelligence Enterprise Edition (#OBIEE) to the ‘new’ Oracle Analytics Cloud (#OAC). Repeat from step 1 for each file you wish to import into a table.Let's say I am an average Joe, I am not a skilled dba nor have many technical skills either.Click Nextįor each column you wish to import, choose the appropriate Data Type and Size/Precision (max length) (For example, the Product Code would be VARCHAR2 type with size 3).
![oracle sql developer dump oracle sql developer dump](https://miro.medium.com/max/1300/1*IO18R1C-iocuOaq21EmXbQ.png)
Click Next.Ĭhoose Insert for your Import Method. Set the Left and Right Enclosure to none. For the Format dropdown, select Delimited. csv.Ĭonnect to your schema and right-click on Tables. Note: Before you start this process, you must first manually change the file extension of the pipe-delimited device file(s) from. The following directions are for the Oracle SQL Developer tool, but similar actions can be taken in other SQL tools and database types. For information on limitations, look at the software's official documentation Directions These files can be imported into a database for easier reading and interaction.īe aware of the file size and row limitations of the software you are attempting to import the files into. The Pipe-Delimited | device files provide a relational view of the device record data.