EXP options

Hello all...

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

Thanks
Ron

look at the feedback option when you execute exp help=y

thankyou...

So what Should FEEDBACK parameter be ?....is Y/N or 0/1 or ON/OFF ?....


I tried Y/N, it didn't work.


Thanks
Ron

give feedback=1000 if you want a . per 1000 rows inserted or feedback=10000 if you want a . per 10000 rows and so on.

Thankyou....

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

Ron

Use the OWNER= parameter.

HTH

for performance reasons, you might like to arrange to export the different users' schemas at the same time as different export processes.