This discussion is archived
1 Reply Latest reply: May 16, 2013 5:53 AM by TurlochO'Tierney RSS

nube here: trying to copy a db from 1 comp to 2nd using Oracle SQL dev

1008364 Newbie
Currently Being Moderated
Hi, nube here. I am trying to copy SQL database established locally on my laptop and copy it to my desktop pc so i can practice running queries on there. I have tried to migrate and i failed. i have the password for the schema created on my laptop.

now am i trying to create a new schema on my desktop? or do i copy the schema also? i am also unable to pass the "test connection" when i create any new schema on my desktop.i share the same home network. these are merely just practice databases so i can practice on my desktop as well as my laptop. And what do you mean on the same domain? do you mean create exact same schema on my desktop? and am i using RMAN to backup and restore? or what tool because google says its not possible to back up and recover viz oracle sql developer.

I am using orcle sql developer verison 1.5.3 on my laptop and ver 3.2.20.09 on my desktop.


please help
  • 1. Re: nube here: trying to copy a db from 1 comp to 2nd using Oracle SQL dev
    TurlochO'Tierney Journeyer
    Currently Being Moderated
    Hi Nube,

    Update to 3.2.20.09 on your laptop.

    For between non Oracle databases and Oracle:
    There is right click on a table "Copy To Oracle".
    Migration getting started:
    http://www.oracle.com/technetwork/database/migration/omwb-getstarted-093461.html

    [for between Oracle databases there is a Data Pump wizard in the DBA view,
    also database copy, or even copy command in the worksheet,
    you could use RMAN for duplicating databases (or OS commands like copy(Windows)/cp(Unix/Linux) when the database is brought down with "shutdown immediate")
    RMAN and OS commards are outside the scope of the SQLDeveloper forum]
    i am also unable to pass the "test connection"
    Not sure what database you are connecting to
    - you need to get port/host and the equivalent of service right
    - firewall rules need to be set up if appropriate.
    - also the database server needs to be listening on that port.

    -Turloch
    SQLDeveloper Team

Legend

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