Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: import issue
On Apr 27, 10:38 am, sam <samuel_st..._at_yahoo.com.br> wrote:
> 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?
This appears to be a good candidate for a Streams implementation, rather than your exp/imp scenario. Go here:
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14229/strms_over.htm
and start reading.
David Fitzjarrell Received on Fri Apr 27 2007 - 11:25:04 CDT