You Asked

We will be migrating our databases from 11g to 12c in the next few months. We have a 1 TB database which has about 10 tables which have xml data (clob) in them. What is the best way that's proven to migrate from 11g to 12c ? In the past we have tried to use expdp but we have never been able to successfully export the clob data. This database is a 24x7 database but during this migration we will stop traffic and will have a weekend to complete the migration.

Thanks for your help.

and Connor said...

What do you mean by "migrate" - do you have to *move* the data from one platform to another ?

Why wouldn't you just upgrade in place ?

If it *is* a true migration, then transportable database is a great way of doing it with minimal downtime.

https://connormcdonald.wordpress.com/2015/06/06/cross-platform-database-migration/

Rating

(5 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

What are Migration Update,uprade

santhoshreddy podduturi, May 03, 2017 - 12:46 pm UTC

Hi,
i have confusion with this Terminologies
migration,update,moving,Upgrade
when i googled about them every where i got different info. so can you tell me what are those mean?

May 04, 2017 - 1:48 am UTC

Unfortunately people are often loose with their usage, but typically

migration
=> I'm taking the database from one *platform* to another, eg, from AIX to Linux

upgrade/updating
=> I'm taking the database from one *version* to another, eg, from 11g to 12c

moving
=> I'm taking the database from one *server* to another on the same platform

Server....?

santhoshreddy podduturi, May 05, 2017 - 4:08 am UTC

Migration : one platform to another Ex : ASIX os to LINUX os or any other

Update/Upgrade : One version to another 11g to 12c
Upto here clear
But
Moving : one server to another Server
not clear because server can be device or software
https://en.wikipedia.org/wiki/Server_(computing )
here server means server machine or server software likes apache etc?

May 09, 2017 - 2:24 am UTC

In this case, I meant "machine"

Multiple Changes

A reader, May 09, 2017 - 9:00 am UTC

What should i call in below cases
1.Upgrading DB From 11g(UNIX) to 12c(LINUX) here platform also changed
2.Moving From One machine to another Machine each one has a different platform

May 10, 2017 - 1:22 am UTC

Its a migration with upgrade.

I did this for a client using a cross-platform transportable tablespace - its a great way of minimising downtime and risk

https://connormcdonald.wordpress.com/2015/06/06/cross-platform-database-migration/

Interface and Conversion

A reader, October 04, 2018 - 7:30 am UTC

Hi

What is conversion and interface, are they other names of upgrade?

and what do we call transferring the SQL Server data to Oracle Database.?

October 05, 2018 - 3:40 am UTC

Not sure I understand your question.

But SQL Server data to Oracle Database is a whole new ballgame

A reader, October 07, 2018 - 4:39 am UTC

You defined migration as
Moving database one platform to another EX AIX to Unix.
and also you said moving data from sql server to Oracle is whole new ballgame.if it is a new ballgame how should i address it? and in Oracle tutorials ,it's addressed as migration
https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/sqldev/r30/SQLServerMigration/SQLServerMigration.htm?print=preview

also i came across below words when i was referring to EBS oracle docs
1.Conversion
2.Interface
https://docs.oracle.com/cd/E18727_01/doc.121/e13570/T172155T393841.htm
https://docs.oracle.com/cd/E18727_01/doc.121/e13662/T358453T358456.htm#2788890

October 08, 2018 - 1:07 am UTC

I think you're delving into semantics here.

Migration also means birds flying south for the winter - that doesn't rule out the term migration for database systems.

Ultimately, significant database changes go into a sliding scale of effort/complexity

1- Oracle to Oracle, same OS, platform
2- Oracle to Oracle, different OS or platform, same endian
3- Oracle to Oracle, different OS or platform, different endian
4- Oracle to something else, or vice versa

For 4, you will always be looking at a data unload and reload - then its just a case of deciding what tools will be best to support that.

More to Explore

Data Pump

All of the database utilities including Data Pump are explained in the Utilities guide.

Breadcrumb

Question and Answer