EXP options
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: EXP options

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    look at the feedback option when you execute exp help=y
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Oct 2002
    Posts
    284
    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

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Oct 2002
    Posts
    284
    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

  6. #6
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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!

  7. #7
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    for performance reasons, you might like to arrange to export the different users' schemas at the same time as different export processes.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width