recreate new control file.

[ams-jamali]

rey..same file works in sql prompt.But not in cmd.

[ams-jamali]

rey..if blank space is the actual problem it should not work when i copied and ran that script. but it works properly.but if i show the path to access that file it throws err.So what i suspect, if we give the path it will throw error
(in command mode).

[davey23uk]

you cant have blank lines in the script, that it the problem you were facing when it is saying unknown command DATAFILE

[ams-jamali]

ok.. davey. i will try that.

[ams-jamali]

ok.., Dave it is fine..,

Can any one give me actual algorithm about conrol file creation.i.e., When we run that script it should create one control file.But it creates three files.Does it refer pfile before running that create control file script.

[davey23uk]

whatever you have in your parameter file