browse by category or date

Today I was required to copy some data from our production Oracle server into test server. To do the schema & data transfer, I used Oracle SQL Developer. I am assuming that the connections to both production and test servers is already added in SQL Developer.

In SQL Developer, select Tools -> Database Copy

Next, select the source (Production) and destination (Test) database. In my case, the production server is TMS, and the test server is TMS ES4. Also select the “Schemas Copy”.

Next, select the object types to copy over. By default all object types will be selected.

Next, select the schema to copy. Here in my example, actually all schemas exist in my production DB are shown. I only needed one schema, RICHLAND.

Next, we select the objects within this schema to be copied over. Click the “Lookup” button to show the objects, then include objects that you want. For my case, I clicked the >> button to select all objects.

Next, we select which data to copy over. You can add conditions to each table to ensure you copy the correct data.

Last step, the summary of the process will be shown. If you realize any mistake, you can always press “Back” button to correct it.

Click “Finish”, and the copying process will start.

That’s all 😀 If you encounter any issues, drop a comment at the bottom of this page.

GD Star Rating
How To Copy Oracle Database To Another Server, 4.0 out of 5 based on 1 rating

About Hardono

Hi, I'm Hardono. I am working as a Software Developer. I am working mostly in Windows, dealing with .NET, conversing in C#. But I know a bit of Linux, mainly because I need to keep this blog operational. I've been working in Logistics/Transport industry for more than 11 years.

No Comment

Add Your Comment