Maximo Open Forum

Expand all | Collapse all

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

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

    Posted 17 days ago

    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

    Maximo Certified
    Posted 17 days ago
    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
    ------------------------------



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

    Posted 12 days ago
    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
    ------------------------------



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

    Maximo Certified
    Posted 4 days ago
    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
    ------------------------------