| Errors exporting from 9i and import from 8i question... [message #120778] |
Mon, 23 May 2005 13:17  |
mikew5163
Messages: 3
Registered: May 2005
|
Junior Member |
|
|
Hi there,
I have just installed Oracle 9i on Win 2k (sp4). I installed 9.2.0.1 and then patched it to 9.2.0.6. All went ok with no errors or problems. Then I imported a dump file from an 8.1.7.0 database. The import went fine and the database seems to run ok.
When I tried to do a dump from the 9i db, I got the error saying my export views were not installed, so I ran catexp.sql - again all went ok with no errors (except one about a pre-existing role).
Now when I try to do an export from the 9i database, I get all sorts of nasty looking errors! Here's the command line output:
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 21779 encountered
ORA-21779: duration not active
ORA-06512: at "SYS.DBMS_AW", line 106
ORA-06512: at "SYS.DBMS_AW", line 222
ORA-06512: at "SYS.DBMS_AW_EXP", line 264
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_AW_EXP.schema_inf
o_exp
. exporting cluster definitions
EXP-00056: ORACLE error 31600 encountered
ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TR
ANSFORM_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-00056: ORACLE error 31600 encountered
ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TR
ANSFORM_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
Any clues as to what's wrong? Is there something I should have done to the database after I imported the 8.1.7.0 dump file to 'upgrade' it to 9.2.0.6? I didn't create the 9i db until after I had run the patchset, so I assumed that the new db would not need any kind of upgrading.
Any help greatly appreciated!
|
|
|
|
|
|
|
|
| Re: Errors exporting from 9i and import from 8i question... [message #120844 is a reply to message #120779] |
Tue, 24 May 2005 04:34  |
mikew5163
Messages: 3
Registered: May 2005
|
Junior Member |
|
|
Thanks Mahesh!
No, I didn't run catpatch.sql, as the readme file only talks about running this against existing instances in the oracle home you just upgraded. As I only created the instance after I ran the patchset, I assumed I would not need to run catpatch.
I did wonder if things might have 'regressed' by importing a 8.1.7.0 dump into my new instance, which is why I asked the second part of my question. So, as a further test, I have just created a completely new 9.2.0.6 database and tried an export without doing anything else (other than run catexp.sql which seems to be curiously necessary on every database!). I get exactly the same problems as before.
Thanks again - hope you can offer some further advice.....
|
|
|
|
| Re: Errors exporting from 9i and import from 8i question... [message #120883 is a reply to message #120844] |
Tue, 24 May 2005 08:16 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
the fact is,
when you export / import between different versions, the export/import views needs to be changed.
Use the lower version of exp to export from the source database.
Use the same lower version of imp to import into target database
else,
you need to install the export/import views by running the catexp.sql
if you run 8i version of imp/exp against 9i database, it will work good.
If you run 9i version of imp/exp against 8i database , it will not.
To make this work, you need to run catexp.sql found in 9i distribution against the 8i database.
I beleive, your requirement is to
import 8i data into a 9i database.
so,
1. install 9i
2. do the upgrade/apply patchsets.
3. create 9i database.
4. use exp from machine where 8i installed to export from 8i machine/database
use imp from machine where 8i is isntalled to import into 9i database.
if you want to run export/import from 9i machine,
from 9i machine first login as sys to 8i machine and run catexp.sql available in 9i installation.
now when export using 9i version of exp against the 8i machine it will work.
|
|
|
|
| Re: Errors exporting from 9i and import from 8i question... [message #120894 is a reply to message #120883] |
Tue, 24 May 2005 09:20 |
mikew5163
Messages: 3
Registered: May 2005
|
Junior Member |
|
|
Thanks again Mahesh,
I think you missed the point about my second post - I am getting these errors when I simply try to export from a brand new, untouched 9i database, using the 9i version of exp. All I did in this subsequent experiment was create a 9i database and run the version of catexp.sql from the 9i oracle home to ensure it had the export views in place. I didn't import anything in to it, nor make any modifications to the database.
You're right that my ultimate aim is to export a 8i database and import it successfully into 9i, but for the time being I'd like to just fix the 9i export problem!!
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
