Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

import.export of dependant data

0 views
Skip to first unread message

male...@my-deja.com

unread,
Nov 28, 2000, 3:00:00 AM11/28/00
to
I have to migrate data from one server to another (both 8i) but I
cannot simply take a whole table one at a time. My problem I am having
is that child data is not carried with the import. So say for example
I want to import a customer table with their addresses being in another
table. When I export the customer table, the addresses may be tied to
say rows 1,2,3 for customer 5. When this record is imported to the new
database, the parent-child relationship is either wrong or missing
since address records 1,2,3 may or may not exist in the second
database. Is this a clear example? So what I am saying is, does
Oracle import/export have a way of preserving the data in a parent-
child relationship without doing the entire database?

Thank you kindly,
Larry Geller
Database Specialist


Sent via Deja.com http://www.deja.com/
Before you buy.

Sybrand Bakker

unread,
Nov 28, 2000, 3:00:00 AM11/28/00
to
If I am not mistaken the last question should end in 'table' instead of
database, as you state 'I cannot simply take a table at one time'
My first remark would be : if you are using commit=y, there are to my
knowledge no tables you can export/import only partially. So any
clarification with respect to your issues would be welcome.
Other than that you could of course precreate the affected tables in the
target database and disable the constraints, enabling them only after
import.

Hth,

Sybrand Bakker, Oracle DBA

<male...@my-deja.com> wrote in message news:900hab$qia$1...@nnrp1.deja.com...

male...@my-deja.com

unread,
Nov 28, 2000, 3:00:00 AM11/28/00
to
I was hoping for something smoother than doing a lot of data massaging
since it could potentially be a lot of information. The example I gave
was just a small one. Thanks.

In article <900kd0$5ss85$2...@ID-62141.news.dfncis.de>,

Kjell Tore Nannestad

unread,
Nov 28, 2000, 3:00:00 AM11/28/00
to
I guess you have created the objects before the import.
Drop all objects and run an import of all objects in one run.
The constraints are added in the last phase of the import so you
shouldn't have any problems.

Jonathan Lewis

unread,
Nov 28, 2000, 3:00:00 AM11/28/00
to

You do have the option to export a list of tables,
and using 'consistent = yes' to ensure that the
data exported is as consistent as the database
definitions allow it to be.

--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Practical Oracle 8i: Building Efficient Databases

Publishers: Addison-Wesley
Book bound date: 8th Dec 2000
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html

male...@my-deja.com wrote in message <900hab$qia$1...@nnrp1.deja.com>...

0 new messages