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:
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
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.
Click Here to Expand Forum to Full Width