I have created several 8.1.7 DB for the same application. I was told the EMP.EXE will get me an export. I did this and works great, but how do I point it to a specific DB? It does not prompt for DB, just user and P/W?
Can 8.1.7 coexist on the same drive, or a seperate drive same machine?
Lastly: Can a 9i .DMP file be imported into an 8.1.7 DB?
Thanks in advance, sorta like learning to fly........................
What exactly is emp.exe...never heard about it...But you can selectively create dumps of specific tables using the export tool...this creates a binary format .dmp file which can be read with the help of the import tool...
As far as installation is concerened u can even install in the same drive but they should reside in different Oracle Homes...
u can use this exp command to dump specific db
u can use 8i's exp.exe to dump 9i db and then imp it into 8i db,howerver,some table using 9i new feature can not be imported 8i