Home » RDBMS Server » Server Utilities » Export oracle 9 to oracle 10
Export oracle 9 to oracle 10 [message #74661] Tue, 01 February 2005 03:08 Go to next message
gioser
Messages: 2
Registered: February 2005
Junior Member
hi friends

when i am trying to export the full database i got a error message.
so i run the catexp.sql and after restarting the export i got this error and export terminated unsuccessfully.
i am using oracle 10 and windowsXP

Report message to a moderator

Re: Export oracle 9 to oracle 10 [message #74662 is a reply to message #74661] Tue, 01 February 2005 03:19 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
what error?
post the exact error message.
Always use the lower version to do export and use same lower version imp tool to import into a higher version database.
Else,
You need to install the higher versions export/import views in the lower version by running catexp.sql

Report message to a moderator

Re: Export oracle 9 to oracle 10 [message #74664 is a reply to message #74662] Tue, 01 February 2005 04:57 Go to previous messageGo to next message
gioser
Messages: 2
Registered: February 2005
Junior Member
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully

Report message to a moderator

Re: Export oracle 9 to oracle 10 [message #74665 is a reply to message #74664] Tue, 01 February 2005 05:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Always use the lower version to do export and use same lower version imp tool to import into a higher version database.
Else,
You need to install the higher versions export/import views in the lower version by running catexp.sql

as said in previous posting , use the lower version of exp ( 9i in your case) to export 9i database and use 9i version of imp to import into 10g database.

Report message to a moderator

Re: Export oracle 9 to oracle 10 [message #110055 is a reply to message #74661] Thu, 03 March 2005 02:39 Go to previous messageGo to next message
ttphuong
Messages: 5
Registered: March 2005
Junior Member
How can i run catexp.sql of ora9i in ora8, since i would like to use exp tool from ora9i to export data from ora8. As i know in catexp.sql, there are CREATE OR REPLACE view(s) from some sys.tables(s) in ora9i are not in ora8. Please help.
Thanks.

Report message to a moderator

Re: Export oracle 9 to oracle 10 [message #110098 is a reply to message #110055] Thu, 03 March 2005 08:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
establish an TNS connection between 8i and 9i machines (databases).

from 9i machine/database
login as
"sys/password@8idatabase as sysdba"
and Run the script in $9i_ORACLE_HOME/rdbms/admin/catexp.sql

as usually always take a backup before doing anything.

Report message to a moderator

Re: Export oracle 9 to oracle 10 [message #110150 is a reply to message #110098] Thu, 03 March 2005 13:56 Go to previous messageGo to next message
ttphuong
Messages: 5
Registered: March 2005
Junior Member
Hi, i really thanks for your help.
I would like to ask if after i run catexp.sql (9i) on
9i machine, by sys/password@8idatabase, will i still
be able to run version 8 export on our version 8
database/machine?
Thanks a lot for your help.

Report message to a moderator

Re: Export oracle 9 to oracle 10 [message #110152 is a reply to message #110150] Thu, 03 March 2005 14:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
NO you cannot.
You have to run do the catexp.sql available at $8_ORACLE_HOME/rdbms/admin logged in as sys against your 8 database.
Then only you use exp/imp version 8 against the version 8 database.

Report message to a moderator

Re: Export oracle 9 to oracle 10 [message #110480 is a reply to message #110152] Mon, 07 March 2005 21:47 Go to previous message
ttphuong
Messages: 5
Registered: March 2005
Junior Member
Hi,
When i compare 2 catexp.sql files of ora8 and ora9, i see in Ora9, there are some extra crea/replace VIEWS that are not in Ora8 (eg: CREATE OR REPLACE VIEW XYZ9ABCDEF AS, but almost all views created on ora8 will be in ora9 (except 1 CREATE OR REPLACE VIEW exu81ind_base) and 2 CREATE OR REPLACE VIEW imp8ttd and CREATE OR REPLACE VIEW imp8ttdu in Ora9 alittle bit different by using table sys.type$ (but that's for import, i guess!).
Since we still runexport in our old version ora8 (unix based), and would like to export to machin using ora9 (window based) ...
how can we do them in the same time? i see function just create or replace, but not delete, so the views once created will be stayed there in database (ora8). Please give us some advice.
Thanks alot.

Report message to a moderator

Previous Topic: using sql loader for XML
Next Topic: Export error in 10g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 09:18:09 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.