Schema error with BLC-1.5.1-GA on Oracle DB server
Posted: Thu Jan 26, 2012 4:38 pm
Hi,
during exporting schema to Oracle database encountered an error:
[ERROR] 22:17:32 SchemaUpdate - Unsuccessful: create table BLC_ASSET_DESC_MAP (BLC_STATIC_ASSET_STATIC_ASSET_ID number(19,0) not null, STATIC_ASSET_DESC_ID number(19,0) not null, MAP_KEY varchar2(255 char) not null, primary key (BLC_STATIC_ASSET_STATIC_ASSET_ID, MAP_KEY))
[ERROR] 22:17:32 SchemaUpdate - ORA-00972: identifier is too long
[ERROR] 22:17:37 SchemaUpdate - Unsuccessful: alter table BLC_ASSET_DESC_MAP add constraint FKE886BAE3B439EE29 foreign key (BLC_STATIC_ASSET_STATIC_ASSET_ID) references BLC_STATIC_ASSET
[ERROR] 22:17:37 SchemaUpdate - ORA-00972: identifier is too long
[ERROR] 22:17:34 SchemaUpdate - Unsuccessful: create table BLC_SANDBOX_ACTION (SANDBOX_ACTION_ID number(19,0) not null, DATE_CREATED timestamp, DATE_UPDATED timestamp, COMMENT varchar2(255 char), ACTION_TYPE varchar2(255 char), CREATED_BY number(19,0), UPDATED_BY number(19,0), primary key (SANDBOX_ACTION_ID))
[ERROR] 22:17:34 SchemaUpdate - ORA-00904: : invalid identifier
Regards.
during exporting schema to Oracle database encountered an error:
[ERROR] 22:17:32 SchemaUpdate - Unsuccessful: create table BLC_ASSET_DESC_MAP (BLC_STATIC_ASSET_STATIC_ASSET_ID number(19,0) not null, STATIC_ASSET_DESC_ID number(19,0) not null, MAP_KEY varchar2(255 char) not null, primary key (BLC_STATIC_ASSET_STATIC_ASSET_ID, MAP_KEY))
[ERROR] 22:17:32 SchemaUpdate - ORA-00972: identifier is too long
[ERROR] 22:17:37 SchemaUpdate - Unsuccessful: alter table BLC_ASSET_DESC_MAP add constraint FKE886BAE3B439EE29 foreign key (BLC_STATIC_ASSET_STATIC_ASSET_ID) references BLC_STATIC_ASSET
[ERROR] 22:17:37 SchemaUpdate - ORA-00972: identifier is too long
[ERROR] 22:17:34 SchemaUpdate - Unsuccessful: create table BLC_SANDBOX_ACTION (SANDBOX_ACTION_ID number(19,0) not null, DATE_CREATED timestamp, DATE_UPDATED timestamp, COMMENT varchar2(255 char), ACTION_TYPE varchar2(255 char), CREATED_BY number(19,0), UPDATED_BY number(19,0), primary key (SANDBOX_ACTION_ID))
[ERROR] 22:17:34 SchemaUpdate - ORA-00904: : invalid identifier
Regards.