Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> comments in dump file

comments in dump file

From: Andrew Clark <nospam_at_nospam.com>
Date: Fri, 17 Jun 2005 16:16:53 GMT
Message-ID: <1119025013.53d74928d1e06e7f0c000050e4f56a82@teranews>


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 Received on Fri Jun 17 2005 - 11:16:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US