ORA-01688 error resolution, ora-01688 Error
The ORA-01688 error was reported when the ticket data was imported during the performance test and the ticket data import failed.
ORA-01688: unable to extend table VMSREPORT. VMS_DEPOSIT_MSG_SDR partition VDMS_PART_0825 by 8192 in tablespace VMS_REPORT
Error description for ora-01688 under query:
Oracle @ node76: ~> Oerr ora 01688.
01688,000 00, "unable to extend table % s. % s partition % s by % s in tablespace % s"
// * Cause: Failed to allocate an extent of the required number of blocks
// Table segment in the tablespace indicated.
// * Action: Use alter tablespace add datafile statement to add one or more
// Files to the tablespace indicated.
Query the table space usage. The VMS_REPORT table space usage has exceeded 99.9%.
Therefore, it can be concluded that the error should be due to the fact that the VMS_REPORT tablespace is full, and the automatic expansion function is disabled for the data file, resulting in data import failure.
Use the following command as prompted to add a data file to expand the table space VMS_REPORT size:
Alter tablespace vmsreport add datafile '+ DG_DATA/vms_report01.dbf' SIZE 2048 m autoextend off;
Test again, the ticket data is imported successfully, no ORA-01688 error occurs again.