Problem with the imp.exe utility of oracle 9i
Posted on 2003-03-27
I have exported the table in a particular dump file using the exp.exe utility n i have used the system/manager password for it. But when i am trying to import the data in using the imp.exe utility , it only imports the tables which are in the system space, n does not import the tables which are in my table space.
the syntax that i am using is as follows :
D:\oracle\ora91\bin\IMP.EXE system/manager@mis file=d:\all.dmp indexes=y rows=y constraints=y log=d:\impall.log ignore=y full=y
Can u pls tell me why is it importing only the system tables n not my own table space.
Thanks a lot