parfile in export & import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: parfile in export & import

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Posts
    90

    Red face

    Hello,
    Can any one please do an exmaple of how to use parfile in doing an export of a table
    and also make an import of that same table into another database? I am used to the command line method so I'm getting confused over this.

    thanks,
    dorothy

  2. #2
    Join Date
    Oct 2000
    Posts
    24
    Hi,

    I am giving an example

    c:\> exp username@alias parfile=test.txt


    contents of Test.txt

    file=filename.dmp
    tables= tablename
    log=logfilename
    constraints=y

    for import

    c:\> imp username@alias parfile=test1.txt


    contents of Test1.txt

    file=filename.dmp
    fromuser=username
    touser=username1
    ignore=y
    commit=y
    log=logfilename

    when imp table of one user to another user connect from a user with dba privilege.

    -Anand

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