[opencms-dev] Oracle problems

[Michael Moossen]

Hi, Carl!

sorry for that... my mistake again :(

drop the UK_BACKUP_CONTENTS constraint and add following indexes:

CREATE INDEX IDX_CMS_BACKUP_CONTENTS_02
	ON CMS_BACKUP_CONTENTS (RESOURCE_ID)
	TABLESPACE ${indexTablespace};
	
CREATE INDEX IDX_CMS_BACKUP_CONTENTS_03
	ON CMS_BACKUP_CONTENTS (CONTENT_ID)
	TABLESPACE ${indexTablespace};
	
Kind Regards,
Michael
 
-------------------
Michael Moossen
 
Alkacon Software GmbH  - The OpenCms Experts
http://www.alkacon.com - http://www.opencms.org




Quoting cfn at kb.dk:

> Hello,
> 
> We have installed OpenCms 6.2.1 using an Oracle DB and that didn't go 
> entirely well.
> 
> We encountered some sql-errors when importing some files because a unique 
> key constraint
> (UK_BACKUP_CONTENTS) was violated.
> Visually this has resulted in some icons missing in the GUI.
> 
> When attemting to publish we also encounter sql-errors because this 
> constraint is violated
> (but the material seems to be published ok).
> 
> In an ealier thread I was instructed to remove the UK_BACKUP_PROPERTIES  
> unique key
> consttraint and add an index.
> 
> Should I drop the UK_BACKUP_CONTENTS constraint or will this cause other 
> problems ?
> Have we made some mistake ?
> 
> Cheers,
> 
> Carl


----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.