DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: parfile

  1. #1
    Join Date
    Oct 2000
    Posts
    32
    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.

  2. #2
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    What was the actual command you used ?

    It should be --

    imp parfile = <<file_name_with_full_path>>


    - Rajeev

  3. #3
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    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

  4. #4
    Join Date
    Oct 2000
    Posts
    32
    okay...so, I can call it any text file?
    Thanks,
    Rara.

  5. #5
    Join Date
    Sep 2000
    Posts
    128
    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
  •  


Click Here to Expand Forum to Full Width