Re: Beginner over his head!

If they are networked, then what about this as an idea:

1. On the NT machine perform an export using sqlnet to get the data from the other machine. For example, if the tnsnames.ora entry on the NT machine has a tnsnames.ora of xyzzy for the database that is on the Win95 machine, open a dos window on the NT machine and enter the following: exp system/manager_at_xyzzy What this will do is ensure that the file in binary compatible with NT.
2. Use imp to import the data into the NT database.

If you don't mind the performance hit and you don't have a lot of complex constraints and indexes, then you could also just move the data into the tables directly with something along the lines of:

insert
into nt_table
select *
from win95_table_at_xyzzy

It won't be fast, but it will get the job done if the tables are empty.

I can think of several other ways of accomplishing what you describe but they tend to get into programmatic solutions and that may be more than what you need.

Ken

Mark Stepanek wrote:

> Hi,
> I have been running Personal Oracle 7.3.3 for about a year and a half now on
> my Win 95 machine as the database for a 3rd party software application. To
> be honest, I have had to do very little with PO7 as it has worked flawlessly
> since I installed it. I have run scripts to update and add new
> tables/constraints, etc. but all pretty minor stuff.
>
> Now I need to move the entire database to a new NT4.0 machine and am asking
> for a little advice how best to do it. With Oracle being Oracle, I don't
> suppose there would be a single button command to perform this would there?
> :) The Win95 and NT machine are networked together. Is it best in this
> case to re-install the PO7 on the NT then import all of my data from the
> existing database? The database is not very large as only I have been
> putting data into it. I though about just keeping it on the Win95 machine
> and running it from the NT machine but I really need to move up to the NT
> system for speed and storage reasons. Any help is much appreciated.
>
> Mark
Received on Mon Jul 05 1999 - 07:16:51 CDT