Problem with Oracle script through command line - How to avoid Prompting for Time etc?

Question

Hi, I have taken a sql dump as script from Jdeveloper and trying to create database at other place by running the oracle sql script through command line. When executing, at some place in the script, it is prompting for values like "Enter value for time:" and "Enter Value for p:" what could be the reason and how to prevent this when taking dump. Thanks in advance.

-indra

Answer 1

Add this to the beginning of the scripts:

   set define off;

Your data probably contains the '&' character and it want to substitute input variables.