Dear friends i have a database in oracle 9i in my pc.Iwant to transport this data to another machine how i can do it.where the oracle engine stores the data tell me the path. and how i can bring this data so that it works fine on another machine where i need to place that data.And is it necessary that the Oracle should be installed on that machine or we can combine that data with another database.please give a full description to me.
Amardeep, The easiest way to move data is to export it and then import it into the new database. If the target database is Oracle, you can use an Oracle export. If the target database is not Oracle, you can export in CSV (comma delimitted) format. In this case, the table needs to exist in the target database.