How to copy one schema into another using SQL

Some times we don’t have the DBA access and need to copy data from one schema to another. You can perform that by executing migration SQL script in Oracle XE.

Step 1. Generate migration script.

Step 2. Run Below script by updating Source and Target connection details

Step 3. Execute the script. and commit the changes.

This will migrate data from one schema to another.

Leave a Reply

Your email address will not be published. Required fields are marked *