| Author |
comments in dump file
|
|
| Andrew Clark 2005-06-17, 11:24 am |
| Hello,
I am doing an import from a dump file that includes comments, like so:
ALTER TABLE "MYTABLE" MODIFY ("MYCOLUMN" DEFAULT 'N' -- this is a comment)"
This results in failure for any such line. I would like to avoid having to
do an 'imp SHOW=y" to get all statements like the above and execute them
manually. Is there an easy way to disregard the comments here?
Thanks,
Andrew
| |
| Anurag Varma 2005-06-17, 1:23 pm |
|
What version of Oracle?
This appears to be bug 3944578
Noted workaround is what you do not want to do.
Anurag
| |
| Andrew Clark 2005-06-17, 1:23 pm |
| "Anurag Varma" <avoracle@gmail.com> wrote in
news:1119030769.996801.142180@g49g2000cwa.googlegroups.com:
>
> What version of Oracle?
>
> This appears to be bug 3944578
>
> Noted workaround is what you do not want to do.
>
> Anurag
>
>
I'm using Orale 9i
Andrew
| |
| Anurag Varma 2005-06-17, 1:23 pm |
| Yup .. the bug is noted against 9i. Allegedly fixed in 10.2
... contact Oracle support if you want to pursue this more...
Anurag
| |
| Andrew Clark 2005-06-17, 8:23 pm |
| "Anurag Varma" <avoracle@gmail.com> wrote in news:1119031807.387695.70130
@g14g2000cwa.googlegroups.com:
> Yup .. the bug is noted against 9i. Allegedly fixed in 10.2
> .. contact Oracle support if you want to pursue this more...
>
>
>
> Anurag
>
Thanks for the info. Is there a resolution of this bug? Or am I out of
luck?
Andrew
| |
| Anurag Varma 2005-06-17, 8:23 pm |
|
Hop over to Metalink and see the bug description for yourself.
I believe I've already stated the key points of the bug (fixed in 10.2
.... open
a tar if you want further answers).
I do not have anything more to add to all this...
Anurag
|
|
|
|