DSXchange

Hi,

I have a stage Oracle witch create a table in replace mode. I want to create 2 index on this table after it was created.

I succeed in create one index in Close command but no more.

Is it possible to do that.
Remark : I don't want to write the Create table SQL statement, just index statements.

thanks,
Martin.

Do you want to do this many times or just once?

If many times, why not assemble the CREATE INDEX statements into a stored procedure and execute that?

Otherwise, how have you attempted to execute multiple statements? Have you tried terminating the first one with a double semi-colon (";;")?