Re: import issue
- From: "fitzjarrell@xxxxxxx" <fitzjarrell@xxxxxxx>
- Date: 27 Apr 2007 09:25:04 -0700
On Apr 27, 10:38 am, sam <samuel_st...@xxxxxxxxxxxx> 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
.
- Follow-Ups:
- Re: import issue
- From: sam
- Re: import issue
- References:
- import issue
- From: sam
- import issue
- Prev by Date: REGEXP_like
- Next by Date: Re: Syrnad admits he is a moron
- Previous by thread: import issue
- Next by thread: Re: import issue
- Index(es):
Relevant Pages
|
