Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Exp/imp using sql developer!

446May 30 2014 — edited Jun 5 2014


Hi - Using sql develepor(3.0) i took the export(Tools -> Database export) of an oracle database (residing in remote linux server) and stored the dump file in the local directory,now i need to import the oracle dump to the oracle XE 10g(installed in my local machine) ,but i don't find any option in sql developer to import using dump file.

Since am using v 3.0, i tried to use expdp in the remote database but i don't have privilege to do this on remote server environment.

Is their any other way to do it?

Comments

abhinivesh.jain

Hi Suresh,

Please find below the Oracle's answer to your question.

Postgresql to Oracle migration

Hope it helps.

Thanks,

Abhi

abhinivesh.jain

One more link that gives more details on how to approach this migration.

any migration tool for postgres to oracle? thanks!

1 person found this helpful
2928666

Hi Abhi,

 

Thank you for your response.

Is Oracle SQL Developer tool suitable for this migration?

Please  suggest which tool is best one for this migration?

Regards,

Suresh.

Mkirtley-Oracle

Hi Suresh,

     If you look at the links provided by Abhi to previous threads you will see that SQL*Developer doesn't currently support Postgres migrations.  There are suggested alternatives in the referenced threads.


Regards,

Mike

abhinivesh.jain

As per earlier threads, Oracle SQL developer doesn't support Postgres to Oracle migration hence you need to go for some other tool/approach as listed in my second reply.

such cross RDBMS migrations are done in 2 phases.

Phase 1- Code migration

Phase 2- data migration

In phase 1, you work on DDL conversion for all objects like- tables, views, triggers, procedures, packages, Mviews, in-built function conversion etc. This becomes complex when there is lot of code present since in many cases, you have to re-write the code to make it work in target RDBMS.

in phase 2, it is about migration of table data from source to target. It can be done by simply dumping the table data in CSV format and then using SQL loader kind of tool to load it.

You can also use replication tools like- Oracle Golden Gate and other tools available in market.

Ispirer - Migrate PostgreSQL to Oracle

http://www.swissql.com/products/datamigration/data-migration.html

Thanks,

Abhi

2928666

Hi Mike,

Thank you for your reply.

Which one is the simplest and safest method for  Postgres to Oracle migration?

Regards,

Suresh.

2928666

Hi abhi,

Thank you so-much.

Can you please share more about  migration using Golden Gate.

Regards,

Suresh.

1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 3 2014
Added on May 30 2014
#sql-developer
11 comments
44,213 views