Application Designer is getting closed automatically when we build the records. Log file shows below error:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file ORA-01110: data file 201:
'/oradata/VRMSDV/pstemp01.dbf' ORA-06512: at "SYS.DBMS_LOB", line 664 ORA-06512: at "SYS.DBMS_METADATA", line 3825 ORA-06512: at "SYS.DBMS_METADATA", line 567
Failed SQL stmt: SELECT DBMS_METADATA.GET_DDL('TABLE',:1) from dual
Solution: Here problem is with the TEMP tablespace it either doesn't exist or doesn't have sufficien space. Create TEMP tablespace and try again to build it.
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file ORA-01110: data file 201:
'/oradata/VRMSDV/pstemp01.dbf' ORA-06512: at "SYS.DBMS_LOB", line 664 ORA-06512: at "SYS.DBMS_METADATA", line 3825 ORA-06512: at "SYS.DBMS_METADATA", line 567
Failed SQL stmt: SELECT DBMS_METADATA.GET_DDL('TABLE',:1) from dual
Solution: Here problem is with the TEMP tablespace it either doesn't exist or doesn't have sufficien space. Create TEMP tablespace and try again to build it.
No comments:
Post a Comment