Importing Data to DB with Added tables / columns

From: Michael <michael.dietz_at_gmx.de>
Date: 9 May 2004 21:02:21 -0700
Message-ID: <e92fb27e.0405092002.7e923644@posting.google.com>

I apologize if this might be a beginner question, which is clear to the experts. But I could not find a clear answer yet.

I have extracted a schema / user with the exp utility. I want to import it into a schema / user of a different Oracle server. Tables structures etc. are more or less the same. However, there are a few ADDITIONAL COLUMNS AND TABLES in the target database (no columns or tables have been removed though).

Can I use imp to transfer the data or do I have to use a different tool (e.g. SQL loader). I am afraid that the process might be a bit more complex and significantly slower (we are talking about approx. 1GB of data).

I am also thinking of importing the schema / user with the old structure and then run a few scripts to update the table columns etc. afterwards. Is this a viable approach or are there any concerns?

Thanks!

Mic Received on Sun May 09 2004 - 23:02:21 CDT