Deleting a Maximo Application

[amdisuk]

There isn't an option to delete an application in Maximo. To do it you need to run the following sql script.

delete from maxapps where app='MOC';
delete from maxpresentation where app='MOC';
delete from sigoption where app='MOC';
delete from applicationauth where app='MOC';
delete from maxlabels where app='MOC';
delete from maxmenu where moduleapp='MOC';
delete from maxmenu where keyvalue = 'MOC';
delete from appdoctype where app = 'MOC';

Where 'MOC' is the applicaiton name.

[out4fun2]

I was searching for this. Thanks.

[amdisuk]

You're welcome. Glad to have helped.....

[mxes_installer]

Hello,

is it the same for Maximo 7?

Greetings

[anks123]

yes .

[agonny]

how to run this sql code and where

[AmySmith]

I tried to run this SQL script. But I don't getting the path for this. Help me tell me the path. Where should I do this?

[amdisuk]

You'll need an SQL database tool. The one that we used to use is called 'Toad' (you can Google it). Once you connect to the database, which all depends on where it is installed etc., you can just copy and paste the code in.

Al

[Ethen]

toad is a licensed software.. try installing sql plus.. before installing sql plus make sure you have oracle client installed on your system.

[BlayzeIelovich]

It would be nice it you provide some more information about  Deleting a Maximo Application.

[amdisuk]

There isn't anything else to explain! First of all you need a tool that can access the database using sql. SQL Plus was recommended as a free tool. Once you have the tool simply paste the SQL code at the top of this thread and execute it.

All this assumes that you know how to connect to your Maximo database. If you don't then you might have to do a little reading elsewhere.

[BlayzeIelovich]

There isn't anything else to explain! First of all you need a tool that can access the database using sql. SQL Plus was recommended as a free tool. Once you have the tool simply paste the SQL code at the top of this thread and execute it.

All this assumes that you know how to connect to your Maximo database. If you don't then you might have to do a little reading elsewhere.

Thanks amdisuk.

[Today]

• How to get list data whic... by kvnaresh [Today at 12:39:03 am]
• How to change an email ad... by kvnaresh [Today at 12:25:57 am]
• Difference between fixpac... by jithu1989 [Yesterday at 05:25:18 am]
• Maximo Programmer Require... by ravikorukonda [February 06, 2012, 05:59:58 pm]
• Demo Maximo 7.1 Online by hyubby [February 06, 2012, 11:05:43 am]
• Error loading the Object ... by G Jeevan [February 06, 2012, 07:21:36 am]
• plzz attribute in another... by Dileep Kumar [February 06, 2012, 07:02:09 am]
• Jpeg attachments within M... by zenagarfield [February 02, 2012, 02:02:53 pm]
• How to change senders ema... by zenagarfield [February 02, 2012, 10:28:06 am]
• Lead and Crew by G Jeevan [February 02, 2012, 07:08:45 am]