OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Export/Import

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export/Import [message #72030]

Tue, 25 February 2003 08:12

Heimo König
Messages: 2
Registered: February 2003

Junior Member

Hello together,

Initial position: Oracle8i Enterprise edition release 8.1.6.0.0
two DB�s, production and test. Tables are alike on both
DB�s. In each table the columns are called differently. The
tables are consistently connected.

The problem: The test data bank is again to be filled up with data
from production. But only a small part. On a table a restriction is to
be made, which is the data of the other tables reduced and still
consistent.

Is there a possibility with the PL/SQL Developer Import/Export Tool?

What is the simplest method?

Thanks for the assistance.

Report message to a moderator

Re: Export/Import [message #72031 is a reply to message #72030]

Tue, 25 February 2003 08:54

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

are u looking to load data from DB1 to DB2 selectively?
Like only certain data ( like all employees workin as clerks ) to be loaded?

Report message to a moderator

Re: Export/Import [message #72037 is a reply to message #72030]

Tue, 25 February 2003 23:36

Heimo König
Messages: 2
Registered: February 2003

Junior Member

Yes...

Report message to a moderator

Re: Export/Import [message #72042 is a reply to message #72030]

Wed, 26 February 2003 05:30

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

you can use expport and import utilities.
use query option along with exp.
please followup with our other posting...deals with almost the same..
Other posting

Report message to a moderator

Previous Topic:	Oracle database copy
Next Topic:	Sql Loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 28 04:54:08 CDT 2025