Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Suggestion on moving large amount of data from two databases
"Jimmy" <david_petit_at_yahoo.com> wrote in message
news:3A58B89C.3A90074C_at_yahoo.com...
>
>
> I am using 8.0.6 on Solaris 2.6. So is there any ways to do this?
>
No. 8.1.5 and above have the transportable tablespace feature. Anything earlier, and you are going to have to do a conventional export and import (which is going to take time)
Regards
HJR
>
> "Howard J. Rogers" wrote:
> >
> > 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 Sun Jan 07 2001 - 18:13:18 CST