Import Export among differnet Oracle Versions

Hi there,
  Could you be a little more specific here...I am talking about exporting a table (table.dmp file) in Oracle 8i and then importing the same file in Oracle 8


thanks


Hassan

Hi
I exported ie created a .dmp file from 8i and then copied the IMP.exe from the 8i installation onto a floppy, its 107kb.
Then I used this imp file to import into a previous version instead of the imp.exe that was installed.
eg using a dos box
 a:\imp my.dmp  etc
THis worked between oracle version 8.1.7 and 8.1.6.
I have not tried it between 8i and 8.
Best of luck
Dick B

Hassan,
   This is right out of the utilities manual (the short answer is you can do it, but some obvious feature differences will apply):

Creating Oracle Release 8.0 Export Files from an Oracle8i Database:

You do not need to take any special steps to create an Oracle Release 8.0 export file from an Oracle8i database; however, certain features are not supported.

Export does not export rows from tables containing objects and LOBs when you use Export release 8.0 on an Oracle8i database and have specified a direct path load (DIRECT=Y).

Export does not export dimensions when you use Export release 8.0 on an Oracle8i database.

Functional and domain indexes will not be exported when you use Export release 8.0 on an Oracle8i database.

Secondary objects (tables, indexes, sequences, and so on, created in support of a domain index) will not be exported when you use Export release 8.0 on an Oracle8i database.

Views, procedures, functions, packages, type bodies, and types containing references to new release 8.1 features may not compile when you use Export release 8.0 on an Oracle8i database.

Objects whose DDL is implemented as a stored procedure rather than SQL will not be exported when you use Export release 8.0 on an Oracle8i (or earlier) database.

Triggers whose action is a CALL statement will not be exported when you use Export release 8.0 on an Oracle8i database.

Tables containing logical ROWID columns, primary key refs, or user-defined OID columns will not be exported when you use Export release 8.0 on an Oracle8i database.

Temporary tables will not be exported when you use Export release 8.0 on an Oracle8i database.

Index Organized Tables (IOTs) will revert to an uncompressed state when you use Export release 8.0 on an Oracle 8i database.

Partitioned IOTs will lose their partitioning information when you use Export release 8.0 on an Oracle8i database.

Indextypes and operators will not be exported when you use Export release 8.0 on an Oracle8i database.

Bitmapped and temporary tablespaces will not be exported when you use Export release 8.0 on an Oracle8i database.

Java source/class/resource will not be exported when you use Export release 8.0 on an Oracle8i database.

Varying-width CLOBs, collection enhancements, and LOB-storage clauses for VARRAY columns or nested table enhancements will not be exported when you use Export release 8.0 on an Oracle8i database.

Fine-grained access security policies are not preserved when you use Export release 8.0 on an Oracle8i database.

Good luck!

ADMINISTRATION WILL BE CONTACTING YOU.  THIS IS BEING POSTED IN ALL YOUR OPEN QUESTIONS TODAY.

This question appears to have been abandoned. Your options are:
 
1. Accept a Comment As Answer (use the button next to the Expert's name).
2. Close the question if the information was not useful to you. You must tell the participants why you wish to do this, and allow for Expert response.
3. Ask Community Support to help split points between participating experts, or just comment here with details and we'll respond with the process.
4. Delete the question. Again, you must tell the other participants why you wish to do this.

For special handling needs, please post a zero point question in the link below, include the question QID/link.
https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
 
Please click this Help Desk link for Member Guidelines, Member Agreement and the Question/Answer process:  Click you Member Profile to view your question history and keep them all current with updates as the collaboration effort continues.
https://www.experts-exchange.com/jsp/cmtyHelpDesk.jsp

To view your open questions, please click the following link(s) and keep them all current with updates.
https://www.experts-exchange.com/questions/Q.11756459.html
https://www.experts-exchange.com/questions/Q.11966818.html
https://www.experts-exchange.com/questions/Q.20002985.html
https://www.experts-exchange.com/questions/Q.20080116.html
https://www.experts-exchange.com/questions/Q.20117054.html
https://www.experts-exchange.com/questions/Q.20136568.html
https://www.experts-exchange.com/questions/Q.20141808.html
https://www.experts-exchange.com/questions/Q.20170683.html
https://www.experts-exchange.com/questions/Q.20177412.html
https://www.experts-exchange.com/questions/Q.20192197.html
https://www.experts-exchange.com/questions/Q.20211088.html
https://www.experts-exchange.com/questions/Q.20244652.html
https://www.experts-exchange.com/questions/Q.20245681.html
https://www.experts-exchange.com/questions/Q.20250442.html
https://www.experts-exchange.com/questions/Q.20259920.html
https://www.experts-exchange.com/questions/Q.20263344.html
https://www.experts-exchange.com/questions/Q.20272565.html
LOCKED AWAITING ACCEPTANCE
https://www.experts-exchange.com/jsp/qShow.jsp?ta=oracle&qid=20254380
https://www.experts-exchange.com/jsp/qShow.jsp?ta=oracle&qid=20170530
https://www.experts-exchange.com/jsp/qShow.jsp?ta=oracle&qid=20156898
https://www.experts-exchange.com/jsp/qShow.jsp?ta=oracle&qid=20073456
https://www.experts-exchange.com/jsp/qShow.jsp?ta=oracle&qid=20015528


PLEASE DO NOT AWARD THE POINTS TO ME.  
 
------------>  EXPERTS:
 
Please leave any comments regarding this question here on closing recommendations if this item remains inactive another three days.
 
Thank you everyone.
 
Moondancer
Moderator @ Experts Exchange


P.S.  For year 2000 questions, special attention is needed to ensure the first correct response is awarded, since they are not in the comment date order, but rather in Member ID order.

My request has been ignored, even though Asker logged in 3/8/02 and Administration contacted them.

Is the Proposed Answer correct so I can close this?

Moondancer - EE Moderator

I assume this question is 'dead'
I have no further comments to add.
Dick B

Asker logged in AFTER my request was posted and chose not to respond.  I can therefore only assume this was an accepted response and will finalize this today.  If additional points are appropriate for other participants here, please let me know.

Sorry to see any questions asked, help given and then abandoned.

Moondancer - EE Moderator