[opencms-dev] Oracle problems

[Michael Moossen]

Hi, Jason!

please use the HEAD version of the create_tables.sql file.

Kind Regards,
Michael
 
-------------------
Michael Moossen
 
Alkacon Software GmbH  - The OpenCms Experts
http://www.alkacon.com - http://www.opencms.org




Quoting Jason Trump <jason.trump at brulant.com>:

> 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
> 
> _______________________________________________
> 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
> 


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