SQL Power Software Forum

in oracle the maximun column length is 30 characters and the adreess corraction project needs to create a table with more length, con you tell me what to do, please

Error starting at line 1 in command:
CREATE TABLE EMPLEADO_address_pool (
src_addr_key_col_0 VARCHAR(15),
input_address_line1 VARCHAR(70),
input_address_line2 VARCHAR(70),
input_municipality VARCHAR(30),
input_province VARCHAR(30),
input_country VARCHAR(30),
input_postal_code VARCHAR(10),
output_country VARCHAR(30),
output_delivery_installation_name VARCHAR(50),
output_delivery_installation_type VARCHAR(5),
output_direction_prefix BOOLEAN,
output_failed_parsing_string VARCHAR(150),
output_general_delivery_name VARCHAR(70),
output_lock_box_number VARCHAR(5),
output_lock_box_type VARCHAR(6),
output_municipality VARCHAR(30),
output_postal_code VARCHAR(10),
output_province VARCHAR(30),
output_rural_route_number VARCHAR(5),
output_rural_route_type VARCHAR(2),
output_street_direction VARCHAR(5),
output_street_name VARCHAR(30),
output_street_number INTEGER,
output_street_number_suffix VARCHAR(6),
output_street_number_suffix_separate BOOLEAN,
output_street_type VARCHAR(11),
output_street_type_prefix BOOLEAN,
output_suite VARCHAR(6),
output_suite_prefix BOOLEAN,
output_suite_type VARCHAR(15),
output_unparsed_address VARCHAR(150),
output_type VARCHAR(

,
output_urban_before_rural BOOLEAN,
output_valid BOOLEAN

ORA-00972: identificador demasiado largo
00972. 00000 - "identifier is too long"
*Cause: An identifier with more than 30 characters was specified.
*Action: Specify at most 30 characters.