Re: Large exports on NT

Moving a 4gig database from one server to another ( on the same os platform) via export/import is a rather long and dba involved process. Assuming that you want to remain on the same or higher version of Oracle, you can try compressing the oracle database files (datafiles, controlfiles & redo logs) and copying over to the new machine and uncompressing (for faster tranfer over slow lans). Using an "alter database backup controlfile to trace;" tracefile from the old database you can modify the trace (to point to the new locations of the datafiles, if they have changed) and run it as sys on the new machine. This I think would be much faster than export/import. Remember to set up the Oracle services and init.ora file before you attempt to startup the database.
Tell me what are your thoughts.
Allan.

P.S if you are moving to a higher version of oracle you will have to migrate the database.
----- Original Message -----
From: "Smith, Ron L." <rlsmith_at_kmg.com>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, November 10, 2000 9:35 AM
Subject: Large exports on NT

> I need to move a 4G database from one NT server to another. On Unix there
> is a 2G limit on file sizes. Is the same limit true on NT or can I just
do
> a full export and import?
>
> Ron Smith
> Database Administration
> rlsmith_at_kmg.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Smith, Ron L.
> INET: rlsmith_at_kmg.com
>
> 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: ListGuru_at_fatcity.com (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).
Received on Fri Nov 10 2000 - 09:12:37 CST