Can You Explain The Process Of Data Migration From Oracle To Greenplu

1.	Can You Explain The Process Of Data Migration From Oracle To Greenplum?
Answer» There are many ways. Simplest STEPS are Unload data into csv FILES, create tables in greenplum DATABASE corresponding to Oracle, Create external table, start gpfdist POINTING to external table location, Load data into greenplum. You can also use gpload utility. Gpload creates external table at RUNTIME. There are many ways. Simplest steps are Unload data into csv files, create tables in greenplum database corresponding to Oracle, Create external table, start gpfdist pointing to external table location, Load data into greenplum. You can also use gpload utility. Gpload creates external table at runtime.

Can You Explain The Process Of Data Migration From Oracle To Greenplum?

Answer»

There are many ways. Simplest STEPS are Unload data into csv FILES, create tables in greenplum DATABASE corresponding to Oracle, Create external table, start gpfdist POINTING to external table location, Load data into greenplum. You can also use gpload utility. Gpload creates external table at RUNTIME.

There are many ways. Simplest steps are Unload data into csv files, create tables in greenplum database corresponding to Oracle, Create external table, start gpfdist pointing to external table location, Load data into greenplum. You can also use gpload utility. Gpload creates external table at runtime.

Discussion

No Comment Found

Related InterviewSolutions

How To Delete/drop An Existing Database In Greenplum?
Where Can I Get Help On Postgres Psql Commands?
Gpstart Failed What Should I Do?
Why Do We Need Gpstop -m And Gpstart -m?
What Is The Procedure To Get Rid Of Mirror Segments?
How To Run Gpcheckcat?
What Is Gpdetective And How Do I Run It In Greenplum?
How To Delete A Standby?
How To Re-sync A Standby?
How To Recover An Invalid Segment?