I am creating a script file to install an Oracle schema and its associated objects. As I am new to this, I would appreciate some direction on how this is normally done.<BR>Here is how I am doing it. I have a .sql file containing statements to create and populate the various database objects. User-configurable parameters are marked with % signs, so they can be searched and replaced with the appropriate values. Once this is done, I copy and paste the file into SQL worksheet and execute it.<BR>However, I am sure there must be a better way of doing this, especially accepting user input. Hence this posting.<BR>Thanks in advance.