Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> import issue
I receive a dump of a schema from an external db and I got to import
it on my db. This have to be done on a daily basis.
Problem: There are objects on the dump specifically mapped to various
tablespaces, that did not exists on my db, and when I do the import
with the 'fromuser' 'touser', it does the imp from some objects,
mapping them from the default tablespace of the user on my db, but it
fails on the tables with *lobs...
The first thing that come to mind is use an indexfile, create the
structure and then perform the import, 'but' as this have to be
performed on a daily basis, it could lead to a big problem when
dealing with changes on the other side, this is a critical db and I
cannot risk to have an error on this imp due to a change made on the
structure of the other db...
Maybe I am missing something, I made a workaround here, but id there
some 'correct' way of doing that?
Received on Fri Apr 27 2007 - 10:38:47 CDT