Create Multiple table

[kv444]

Hi,

Could some one please tell me how to create a script in oracle to create multiple tables (more than 100 tables). I want to write a script because i will be re-using the script very often.



Thanks for your help in advance.

 

[LKBrwnDBA]

Just put one create table after the other in the script and in the sequence you need.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[Dagon]

There is also the "Create Schema" command (which doesn't actually create a new schema, despite the name).