hi , iam using oracle 10g rel 2 ,
i tried to export scott schema with this command
exp scott/tiger file=c:\hi.dmp
and it was successful , but i do not know if it exported the data as well or only the structure(tables , constraints , .......) .
and i can not know , because i can not import the exported file to another schema ,
i tried
imp scott/tiger file=c:hi.dmp formuser=scott touser=med
and it was not successful .
what i want is :
export schema structure and data(scott) , then import it to another schema(med) .
thanks in advance