473,554 Members | 2,229 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Re: How to duplicate whole database from one machine to another machine in Windows 2000?

Would you please what files I have to copy?

"Ban Spam" <ba******@opera mail.comwrote in message
news:Xn******** *************@6
"HK Chang" <RE************ ****@bigfoot.co mwrote in
news:as******** **@news.hgc.com .hk:
Dear All,

Do you know how I can duplicate the whole database from one Windows 2000
machine to another Windows 2000 machine?


HK Chang

I'd just use COPY when the database is shut down.

Jun 27 '08 #1
2 1135
If you are using a version of Oracle that is less than 8i, you could
follow the following steps..

1. Shut down the database services,
2. Copy the "dbs" and "database" folders within oracle installation
3. Re-start the services.

Remember the machine to be copied to should also have its services
shut down

Ideally, you have to copy only selected files from "dbs" and
"database", but I am not an expert at that and can just say that
copying all the files in the 2 folders - "dbs" and "database" used to
work for me.
If the database is very big ( approx 200MB) you will have to export
it though.

"HK Chang" <RE************ ****@bigfoot.co mwrote in message news:<as******* ****@news.hgc.c om.hk>...
Would you please what files I have to copy?

"Ban Spam" <ba******@opera mail.comwrote in message
news:Xn******** *************@6
"HK Chang" <RE************ ****@bigfoot.co mwrote in
news:as******** **@news.hgc.com .hk:
Dear All,
Do you know how I can duplicate the whole database from one Windows 2000
machine to another Windows 2000 machine?
HK Chang
I'd just use COPY when the database is shut down.
Jun 27 '08 #2
I should have mentioned it explicitly, but my technique was meant if
we want to hand over the task to a person not exposed to databases at
all, and we do not want to give him/her the SYS password also.
A few extra minutes spent copying for that person is sometimes better
than teaching him the intricacies.
Hi Laxman,

Handing over database migration tasks to someone who has not been
exposed to databases at all is asking for a *BIG* trouble. Practicing
Oracle on a home machine is much different then working with a
production instance in the real world.

If it is just a practice on a home machine...then no harm done, *BUT*
if it is a real world scenario...then let the DBA handle these kind of

/Rauf Sarwar
Jun 27 '08 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Xah Lee | last post by:
here's a large exercise that uses what we built before. suppose you have tens of thousands of files in various directories. Some of these files are identical, but you don't know which ones are identical with which. Write a program that prints out which file are redundant copies. Here's the spec. -------------------------- The program is...
by: Pawel Banys | last post by:
Hello, There is a program which performs some scripted actions via ODBC on tables in some database on mssql 2000. Sometimes that program tries to insert record with key that is already present in the database. The error comes up and the program stops. Is there any way to globally configure the database or the whole mssql server to ignore...
by: Saravanakumar | last post by:
Recently I have changed the VB Application for Authentication method to connect to the SQL Server 7.0 database using the Windows NT Authentication. Later I had created permissions for Select, Insert, Update, Delete, Exec everything based on the Windows NT Authentication on an Active Directory Group based. Now I am trying to use the...
by: Dave | last post by:
Hi folks I know just enough about MS-SQL to be dangerous, so feel free to warn me off this it's too much for a non-expert. We are using SQL 2000 as the back-end for website. We would like to create a duplicate of the database (on the same server). Then we'd use them like this: Database A: read-write DB accessed by web administrator
by: Andy J | last post by:
Hi Everyone NEW USER Q. I am trying to restore a database backup image to another machine. Both machines are installed with same DB2 7.2 installation package. Version: 7, Release: 2, Modification: 5, Service Level: WR21294 Querying the system... Windows 2000 Version
by: L Mehl | last post by:
I tested a FE/BE application developed in A2000 on a A2002 machine and got this message when exiting the app. Clicking the only available button "OK", exits the application, as intended. The FE is just the mdb, not an mde. FE and BE are in different directories on the same machine. Are there settings, preferably via code, that I can add...
by: Chris Williamson | last post by:
Hi, Currently I am working on a Visual Basic program that makes use of an Access database produced under Japanese Access '97. The program works correctly on Windows 2000, however when it is used under English XP, Visual Basic reports the error "Could not find file" when it tries to open the database. I have tried converting the...
by: Mike Hunter | last post by:
(Please CC me on any replies as I'm not on the list) Hi, After a recent power failure, a program that uses a pgsql backend (netdisco) started to send me nastygrams. I tried the author's suggestion of running a VACUUM FULL ANALYZE VERBOSE;, but it still sends me the messages. The data in the database isn't too important, i.e. I'm willing...
by: rpnew | last post by:
HI, I'm working with PHP/MySql... on one page i've used this XMLHttprequest object. Now i'm developing the system on FC4/FireFox.. on my machine it works fine but if i try to access it from another PC then following happens.... From another PC which has Windows XP/FireFox/IE with firefox(on my machine it works fine) it shows the whole...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.