script question

[sona]

hai i have created a script in which i create tables.

i will connect as internal to sqlplus and should run the script to create tables in another user's schema.

the script will be as follows

create table "&owner".table1(....)
/
create "&owner".table2(....)
/

actually i need to give the owner name input only once and this value has to be substituited for other
input owner variables also.What should i do.

[hrishy]

Hi

Lookup substitution variables in sql plus.You should be using && instead of a single & in front of teh variable name.

somethin like

create table "&&owner".table1(....)

regards
Hrishy