I tried to import full db from cmd prompt...could not open the parfile.
Do you know why this couldn' t access?
Also, since it is a full import, should I set destroy=Y?
What was the actual command you used ?
It should be --
imp parfile = <<file_name_with_full_path>>
It seems you are getting confused with Par file. You are not supposed to use init.ora file.
You should create one which specifes Imp command specifics., the tablenames, and full=y , compress=n, etc.,
then use it in imp parfile= <parfilename> you created
okay...so, I can call it any text file?
Yes you can call it what you like...
If you create the file c:\import.par which contains the following lines:
Then your import command would be:
The feedback option is useful for knowing how much of large tables have been imported (it will place a dot on screen for every x records depending on the value you set).
For other import options, just type help=y at the cmd prompt, although the ones above are normally sufficient, if minimal.
Click Here to Expand Forum to Full Width