I want to change my DB name in Oracle. I am using this command:
nid TARGET=SYS/welc0me12$@CSPROD DBNAME=CSGOLD SETNAME=Y
After that I am getting an error:
Datafile E:\APP\ADMINISTRATOR\ORADATA\CSPROD\SYSTEM02.DB - wrote new name ID-00111: Oracle error reported from target database while executing begin dbms_backup_restore.nidprocessdf(:fno, :istemp, :skipped, :idchg d, :nmchged); end; RA-20000: File E:\APP\ADMINISTRATOR\ORADATA\CSPROD\TEMP01.DBF has wrong dbid or dbname, remove or restore the offending file. RA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 6848 RA-06512: at line 1 hange of database name failed. ust finish change or REVERT changes before attempting any database operation. BNEWID - Completed with errors.