Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed1.earthlink.net!newsfeed.earthlink.net!news.maxwell.syr.edu!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!news-west.rr.com!cyclone.austin.rr.com!cyclone.tampabay.rr.com!news-post.tampabay.rr.com!twister.southeast.rr.com.POSTED!53ab2750!not-for-mail From: "MercilessMing" Newsgroups: comp.databases.oracle.misc References: <2c196db8.0301280102.568067e3@posting.google.com> <2c196db8.0301290201.740ce2d6@posting.google.com> Subject: Re: Transferring databases Lines: 36 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Message-ID: Date: Sun, 02 Feb 2003 23:20:09 GMT NNTP-Posting-Host: 24.74.210.50 X-Complaints-To: abuse@rr.com X-Trace: twister.southeast.rr.com 1044228009 24.74.210.50 (Sun, 02 Feb 2003 18:20:09 EST) NNTP-Posting-Date: Sun, 02 Feb 2003 18:20:09 EST Organization: Road Runner - Columbia Xref: newsfeed1.easynews.com comp.databases.oracle.misc:92616 X-Received-Date: Sun, 02 Feb 2003 16:19:29 MST (news.easynews.com) You can copy all the files from the original database create a trace file from the controlfiles and past the files in the new database directory, rename the directory paths in the trace file and rename the trace file to .sql run it and run the alter database resetlogs command and you should be fine. This method has worked for me if you need more of a step by step and want to do this method let me know....many in this group helped me do this, in this manner and it appears to be working fine so far. "Brian E Dick" wrote in message news:EFRZ9.53415$GX4.2081924@news2.east.cox.net... Can you shutdown briefly during the cut over? "Jackie" wrote in message news:2c196db8.0301290201.740ce2d6@posting.google.com... > Oracle version and OS will be the same: Oracle 8i on Win 2000 Server. > Only the hardware will be changed. > Database size is 1gb approximately. > > "Brian E Dick" wrote in message news:... > > Here's a different spin on a common question. What is your target Oracle > > version and OS? > > > > "Jackie" wrote in message > > news:2c196db8.0301280102.568067e3@posting.google.com... > > > Hi! > > > We are using Oracle 8i running on Windows 2000. We are planning to buy > > > a new, more powerful server and transfer our database to this new > > > system. What is the best way to achieve this transfer process? We will > > > install a fresh copy of Oracle to the new server and import existing > > > data from old server. Is export-import enough or a different procedure > > > should be followed? > > > > > > thanks.