Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

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

This is a discussion on How can I export / import the tables from one database to another within the Oracle forums, part of the Databases category; 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?...

Geeks Talk > Databases > Oracle How can I export / import the tables from one database to another

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   06-12-2007

Geek_Guest Expert Member   Join Date: Feb 2007 Posts: 1,279 Thanks: 0 Thanked 164 Times in 138 Posts

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?

The Following User Says Thank You to Geek_Guest For This Useful Post:

debasis15

Sponsored Links

#2 (permalink)   06-16-2007

debasisdas Moderator   Join Date: Jun 2007 Location: Bangalore,India Posts: 1,432 Thanks: 8 Thanked 126 Times in 113 Posts

Re: How can I export / import the tables from one database to another 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.

#3 (permalink)   07-30-2007

suneelgopavaram Junior Member   Join Date: Jul 2007 Posts: 8 Thanks: 0 Thanked 1 Time in 1 Post

Re: How can I export / import the tables from one database to another create database link linkname connect to 'username' identified by 'password' using 'hostname'; using this u can connect to a db and use the tables

Geeks Talk > Databases > Oracle

« Features and difference between Oracle products | Inserting column in existing table »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Export 'All testcases at a time' from Mercury Quality Center	Geek_Guest	Quality Center	5	09-23-2008 04:36 PM
What is need to import java.awt.event.*	Geek_Guest	Java	1	05-29-2007 05:29 AM
Tables names of a database in a combo box	yogeesh R	VB.NET	1	04-09-2007 07:54 PM
Base tables for Journal Import	Geek_Guest	Oracle Apps	1	03-03-2007 10:31 PM
WebSphere V5.0 : Import and export	Lokesh M	Web Tools	0	05-27-2006 07:26 AM

All times are GMT -4. The time now is 01:45 PM.