[opencms-dev] Oracle problems

[Jason Trump]

Hi Guys,

I recently ran across this problem, and similar ones (problem with
UK_BACKUP_PROPERTIES constraint) trying to do an install of 6.2.1
against an Oracle 8i database.  

I noticed in the process that there are significant differences between
setup/database/oracle_8/create_tables.sql (included with 6.2.1 binary
distribution on opencms.org) and the SQL script with tag build_6_2_1 in
CVS.  

Is there a problem with the 6.2.1 build posted to opencms.org?  Should I
use build_6_2_1 from CVS instead?

Thanks
jt

> -----Original Message-----
> From: opencms-dev-bounces at opencms.org [mailto:opencms-dev-
> bounces at opencms.org] On Behalf Of Michael Moossen
> Sent: Tuesday, May 09, 2006 6:55 AM
> To: The OpenCms mailing list
> Subject: Re: [opencms-dev] Oracle problems
> 
> 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.
> 
> 
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please
visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev