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

Thread: Another parfile question?? still confused

  1. #1
    Join Date
    Oct 2000
    Posts
    90

    Red face

    Hi guys and ladies,
    I am still having a problem understanding the parfile method in export and import
    Assuming I export

    exp parfile = test.txt

    and the contents of Test.txt are as follows

    full=n,
    file=/u02/extension/group/ext.dmp
    tables= tablename
    grants=n
    constraints=n, indexes=, ignore=y, direct=y,
    buffer=200000000
    log=/u02/....................................

    Can any one please complete the LOG PORTION OF EXPORT (i.e. where I have log=/u02/ .................)
    and explain that to me?
    Then show me an example of how you will import the above exported file to another database assuming it has already being FTPed to that database


    thanks,
    dorothy


    [Edited by dorothy on 11-29-2000 at 07:15 AM]

  2. #2
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    log= ... mean the path and filename you want for the log
    then ftp your file to the other machine IN BINARY, so can go for imp:
    imp parfile=file


  3. #3
    Join Date
    Sep 2000
    Posts
    128
    Yes, the log will just list what is being outputt to screen in to a file - call it anything you like:

    e.g.

    Exporting User Scott....

    Table EMP ......1 row exported
    Table DEPT ......10 rows exported
    etc.

    It's good to have because errors disppear off the screen quickly, and it also logs how many rows each table had on export.

    FTP in binary mode:

    Create a parfile (I assume the table doesn't exist?.. If it does, be sure to include ignore=y)

    userid=user/password
    file=/..../ext.dmp
    commit=y
    log=/.../ext_imp.log
    buffer=
    tables=tablename

    you can use commit=n either i) if you're importing into a table which already has data ii) You have Rollback segments big enough to cope with the load.

    then just run:
    imp parfile=parfilename

    One other thing - If you're importing in direct more (because that is the way you're export was done), you must be sure that you have all you're character sets set correctly.
    Are the two database's the same NLS_ ?
    Make sure the environment variable NLS_LANG is the same as your database setup too, or you'll get an error when trying to import.

    Terry

  4. #4
    Join Date
    Jan 2000
    Location
    Silver Spring MD USA
    Posts
    105
    Dorothy,
    In your export parfile, you have 'ignore=y'
    Ignore is an import parameter not export.
    To get a list of export parameters do
    exp help=y
    for import parameters
    imp help=y

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