1) Connect to the target database and Create a user in target database
2) Grant select any table privilege to the user who has been created in step 1.
3) Create a Private database link from target to source using the username created in step 1
4) AS the user in target database,
CREATE TABLE new_table AS (SELECT * FROM owner.table_name@DB_LINK);
insert into tablename select * from owner.source table_name@DB_LINK;
Gather schema/table stats
Verify the data with source database
2) Grant select any table privilege to the user who has been created in step 1.
3) Create a Private database link from target to source using the username created in step 1
4) AS the user in target database,
CREATE TABLE new_table AS (SELECT * FROM owner.table_name@DB_LINK);
insert into tablename select * from owner.source table_name@DB_LINK;
Gather schema/table stats
Verify the data with source database
Through the data migration development services provided by your company, I became capable of solving the most significant issues related to the data migration projects. The virtualization of your services had helped me in transforming the data efficiently from one source to another.
ReplyDelete