Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    New to the CF scene
    Join Date
    Jul 2009
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to move tables in Oracle 10g from one pc to another

    Hiii Everbody...

    Please can anybody tell me that How can I move
    my Tables and all datafiles in Oracle 10g from one pc
    to another.

  • #2
    Senior Coder ckeyrouz's Avatar
    Join Date
    Jun 2009
    Location
    Montreal, Canada
    Posts
    1,044
    Thanks
    5
    Thanked 179 Times in 179 Posts
    You can just export a DMP from the first pc and then import it to the second PC.

  • #3
    New to the CF scene
    Join Date
    Jul 2009
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by ckeyrouz View Post
    You can just export a DMP from the first pc and then import it to the second PC.
    Please can u be specific about which file
    will it contain all the tables ???.....
    Please do reply...

  • #4
    Senior Coder ckeyrouz's Avatar
    Join Date
    Jun 2009
    Location
    Montreal, Canada
    Posts
    1,044
    Thanks
    5
    Thanked 179 Times in 179 Posts
    No one knows where Oracle stores data.
    You cannot just copy the files and paste them somewhere else to move the tables.

    You should export all your database from one pc then go to another pc and import your database.

    You can refer to this page and check how you can do the export/import thing:
    http://www.orafaq.com/wiki/Import_Export_FAQ

  • #5
    Banned
    Join Date
    Oct 2009
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re:

    The post is really a very informative one. But in my opinion the best way to gain basic knowledge is a book. I’m having a book on OLAP which contains great tips for beginner as well as advanced users. The book is available on Amazon & you can buy an e-book directly from the publisher by writing OLAPWorldPress@gmail.com.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •