Thread: How can I export / import the tables from one database to another

How can I export / import the tables from one database to another database? Both databases are same only (Oracle 10g), But different host?
Can anyone help for me?

For this u have two options

1.using export/import.

U need to export from one database and import into another.

2.U can use DBLINK that connects to both the databases.

create database link linkname connect to 'username' identified by 'password' using 'hostname';
using this u can connect to a db and use the tables