Can anyone guide me whether it is ok to combine physical sturcture- table,index,trigger,sequence, synonym and constraint under one create script. I mean can we declare all these under create table scripts for a db instance
a script is a script is a script, the database doesnt care whats in it
what angle are you coming from here?
I worked at a place where the ddl for every database was in a separate file, separated by directory. Tables in onw directory indexeses in another. so that when something was checked into version control it would be easier for people who didn't understand Oracle could see what was changed. They did a lot of other things that didn't make any sense as well. I think that it can make sense to break out user creates and grants, from tablespace, from indexes and table from stored procedures, functions and packages. But it really depends on the kind of ddl that you are keeping.