Re: Importing only certain fields? -Oracle8i Database

From: Paul Drake <paled_at_home.com>
Date: Sat, 23 Feb 2002 17:17:15 GMT
Message-ID: <3C77CF1A.5090708@home.com>

blacklightuv_at_hotmail.com wrote:

> I am trying to import an Oracle8i database to our new database, but we
> have changed certain fields (from String to Date format). I was
> wondering if there's any way to just import certain fields from the
> old database into the new one? Or does import automatically entail
> that all fields are imported?

yes.

use staging tables.
examine the parameters
FROMUSER, TOUSER
and import the objects into another schema (no indexes, no constraints) and then insert/update what you need from the imported data.

hth,

Paul Received on Sat Feb 23 2002 - 11:17:15 CST