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
Printable View
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
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