PL/SQL (MOSC)

MOSC Banner

What are the imp Steps needs to be consider during Conversions

edited Dec 12, 2011 2:04AM in PL/SQL (MOSC) 4 commentsAnswered
Hi ALL,

I have a requirement where I have to do coversion ..Can anyone please tell me the steps I should take for conversion .?

I have thought for below steps , but in case if there is a better approach then please do let me know

Lets suppose I have millions of record in legacy system

1) First I will move all records to an excel sheet using UTL package . 

2) Then with sql loader , I will upload all data to my target interface table

3) then from interface table data will be moved to base table

However I have few doubts in it --

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center