-
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?
Thanks,
Rara.
-
What was the actual command you used ?
It should be --
imp parfile = <<file_name_with_full_path>>
- 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= <parfilename> you created
Thanks
Kishore Kumar
-
okay...so, I can call it any text file?
Thanks,
Rara.
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|