You can re-run nid with REVERT option, then fix the tempfile and run it again with all files in the right place. Stefan On Nov 30, 2007 5:57 AM, Prasad <p4cldba@xxxxxxxxx> wrote: > All, > > while trying to change the dbname for a test db nid failed as I did not > have a temp file in proper location. and it started giving this error while > trying to create the tempfile. > > ORA-19951: cannot modify control file until DBNEWID is completed > > Is there anyway I can overcome this error. > > Please advise. > > thanks > -Prasad > > > -- ========================= Stefan P Knecht Consultant Infrastructure Managed Services Trivadis AG Europa-Strasse 5 CH-8152 Glattbrugg Phone +41-44-808 70 20 Fax +41-808 70 12 Mobile +41-79-571 36 27 stefan.knecht@xxxxxxxxxxxx http://www.trivadis.com OCP 9i/10g SCSA SCNA =========================