Never heard it called that before (I've seen Silo used for lots of other concepts in IT but never in this particular way). Anyway back to your question, I'm still not sure why you want to use dbms_datapump rather than just impdp for this process - just using the command line makes for a far simple script i think?
All you need to do is wrap the impdp command in a standard shell script wrapper.
The impdp command would just need to be something like
In my company for performing schema refresh we are using expdp/impdp using dbms_datapump through network link .Since it uses n/w link it takes 8 to 10 hours to complete the refresh .
Now we shouldn't use n/w link and time should be decresed 4 to 5 hours and we are planning for another solutions like performing export only 1 time in source db and moving the dump file into respective boxes and then perform impdp using dbms_datapump have to use SILO concept to perform impdp.
I have wrote the script to perform export now i need to write the script to perform import using SILO concept and the SILO value should call trough shell script
How big is the schema? How far apart are the 2 servers? What exact version of oracle are you on? 8 to 10 hours sounds are very log time (unless we are talking hundreds of GB or TB of data) - most of the import time is usually index building rather than data copying - are you doing it in parallel?
We do a very similar thing where we import into one schema and then duplicate that out to other schemas in the same database using transportable tablespaces - this seems to be the quickest way to do schema duplication (and does allow for the schema name to be changed) - is that an option for you?
TTS works fine for lobs .
As long as the multiple tablespaces you're talking about only have relationships between each other and are not dependant on other tablespaces then you can do all of them as a set and it will work just fine. Just list the multiple tablespaces in the command. There is a routine to check if the tablespace grouping is valid or not (i.e. if they are missing dependencies of only they are copied) - you can find info on this here: