Oracle

Database Migration from SQL Server to Oracle using SQL Developer

Download SQL Developer from: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html. Unzip the file and open sql developer. First, Create user ”Migration” for migration repositery where sqldeveloper manages metadata for migration. Grant privileges to Migration user. Create user Migration identified by migration Default tablespace users temporary tablespace temp; grant all privileges to migration; Right click on connection tab to Create new connection: Now create a database connection repository…

Continue Reading

Oracle

Oracle 11g Step by Step Installation

If you are installing on Non-Network Computer than it is recommended to disable your wireless connectionInstall Loop back adapter using the following steps. Initiate the run window by pressing the Windows + R button. The following screen will appear. Type the following command on this window and press enter The following window will appear, asking to add the new hardware…

Continue Reading

Oracle

Upload Image on Oracle Forms and Saved into Database through Webutill

Prerequisite: Successful configuration of webutil. Here is a guide for webutil configuration. Steps: Open Oracle forms builder 11g Create a new form,a new block & a canvas. Attach webutil.pll on Navigator—> Attached Libraries in Forms. Click file—>open—>C:\Oracle\Middleware\Oracle_FRHome1\forms\webutil.olb click webutil.olb file and it will create some entries in object library (in navigator) Click on object libraries there u have webuitl, right click on webutil…

Continue Reading

Big Data, Hadoop, Oracle

Impact of Big Data, Data Warehouse, and Internet of Things on Insurance Companies.

It is witnessed that over the past few years, the Internet of Things (IoT), have increasingly changed the models of business in a plethora of different ways, affecting many sectors and industries in the world. Currently, it is witnessed that the insurance companies are also largely getting affected as the rate-making procedures and business models largely driven by IoT have…

Continue Reading