On Apr 27, 1:25 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> 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/s...
>
> and start reading.
>
> David Fitzjarrell
...
If we could use data replication we will not be stucked in this
process...
but the source db it is from another vendor, and replication is out of
question, for many (non-technical) reasons.... they will only provide
a dump for us and nothing else, no modifications on their structure by
our request of any kind
Received on Fri Apr 27 2007 - 12:02:59 CDT
