Printable View
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
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
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