-
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
Jeff Hunter
-
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.
Amar
"There is a difference between knowing the path and walking the path."
-
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
Jim
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.
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
|