DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Compilation errors

  1. #1
    Join Date
    Oct 2000
    Posts
    56
    Help!!

    I keep getting tons of compilation errors when i try to export. Would there be something wrong with my export... or is it just the coding itself. I've recompiled and there are still several that come out with compilation errors. what else can i do to compile...
    should i re export and what options should i use this time to export?/ import?
    i generally use a very simple export:

    userid=sys/falconred
    file=expRED.dmp
    log=import.log
    buffer=500000



  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Use full=y/n OR owner=xyz where xyz is the schema you wanted. If there is activity goin on the database use consitent=y


  3. #3
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Talking this is what i do (command line)

    Well, if I need to do a quick export I just goto command line and use something like the below. I never export as "sys". I always export as system.

    [note: for Unix command line]
    exp system/password@shamrock file=/(location)/(filename).dmp owner=V0108 full=y rows=y constraints=y consistent=y log=(location/name).log

    let me know if that helps.

    - Magnus

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