Re: Tool needed: getting data out of the database NOT using EXPORT

Is this a one time deal, i.e. an upgrade? If so, doing an Oracle migration might be faster but still takes time. Also, the versioning might be a problem. You'll need to check. If it's moving data regularly, Oracle8i has functionality like transportable tablespaces which might help. I've never done it but sounds like it might help. If the databases were the same version there are other options like backing up the database online and restoring the database to another server (as a whole). I don't know the details - hard to comment.

In regards to export, have you used the direct=y option? My experience it improves speed. Also, to separate drive on database server from database files helps.

Chris

"Alex Filonov" <afilonov_at_pro-ns.net> wrote in message news:92fo97$f71$1_at_nnrp1.deja.com...
> I'm afraid that the fastest way would be to upgrade your database. I
> don't remember if you can upgrade directly to 8.1.6 from 7.3.3, but you
> sure can do it going to 8.0.5 first.
>
> In article <92ed9i$eco$1_at_slb6.atl.mindspring.net>,
> "Thomas Rudy" <tdrudy_at_ix.netcom.com> wrote:
> > All,
> >
> > Does anyone know of a stable and fast tool that can get data
 logically
> > out of the
> > database without using EXPORT? We need to pull the data out of a
 7.3.3.6
> > Solaris
> > database consisting of about 500G of data and put it into an 8.1.6/8.1.7
> > database.
> > EXPORT is too slow (even on extremely fast systems) as this database
> > supports an OLTP application
> > and must be available to users with minimal downtime. We looked at
 one tool
> > but it was not stable and could not handle the data fast enough.
> >
> > Appreciate any help you may be able to give on the tool.
> >
> > Thanks,
> >
> > Tom
> >
> >
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Dec 28 2000 - 16:34:53 CST