Enter Your Email

Enter your email address:

Delivered by FeedBurner

Custom Search

Saturday, March 17, 2007

Importing Few Users

I was asked by my friends, few times about - the ways to import more than one user in a go...
I would be creating a parfile like this...
userid=expman/expman@amdbu
file=/bkdump/Exp_Bak/exp_amdbu_0311060054.dmp
fromuser=(schema1, schema2, schema3, schema4)
touser=(schema1, schema2, schema3, schema4)
ignore=y
commit=y
buffer=10000000
log=/export/home/oracle/amdbu/imp_schemas.log
feedback=1000000

No comments:

Post a Comment

 
Copyright © 2005 - 2008 DBA-ONWeb Technical blog. All rights reserved