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
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