>>> [EMAIL PROTECTED] 08/16/01 09:18AM
>>>
Alex,
It's tough to guess how long an import will
take. It all depends on how
many indexes and constraints you have -
these are what take the most time at
import time. The data gets
sucked in real fast. Using Direct Load really
speeds the import up
but, again, rebuilding the indexes takes forever.
Gene is correct in
that export is extremely fast.
Tom Mercadante
Oracle Certified
Professional
-----Original Message-----
Sent: Wednesday, August
15, 2001 7:01 PM
To: Multiple recipients of list ORACLE-L
Alex -
you must be joking, 60hrs? i get ~1gb/3mins for export. i
haven't
done an import lately, but its not that bad. exp/imp are
great tools to
move data around.
gene
>>>
[EMAIL PROTECTED] 08/15/01 06:08PM >>>
exp/imp does
not work(takes too much time)for large databases. How long do
you think
import will take for 200G database? - about 60 hours?
Alex
Hillman
-----Original Message-----
Sent: Tuesday, August 14, 2001
5:03 PM
To: Multiple recipients of list
ORACLE-L
Rachel,
I can see what he is
proposing, but I'm not sure anyone would care. I
know
I can't take
the datafiles from one of our HP-UX servers and use them to
create
a
database on NT for instance. Wish I could for our Support Magic
junk. In
that case they do a bunch of things (like create objects) as
SYS which never
get
included in an export. The problem that I see
is that there is a toolset
that
currently exists, namely export &
import, that work cross platform with no
problems. Just not at the
datafile level. And although that type of tool
would
be
interesting to me it would not be of much value since I've only the
one
problem.
Dick Goulet
____________________Reply
Separator____________________
Author: "Rachel Carmichael"
<[EMAIL PROTECTED]>
Date:
8/14/2001 12:41 PM
it doesn't sound like an ftp type tool. If I am
reading this correctly, he
is proposing to provide a tool that copies
datafiles directly from one OS to
another.
While this is an
interesting trick, I'm not sure there's a large market for
it.
>From: Scott Shafer
<[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To:
Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
>Subject: Re: Datafile Migration
Tool
>Date: Tue, 14 Aug 2001 12:00:53 -0800
>
>Not to be a
smartass, but don't most OS's already have ftp built in?
>What kind of
value-added are you proposing? Just curious...
>
>Scott
Shafer
>San Antonio, TX
>
>
>K Gopalakrishnan
wrote:
> >
> > Hi ,
> >
> > Will there be
a market if I give a tool which migrates Oracle database
> > from One
OS to another OS. (Data file migration at Operating System
> >
Level.)
> >
> > i.e it will convert from Oracle data
files on NT to Oracle Datafiles
> > on Solaris and vice versa.
In the target database you need to recreate
> > the control files and
you are done. You can startup the database. You
> > don't need to
export/import or CTAS over dblink..
> >
> > Send your
replies directly to me..
> >
> > Thanks Yong..for bringing
the cat out of the basket ;)
> >
> > =====
> > Have
a nice day !!
> >
------------------------------------------------------------
> > Best
Regards,
> > K Gopalakrishnan,
> > Bangalore,
INDIA.
>
>_________________________________________________________
>Do
You Yahoo!?
>Get your free @yahoo.com address at
http://mail.yahoo.com
>
>--
>Please see the official ORACLE-L FAQ:
http://www.orafaq.com
>--
>Author: Scott Shafer
> INET:
[EMAIL PROTECTED]
>
>Fat City Network Services
-- (858) 538-5051 FAX: (858) 538-5051
>San Diego,
California -- Public Internet access
/ Mailing
Lists
>--------------------------------------------------------------------
>To
REMOVE yourself from this mailing list, send an E-Mail message
>to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the
message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of
mailing list you want to be removed from). You may
>also send the
HELP command for other information (like
subscribing).
_________________________________________________________________
Get
your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com --
Author:
Rachel Carmichael
INET: [EMAIL PROTECTED]
Fat City
Network Services -- (858) 538-5051 FAX: (858)
538-5051
San Diego, California --
Public Internet access / Mailing
Lists
--------------------------------------------------------------------
To
REMOVE yourself from this mailing list, send an E-Mail message
to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message
BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing
list you want to be removed from). You may
also send the HELP command
for other information (like subscribing).
--
Please see the official
ORACLE-L FAQ:
http://www.orafaq.com --
Author:
INET: [EMAIL PROTECTED]
Fat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051
San
Diego, California -- Public Internet
access / Mailing
Lists
--------------------------------------------------------------------
To
REMOVE yourself from this mailing list, send an E-Mail message
to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message
BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing
list you want to be removed from). You may
also send the HELP command
for other information (like subscribing).
--
Please see the official
ORACLE-L FAQ:
http://www.orafaq.com --
Author: Hillman, Alex
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051
FAX: (858) 538-5051
San Diego,
California -- Public Internet access
/ Mailing
Lists
--------------------------------------------------------------------
To
REMOVE yourself from this mailing list, send an E-Mail message
to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message
BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing
list you want to be removed from). You may
also send the HELP command
for other information (like subscribing).
--
Please see the official
ORACLE-L FAQ:
http://www.orafaq.com--
Author: Gene Sais
INET: [EMAIL PROTECTED]
Fat
City Network Services -- (858) 538-5051 FAX: (858)
538-5051
San Diego, California --
Public Internet access / Mailing
Lists
--------------------------------------------------------------------
To
REMOVE yourself from this mailing list, send an E-Mail message
to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message
BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing
list you want to be removed from). You may
also send the HELP command
for other information (like subscribing).
--
Please see the official
ORACLE-L FAQ:
http://www.orafaq.com--
Author: Mercadante, Thomas F
INET:
[EMAIL PROTECTED]
Fat City Network Services --
(858) 538-5051 FAX: (858) 538-5051
San Diego,
California -- Public Internet access
/ Mailing
Lists
--------------------------------------------------------------------
To
REMOVE yourself from this mailing list, send an E-Mail message
to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message
BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing
list you want to be removed from). You may
also send the HELP command
for other information (like subscribing).
