-
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
PNRDBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|