Hi Techies,
I know EM has the functionality to generate create scripts, but I am in need of a script to run from the command line.
I need to automatically generate create index scripts each time a new table is created on my replicated server. I create a new table each time the old table reaches 1 million records and then drop the indexes. Because the check constraint "range" changes on the new table each time, I need to generate the index script to contain this new range before I drop the indexes. Basically this is for my partitioned views.
Anyone have a script to generate "create index"?
I know EM has the functionality to generate create scripts, but I am in need of a script to run from the command line.
I need to automatically generate create index scripts each time a new table is created on my replicated server. I create a new table each time the old table reaches 1 million records and then drop the indexes. Because the check constraint "range" changes on the new table each time, I need to generate the index script to contain this new range before I drop the indexes. Basically this is for my partitioned views.
Anyone have a script to generate "create index"?
