Hi.
I tried to import full db from cmd prompt...could not open the parfile.
parfile=c:\initfilename.ora
Do you know why this couldn' t access?
Also, since it is a full import, should I set destroy=Y?
Printable View
Hi.
I tried to import full db from cmd prompt...could not open the parfile.
parfile=c:\initfilename.ora
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 = <>
- Rajeev
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=you created
okay...so, I can call it any text file?
Yes you can call it what you like...
e.g.
If you create the file c:\import.par which contains the following lines:
userid=system/manager
full=y
file=drive:\path\your_export_filename.extension
log=drive:\path\any_filename.log
commit=y
feedback=100000
Then your import command would be:
imp parfile=c:\import.par
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.
Terry