How to import oracle database from one PC to another.

Posted on 2005-05-05
Last Modified: 2012-06-27
Dear Experts,
Please give me suggestion how to import full oracle database from one machine to another machine.
Question by:Wasim_Haider
    LVL 24

    Accepted Solution


    use exp and imp commands as SYSDBA.
    exp to dump the database into a file.
    You can choose between  (E)ntire db , (U)sers and (T)ables.
    You will also be asked if you want to export more items like data, grants etc.
    Then copy the file between machines and import them (imp). ;)

    You can also use ExtractDLL on DB objects if you use SQLNavigator or TOAD to
    extract only the Schema or part of it (tables,views,packages, triggers etc).

      Tomas Helgi
    LVL 3

    Author Comment

    Thank you for valuable suggestion.

    The database service name is:
    user name: ad
    password: ad

    It has more than 30 tables, more than 90 procedures, views and triggers. pls give me suggestiong with exmple how to import all the database objects from one machine to another machine.
    LVL 24

    Expert Comment

    by:Tomas Helgi Johannsson

    Then you can run in command prompt
    exp ad@serv AS SYSDBA
    enter password
    enter the name of the file (default expdat.dmp)
    choose (1)E for entire database.
    and other choises as you want.

      Tomas Helgi
    LVL 5

    Expert Comment


    wht u hav e to do is just export from one machine and import it to other u can use many modes  ie user lavel ,table level or database level...

    follow this link


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video shows how to recover a database from a user managed backup

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now