If you are on 10g or higher you could use datapump to extract only the views (using the include parameter). And then import it into the other database. Freek D'Hooge Uptime Oracle Database Administrator e-mail: freek.dhooge@xxxxxxxxx tel. +32 (0)3 451 23 82 http://www.uptime.be disclaimer -- //www.freelists.org/webpage/oracle-l