Adding 'skip 1' to external table definition after the fact ... ?
I have created several external table definitions from new file definitions but when the 'production' files were created they now have a header row at the top that needs to be skipped so as not to be taken as data.
Is there a way to 'alter' either the file definition or the external table definition to add the 'skip 1' notation without having to recreate the file definition by re-importing the file and then recreating the external table?
I recall there's a place in the file import process that asks for the number of rows to skip.
Many thanks!!
-gary
P.S. this is actually an OWB 10.1.0.4 environment but I would assume it would hold true for 11g as well. :-)