Printable View
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
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.".Quote:
Originally posted by akhadar
It is not possible to take export from higher version to lower version except in 9i.
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.
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.Quote:
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.
HTH
where did i get that catexp and how to use it ??Quote:
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
In the place/box where you have installed Oracle 8i client, see in $ORACLE_HOME/RDBMS/ADMIN.Quote:
Originally posted by dinkar
where did i get that catexp and how to use it ??
The script has instructions about how to run it.
HTH.
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?
If you don't know where it is then this solution is not for you.Quote:
Originally posted by dinkar
where did i get that catexp and how to use it ??
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
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.Quote:
Originally posted by slimdave
caan you find a reference in the documentation to executing the 8i catexp on 8?
Ok here is reference pointer.
http://metalink.oracle.com/metalink/...&p_id=158845.1
HTH