Hi Gurus
Here is an urgent problem to be solved. I got near about 225 tables and 85 views in a schema ABC. I want to create the same tables with out data in another Schema XYZ. I wrote a dynamic SQL like
SELECT 'CREATE TABLE ' || TNAME ||' AS SELECT * FROM ABC. '||TNAME|| FROM TAB WHERE EMPCODE=0;

but empcode is not there in all tables.so this statement doesn't work. I want to create all the tables similar to ABC schema. EXport and import wont work here, b'coz many of the tables has got default tablespaces in their definition itself. and this XYZ schema doesn't got quota on those tablespaces which ABC got. So give me some other solution please.
Both the schemas are in the same database ...


U R Earliest help is most appreciated ..
thanks in advance