database mounted
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/26/2012 13:28:51
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary file name /oracle/app/oradata/oas/oas.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/oradata/oas/users01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/oradata/oas/undotbs01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/oradata/oas/sysaux01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/oradata/oas/system01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/flash_recovery_area/OAS_REP/onlinelog/o1_mf_10_7xgyw7gg_.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/flash_recovery_area/OAS_REP/onlinelog/o1_mf_9_7xgyw6h6_.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/flash_recovery_area/OAS_REP/onlinelog/o1_mf_8_7xgyw5hl_.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/flash_recovery_area/OAS_REP/onlinelog/o1_mf_7_7xgyw4jj_.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/flash_recovery_area/OAS_REP/onlinelog/o1_mf_6_7xgyw3kt_.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/flash_recovery_area/OAS_REP/onlinelog/o1_mf_5_7xgyw2kn_.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/flash_recovery_area/OAS_REP/onlinelog/o1_mf_4_7xgyw1o6_.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/oradata/oas/redo03.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/oradata/oas/redo02.log conflicts with a file used by the target database
RMAN-05001: auxiliary file name /oracle/app/oradata/oas/redo01.log conflicts with a file used by the target database
When i am trying to run below commond on oracle table where we need to change Varchar2 to date DATA type for resp column:
insert into evaluation_new (CREATEDDATE)
(Select To_date(CREATEDDATE,’yyyy-mm-dd hh24:mi:ss’)
from evaluation_detail);
Error:
ORA-01830: date format picture ends before converting entire input string
01830. 00000 – “date format picture ends before converting entire input string”
*Cause:
*Action:
(Note: Old str of column “2009-09-16 18:38:00.000”)
Via Sql loader i loaded one sql server table data in Oracle by changing the datatype to varchar2 , Now i want to change as it is, so how to write Procedure for the same by which i can changed the data type of oracle Table? ( I was facing problem in date format so i changed it to varchar, then all data loaded proprly appx 140524 rows)