Yes I know you gave me the answer. But now I want to know if i grant the second user the privileges to "Create any Materialized Views" and "Create any Tables" and then create the materialized view manually and then i import the database from one schema to the other. Does it work? I have to explain this to the DBA before he can grant the desired permissions to the user. (you see he is a little more difficult :P)