export/import

From: Michael Wolfe <mwolfe_at_cybercom.net>
Date: 1998/02/09
Message-ID: <6bm2v4$ll4$1@lator.cybercom.net>#1/1

i have an oracle export/import question.

running oracle on sun solaris 2.6.

we have a database on machine A that has a slightly different schema then on a machine B. the data on machine A is out of date. what i would like to do is the following:

machine A:

delete database
delete schema
delete data files
create new schema that matches machine B
import a subset of the tables on machine A that will be exported from machine B

so , essentially i want to create create a 'shell' envirnment on machine A that matches machines B schema and load a subset of the tables from B with the data.

hope, some of you can help.

regards, michael Received on Mon Feb 09 1998 - 00:00:00 CST