Move Data from Third Party Database to Oracle
Using the Migration Wizard in SQL Developer, you can move your data from a third party database to Oracle.
Copyright © 2013 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
Closed Caption:
you can now move your data in the move
date and step you can do it either
online or offline mode if you do the in
online mode we need to specify or source
connection and for the target collection
you want to continue on using this new
user who has the privilege to generate
the script to do the data move now
there's an existing data you can
truncate
and finally it will take you to the
summary page where you can review the
actions for each of your step
when you put on finish it will go ahead
and generate this grip to create your
database and it will go ahead and move
your data from your side base to Oracle
once the migration complete you can now
create connection to your new Oracle
database going to be great mean
connections dialogue give it a
production name
a username and the password will be the
same
say the password
once connected you can now you all the
objects that have been migrated here
your table you can take a look at the
column definition and the data that's
been migrated over this completes your
side base migration to oracle using the
migration wizard
Video Length: 02:31
Uploaded By: Oracle Learning Library
View Count: 14,285