I have about 50 columns with attributes and comments saved in an excel file and I tried to use the “Create Table” Function/Util in Toad for Oracle to create a table with all 50 columns and their attributes and comments from this excel file. But it did not seem to work. The excel file contains the following information for all 50 columns and these headers are in the first row of the excel file:
ColumnName ColID PK Null DataType Default Comments Histogram NumDistinct EncryptionAlg Salt Trigger
Instead of loading the actual columns and attributes(starts from the second row of the excel file), the utility seems to load the first row which are the headers for each column information. When I clicked the ‘Load Cols From File’ PB in the Create Table screen, I received the following error at line 3:
CREATE TABLE JTOMASIC.JT_DOT_SGN_ASSEMBLY
Error at line 3
ORA-00904: : invalid identifier
I could write a SQL script to create the table, but I then have to copy and paste all the column names, attributes and comments. It is tedious and time consuming. At this point, I am not sure if Toad util can help me to create a table from an excel file.
Any/all the help on this would be greatly appreciated.