Re: Suggestion on moving large amount of data from two databases

From: Howard J. Rogers <howardjr_at_www.com>
Date: Sun, 7 Jan 2001 07:43:47 +1100
Message-ID: <3a578385@news.iprimus.com.au>

Version?

If 8i and above, transportable tablespaces may save your bacon: it's simply an export of the metadata for a tablespace (hence very small and very quick), and you simply copy the appropriate datafile(s) from A to B and then run import using the metadata dump file. Get's 10Gb of data across to database B in the time it takes you to do an O/S copy of the relevant dbf's.

Regards
HJR "Jimmy" <anonymous_at_anonymous.com> wrote in message news:3A5852BD.610C3ABA_at_yahoo.com...
> HI all,
>
> I have two databases A and B (two identicial databases, but with
> different sizes). Database A has about 50-70G data files. Database B has
> about 20G data files. I want to transfer data (about 10G) from A to B on
> daily basic. What are the efficient ways of doing this? We cannot alter
> any structures in database A since this database is provided by another
> company. We can only do export on this database.
>
> Thanks,
> David
Received on Sat Jan 06 2001 - 14:43:47 CST