Maximo Open Forum

 View Only

  • 1.  How to find all the unused /backup tables used in maximo oracle database

    Posted 05-26-2021 07:56

    Hi All,

    we are trying to find to identify the unused or backup tables that exists in our oracle database for maximo and drop them to free up space in db?

    Can anyone help me with the approach to find the backup/unused tables ?

    Thanks,
    Meghana S
    #Administration

    ------------------------------
    Meghana Siriveli
    ------------------------------


  • 2.  RE: How to find all the unused /backup tables used in maximo oracle database

    Posted 05-26-2021 13:45
    You should be able to query the meta data in Oracle and the meta data in Maximo and compare. For example:

    select * from user_tables

    ... should give you the list of tables in Oracle (including backup tables) if you're logged into Oracle as the Maximo user. Then:

    select * from maxobject where persistent=1 and isview=0

    ... should give you the list of tables that Maximo knows about in the same schema. This query will not include tables that were created outside of Maximo tooling.

    Hope this helps,

    ------------------------------
    Alex Walter
    A3J Group, LLC
    ------------------------------

    Original Message


  • 3.  RE: How to find all the unused /backup tables used in maximo oracle database

    Posted 05-31-2021 05:08
    Edited by Meghana Siriveli 05-31-2021 05:41
    Hi Alex,

    Thanks for your response.

    I have a readonly access to one of the maximo db and when I run this query select * from user_tables it returned me 0 rows.
    and select * from maxobject where persistent=1 and isview=0 returned 1500 rows.

    I still am not able to figure out how to come to a conclusion that this table is unused/backup table.
    Also can you please tell me the difference between ALL_TABLES and USER_TABLES?



    ------------------------------
    Meghana Siriveli
    ------------------------------

    Original Message


  • 4.  RE: How to find all the unused /backup tables used in maximo oracle database

    Posted 06-08-2021 00:37
    Hi Meghna,

    Maximo created backup tables either during ConfigDB automatically or if you have an integration based on IFACE tables and during the creation of new IFACE table, you select the checkbox to backup the existing table before creating a new one with name XX+<table name>

    You can go to SMP folder > .\IBM\SMP\maximo\tools\maximo > Run command dropbackup.bat which will delete the OOB-created backup files.

    ------------------------------
    Prashant Sharma
    EAM360
    ------------------------------

    Original Message


Related Content