migrate view to table
Posted by:
Erwin Pino
Date: January 11, 2006 05:46AM
The migration toolkit works wonderfully!
I have 2 questions that I am sure are possible but I have not found the solution yet:
In Oracle we have a set of views that aggregate data. These must be migrated to MySQL as tables. How can I do this using the toolkit?
My current workaround is a script in Oracle that converts the views to tables (create table xxx as select * from yyy) and then to migrate the tables, but a direct route would be nicer.
There is a dropdownbox to select the migration target. There you can select anything as long as it is MySQL. The Java code seems fully capable of migrating MySQL to Oracle. How can I migrate some data from MySQL to Oracle? Will other targets be supported soon?
If Oracel as target is not possible or desired, what would be the classes/methods I need to build in Java for use in a lua script?
Thank you
Subject
Written By
Posted
migrate view to table
January 11, 2006 05:46AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.