Hello,
I am having major Oracle 10g issues. I'll try to give a brief and succinct synopsis of what has happened to date.
1. A database instance was able to be successfully created, and was populated with data, schemas, triggers, constraints, etc.
2. The database was successfully exported.
3. A second database instance had been inadvertently created with a conflicting schema name. The individual created it from a close of the initial database instance.
4. I had to remove the conflicting schema, unaware that it was made from a clone.
5. As a result of removing the conflicting schema, the database templates for the initial schema were removed, most notably the SPFILE{schemaname}.ORA.
6. I tried recreating the SPFILE{schemaname}.ORA from another schema for this schema, to no avail, because it gave error messages about the database not being mounted in one case, and in another case, the logical block size not matching. Ultimately, the recreation of the .ORA file did not work,
7. Since I had successfully exported the database last week, I tried to create a brand new database (which was done successfully), and import the export file (which I had done successfully last week), but this did not work.
8. The error messages that I am getting when attempting to import from export file via the Enterprise Manager, are as follows:
Import Submit Failed
Errors: ORA-39006: internal error Exception : ORA-39006: internal error ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79 ORA-06512: at "SYS.DBMS_DATAPUMP", line 2926 ORA-06512: at "SYS.DBMS_DATAPUMP", line 3162 ORA-06512: at line 2
Additionally, when I viewed the IMPORT.LOG, the following was found:
ORA-39097: Data Pump job encountered unexpected error -44003
ORA-39065: unexpected master process exception in FILE
ORA-44003: invalid SQL name
9. I also got this same error:
Export Submit Failed
Errors: ORA-39006: internal error Exception : ORA-39006: internal error ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79 ORA-06512: at "SYS.DBMS_DATAPUMP", line 2926 ORA-06512: at "SYS.DBMS_DATAPUMP", line 3162 ORA-06512: at line 2
when trying to export a database from another server. I have no idea what is going on.
Can someone please help? Any help or assistance would be greatly appreciated.
Thanks in advance!
