Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    How to tell what tables use a particular database file

    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    How can we tell what tables use a particular database file?

    This error was generated from our backup this weekend:
    RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/15/2010 00:50:11
    ORA-19566: exceeded limit of 0 corrupt blocks for file /ora01/oradata/aleph1/aleph1_ts4d_16.dbf

    Our university DBAs are looking into this issue. Can you tell us what functions might be affected by this file?

    Resolution:
    All of the tables in the tablespace to which the file belongs can/will be using the file.

    Doing util a/17/10/2 to generate a merged file_list for each library, I find these tables using tablespace TS4D:

    libprddb1.lib.abc.edu-18(1) ABC01-ALEPH>>grep TS4D file_list
    TAB z01 200M 0K TS4D
    TAB z02 200M 0K TS4D
    TAB z91 200M 0K TS4D
    TAB z95 200M 0K TS4D
    TAB z98 200M 0K TS4D
    TAB z00 200M 0K TS4D

    libprddb1.lib.abc.edu-18(1) ABC50-ALEPH>>grep TS4D file_list
    TAB z30 200M 0K TS4D

    libprddb1.lib.abc.edu-18(1) ABC10-ALEPH>>grep TS4D file_list
    TAB z01 200M 0K TS4D
    TAB z02 200M 0K TS4D
    TAB z95 200M 0K TS4D
    TAB z98 200M 0K TS4D

    (The abc60 and abc30 library tables don't use TS4D.)


    • Article last edited: 10/8/2013