SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

30EA1: Determine column lengths before csv-Import

dhalekNov 2 2010 — edited Nov 3 2010

Hello out there,
I tried to import a csv (actually semicolon separated and enclosed in double quotes) into a new table using SQL Developer.
I got error messages that some columns are to short (ORA-12899). Now the question is, is there an option having SQL Developer determine the maximum length of the data to propose a suitable column width?
Wenn I convert the csv to Excel an import that, I get similar errors but much later in the process. So Excel-import seems to look much farther ahead than csv-import.
What I need is SQL Developer scanning the whole file to determine the maximum length of data an not only the first row or the first few 1000 rows.
Can this be achieved somehow?

Regards,
dhalek

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 1 2010

Added on Nov 2 2010

#sql-developer

6 comments

1,320 views