importing oracle 8i database from one server to another
We have numerous division offices with oracle 8i servers which are using win98 and oracle 8i, where data sent through CD's . The division offices sent data to head in dos based .dmp format. I checked the size of data which is satisfactory.
c:> EXP system/manager@instance .. I selected ENTIRE export file options even exported grants , table data to yes
But when i try
c:\> imp system/manager@instance file = abc.dmp full=y
then it imports successfully with warnings.
But when i see data tables no data is there in data tables which should be imported.
any solutions to compile data??
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.