ORA-1653: unable to extend table OPC_OP.OPC_FORWARD_MSGS

Hi,

HPUX 11.11 OVOU 7.24 MC/SG Oracle 8.1.7.4

We are getting these Oracle database error messages from the ocperror log file.
"ORA-1653: unable to extend table OPC_OP.OPC_FORWARD_MSGS by 128 in tablespace OPC_4".

Can we truncate this table or do we need to add a new datafile?

10 points to any good answer.
Thank you
Gino
Parents
  • Verified Answer



    alert_log ERROR
    ORA-1653: unable to extend table
    OPC_OP.OPC_FORWARD_MSGS by 128 in tablespace OPC_4

    LOG in as oracle then get to system user
    sqlplus syntax to extend file
    ALTER DATABASE DATA FILE
    â u01/oradata/openview/OPC__4_1.dbfâ RESIZE newvaluek

    Current size 348160k

    Or if you have â Oracle Enterprise Manager Consoleâ log in as system and drill down to datafiles and open the folder and open the repestive data file. You can extend the data file there.

    All there is a openview command you can use that creates a second datafile. I donâ t recommend creating a second data since it you datafiles look relatively small in physical file size.
Reply
  • Verified Answer



    alert_log ERROR
    ORA-1653: unable to extend table
    OPC_OP.OPC_FORWARD_MSGS by 128 in tablespace OPC_4

    LOG in as oracle then get to system user
    sqlplus syntax to extend file
    ALTER DATABASE DATA FILE
    â u01/oradata/openview/OPC__4_1.dbfâ RESIZE newvaluek

    Current size 348160k

    Or if you have â Oracle Enterprise Manager Consoleâ log in as system and drill down to datafiles and open the folder and open the repestive data file. You can extend the data file there.

    All there is a openview command you can use that creates a second datafile. I donâ t recommend creating a second data since it you datafiles look relatively small in physical file size.
Children
No Data