How to transfer our data(of oracle) from one computer to another ?

Replies

• 

  Ankita Katdare

  @mohit: We can export data in mysql and use the .sql file on another computer.
  
  I hope I got your question right.
• 

  Morningdot Hablu

  @AKD are you sure because i have tried this.I created many tables in a database named mysql.Then copied my mysql folder from "F:\mysql\data" and paste it on the other computer data dir.But still i am not able to access the tables(datas).
  .
  Please do some fast reply friends.Tomorrow i have to submit my web app cd.
• 

  Ankita Katdare

  What I mean't was, go to phpmyadmin> choose your database> select all tables> go to export option on top and press go.
  
  A .sql file of your project will be created. When you move to another computer, run the queries inside the .sql file in the phpmyadmin and you get the replica of the database within minutes.
• 

  Morningdot Hablu

  hmm thanks AKD for your help.
• 

  slashfear

  Hi Mohit,
  
  Ok so you wanna transfer the data from Oracle table to another oracle table right ? use export and import commands in oracle which allows you to export the data from an oracle database and import for importing the datas to an oracle database. but make sure you have the same user name and password for both the oracle databases because the ownership of the table is also copied when you use export or import option.
  
  If you want any more help on command please feel free to ask!! 😉
  
  -Arvind
• 

  Prasad Ajinkya

  Mohit, if its mysql you are looking for, then simply use mysqldump.
  
  If you are thinking about migrating tablespaces from one db to another (mysql to ora), then either you use some plug-in for data importing in oracle or you export everything in .sql format.