scheduling

[dinkar]

i am having netware server 5.1 with oracle 8 . daily i am exporting one user`s database into some .dmp file by using enterprise manager and whenever i need i am importing that file . are there any scheduling options in oracle 8 enterprise manager for netware . one more thing i have to clarify is can we export the database of an oracle 8 server`s user by using oracle 8i client . plz help me in these issues
thanks in advance

[akhadar]

It is not possible to take export from higher version to lower version except in 9i.

[slimdave]

Originally posted by akhadar
It is not possible to take export from higher version to lower version except in 9i.

Thats not what was being asked. This question is "can i use 8i export utility to export from an 8.0 database.".

I don't think it is possible, although you CAN create an Oracle 8.0 export file from an 8i database.

You could just try it though -- Oracle will soon tell you if you can't.

[adewri]

Originally posted by slimdave
I don't think it is possible, although you CAN create an Oracle 8.0 export file from an 8i database.

yes it may be possible if you run Orale8i catexp on Oracle8.0 database, that will create the export views required by the oracle8i exp utility to do an export from oracle8.0 database.

HTH

[dinkar]

Originally posted by adewri
yes it may be possible if you run Orale8i catexp on Oracle8.0 database, that will create the export views required by the oracle8i exp utility to do an export from oracle8.0 database.

HTH

where did i get that catexp and how to use it ??

[ggnanaraj]

Originally posted by dinkar
where did i get that catexp and how to use it ??

In the place/box where you have installed Oracle 8i client, see in $ORACLE_HOME/RDBMS/ADMIN.

The script has instructions about how to run it.

HTH.

[slimdave]

dinkar, why don't you just use the v8 client to export from the v8 database? Where does this fascination with 8i export come from?

[adewri]

Originally posted by dinkar
where did i get that catexp and how to use it ??

If you don't know where it is then this solution is not for you.

My answer was to state one of the possibilities. So if you do not have much experience (and you don't have, your question says all) then don't do it, cause running Oracle8i catexp will overwrite your existing oracle8.0 export views.

First try what is in hand, if it does not work, go to Oracle support and even if then it doesn't work (which is less likely) then only go for other possibilities.

Go with what slimdave has suggested.

HTH

[slimdave]

caan you find a reference in the documentation to executing the 8i catexp on 8?

[adewri]

Originally posted by slimdave
caan you find a reference in the documentation to executing the 8i catexp on 8?

This one is not documented in Oracle Documentations but is a solution that works.

Ok here is reference pointer.
http://metalink.oracle.com/metalink/...&p_id=158845.1

HTH