Iam Trying to EXP a 9.2 DB. For Some tables that have large records, EXP appears to have been stuck for some time. So is there a way where we can see how many records it has already exported for a particular table during the EXP process ?...
look at the feedback option when you execute exp help=y
So what Should FEEDBACK parameter be ?....is Y/N or 0/1 or ON/OFF ?....
I tried Y/N, it didn't work.
give feedback=1000 if you want a
. per 1000 rows inserted or feedback=10000 if you want a . per 10000 rows and so on.
"There is a difference between knowing the path and walking the path."
I have one more question....
How do i EXP more than 1 Schema at a time ?....suppose i have 2 Schemas i need to export at one time, how do i do it ?...
thanks for all your help
Use the OWNER= parameter.
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny" Click HERE to vist my website!
for performance reasons, you might like to arrange to export the different users' schemas at the same time as different export processes.
Click Here to Expand Forum to Full Width