By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,667 Members | 2,255 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,667 IT Pros & Developers. It's quick & easy.

Importing Data to DB with Added tables / columns

P: n/a
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
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.