This discussion is archived
2 Replies Latest reply: May 16, 2013 6:05 AM by TurlochO'Tierney RSS

Import remote Oracle database schema using SQL Developer

1008371 Newbie
Currently Being Moderated
Hi , I want to copy remote schema (Database available on remote server where my application is hosted) to my local database. So that I can create replica of same that schema in local machine. I have view only user for remote schema. Do we have any option in SQL Developer to do this? Database copy option dint work probably because I have read only user.
Kindly advice.
Recently in javaone conference held in india I was told to post My query here.
  • 1. Re: Import remote Oracle database schema using SQL Developer
    Jim Smith Expert
    Currently Being Moderated
    In order of efficiency,

    1) If you have permission to copy the database, then the owners of the database should be able to you provide with an export file which you can import.
    2) Alternatively you can install the exp utility (Part of a full oracle client install) and create your own export file.
    3) You can create a database link inside your database connected to the remote database and copy tables using create table as...
    4) You can use the SQL Developer BRIDGE command to access remote table. It doesn't seem to be documented directly but there some help here
  • 2. Re: Import remote Oracle database schema using SQL Developer
    TurlochO'Tierney Journeyer
    Currently Being Moderated
    Hi,

    For individual Oracle to Oracle table transfer there is also the copy command in Sqlplus and SQL Developer see in SQL Developer worksheet: "help copy".

    Note: Data Pump is good for exporting data but you would need privileges or get your DBA to run the export - there is a wizard in the DBA view for both the export and import.

    -Turloch
    SQLDeveloper team

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points