Thanks everyone who replied. Looks like there is no one-fits-all solution for the problem we are trying to solve. Considering our requirements, and version of the database, I am more inclined to TTS-based solution for large schemas and just keep using export/import for small ones (or those that share tablespace). ~Mihajlo -- //www.freelists.org/webpage/oracle-l