Oracle

Oracle

Oracle is the world’s most popular database in enterprise market. It’s designed for true distributed computing and handles the most complex and demanding needs.

Original Oracle database was created by Software Development Laboratories consultancy in 1977. Bob Miner was the lead engineer in the early days, programming the majority of Oracle version 3 by himself. Oracle was the first database to take advantage of relational algebra and theory of relational databases described by IBM’s Edgar F. Codd. As IBM was slow to realize Codd idea’s potential, small SDL was able to come to market with its relational SQL database product before IBM. SDL changed name to Oracle Systems Corporation in 1982, then in 1995 it became Oracle Corporation.

Oracle introduced a lot of firsts in the database world. In 1985 Oracle 5 worked in now-standard client/server mode. In 1988 PL/SQL was introduced, Oracle’s extension to standard SQL query language. Starting with Oracle 8i, Oracle supports web-scale and Internet technology. Today Oracle provides large database clusters, in-memory databases, data warehousing, business intelligence, distributed key/value NoSQL database and cloud services. Oracle acquired Sun Corporation and with it MySQL database, much to the chagrin of MySQL author who in turn left MySQL AB corporation and spun off MariaDB project, compatible with MySQL, but fully open-source.

Full Convert supports Oracle database directly.

Oracle data types we support

Decimal

binary_double, binary_float, float (real), number (integer, int, smallint, numeric, dec, decimal)

Text

char, clob, nchar, nclob, nvarchar2, varchar2

Date/Time

date, timestamp

Large objects

blob, clob, nclob, sdo_geometry, xmltype

Other

anydata, array, bfile, interval day to second (interval day), interval year to month (interval year), long, long raw, raw, rowid, urowid

Export Oracle database

It may make sense to migrate your data away from Oracle. You may want to do it permanently or just need to share your tables with a collague in a different format.

We will copy all your tables with their data and apply indexing and relationships exactly as they are in your current Oracle database. In a nutshell, you get exactly the same database in another database engine. Each time you run the migration, we will copy all the tables again. Of course, we have a built-in scheduler, so you can run this overnight and have a fresh database copy in the morning.

Take a look at the quick tutorials below to see how it's done.