This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
I apologize if this is a dumb question.
I have an installation of Maximo on a server where it is pointing to a development database environment. I took a look at what is involved in pointing Maximo to a different database, but found that our production database doesn't have the Maximo schema, users, indexes, etc..
What is the procedure for creating the required Maximo database structures on an Oracle db?
Are you wondering how to create an empty database with the correct structure or update your Production database with the correct structure?
--- In MAXIMO@yahoogroups.com, "e11271b" <ebennett@...> wrote:
>
> I apologize if this is a dumb question.
>
> I have an installation of Maximo on a server where it is pointing to a development database environment. I took a look at what is involved in pointing Maximo to a different database, but found that our production database doesn't have the Maximo schema, users, indexes, etc..
>
> What is the procedure for creating the required Maximo database structures on an Oracle db?
>
This would be updating an existing oracle database to include the required tables, views, indexes, etc.
I found maxinst. What are the preliminary steps in order to run that script successfully. Do I need to create the maximo schema first or does that script do everything?
--- In MAXIMO@yahoogroups.com, "Jason Verly" <jason.verly@...> wrote:
>
> Are you wondering how to create an empty database with the correct structure or update your Production database with the correct structure?
>
> --- In MAXIMO@yahoogroups.com, "e11271b" <ebennett@> wrote:
> >
> > I apologize if this is a dumb question.
> >
> > I have an installation of Maximo on a server where it is pointing to a development database environment. I took a look at what is involved in pointing Maximo to a different database, but found that our production database doesn't have the Maximo schema, users, indexes, etc..
> >
> > What is the procedure for creating the required Maximo database structures on an Oracle db?
> >
>
Found my answer.. I was missing CTXSYS... Now maxinst ran successfully.
--- In MAXIMO@yahoogroups.com, "e11271b" <ebennett@...> wrote:
>
> This would be updating an existing oracle database to include the required tables, views, indexes, etc.
>
> I found maxinst. What are the preliminary steps in order to run that script successfully. Do I need to create the maximo schema first or does that script do everything?
>
>
> --- In MAXIMO@yahoogroups.com, "Jason Verly" <jason.verly@> wrote:
> >
> > Are you wondering how to create an empty database with the correct structure or update your Production database with the correct structure?
> >
> > --- In MAXIMO@yahoogroups.com, "e11271b" <ebennett@> wrote:
> > >
> > > I apologize if this is a dumb question.
> > >
> > > I have an installation of Maximo on a server where it is pointing to a development database environment. I took a look at what is involved in pointing Maximo to a different database, but found that our production database doesn't have the Maximo schema, users, indexes, etc..
> > >
> > > What is the procedure for creating the required Maximo database structures on an Oracle db?
> > >
> >
>