RE: Database creation question

From: Powell, Mark <>
Date: Wed, 23 Jan 2013 16:10:02 +0000
Message-ID: <>

Being that Oracle Text is not an extra-cost item and being that it is fairly common for someone to eventually want to use it I see no harm in having it installed and ready for use. We managed to not use XML till version 9.2 and when a developer needed an XDB package we had to go install it. XDB in turn required java in the database which we had not installed. So we had to install both which required getting maintenance windows on production. It the product is included with the RDBMS at no extra cost I think it is better to have it installed and ready to be used when needed than to have to go back and install it.

-----Original Message-----

From: [] On Behalf Of Maureen English Sent: Tuesday, January 22, 2013 9:20 PM
Subject: Database creation question

Do most people install Oracle Text when creating a new 11g database?

I'm finding that with the newly created databases we get an error when we run utlrp. We haven't been installing Oracle Text in the new databases because it wasn't installed in the 10g database. Oracle Application Express is installed, though, because the screen in dbca says not to uncheck it.

I know that the reason for the error is because Oracle Application Express is installed, and Oracle Text isn't. I'm just not sure whether or not to now install Oracle Text when creating new databases...or ignore the invalid objects.

-- Received on Wed Jan 23 2013 - 17:10:02 CET

Original text of this message