Home » RDBMS Server » Backup & Recovery » Error while taking backup of the Database
Error while taking backup of the Database [message #112608] Mon, 28 March 2005 04:36 Go to next message
thomas_29
Messages: 2
Registered: March 2005
Junior Member
Dear All


I am getting error while exporting. The error message is
EXP-00056: ORACLE error 31600 encountered

ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TRANSFORM_PARAM

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105

ORA-06512: at "SYS.DBMS_METADATA_INT", line 3926

ORA-06512: at "SYS.DBMS_METADATA_INT", line 4050

ORA-06512: at "SYS.DBMS_METADATA", line 836

ORA-06512: at line 1

EXP-00000: Export terminated unsuccessfully

Please can you tell me what could be the reason.
Tell me some solution for this. I am struck at this position. I am not able to take the backup of the database.


Thanks in advance

Thomson
Re: Error while taking backup of the Database [message #112621 is a reply to message #112608] Mon, 28 March 2005 05:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
check how many rows are there in the dual table;
sql> select * from dual;
post the results;
login as sys an run these scripts
@(ORA_HOME)/rdbms/admin/catalog.sql
@(ORA_HOME)/rdbms/admin/catproc.sql
try again
Re: Error while taking backup of the Database [message #112750 is a reply to message #112621] Tue, 29 March 2005 01:56 Go to previous message
thomas_29
Messages: 2
Registered: March 2005
Junior Member
Thanks a lot

Now I am able to take the database backup
Previous Topic: 8i RMAN Duplicate DB failure!
Next Topic: Issue about import and export database!
Goto Forum:
  


Current Time: Fri Mar 29 10:02:27 CDT 2024