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