Category: DataBase

When you execute the DELETE FROM <Table> command in Oracle, you may receive below error: Say: DELETE FROM password_history ————————— ODBC 32Bit Test Program ————————— SQLSTATE: NA000 Native Error Code:1562 Driver Message:[Microsoft][ODBC driver for Oracle][Oracle]ORA-01562: failed to extend rollback segment number 7 ORA-01628: max # extents (256) reached for rollback segment R06 ————————— OK —————————   Workaround: If Deleting the all the records from a table is failing do delete operation in phases with use of filters to limit the records to be deleted in single shot.   Say: DELETE FROM password_history where Attempt_ID > 1

Creating an empty table: CREATE TABLE usage_stats (timeofday DATE, cnt NUMBER)    Inserting values into the table: insert into usage_stats values (to_date(‘2014-03-01 00:09’, ‘YYYY-MM-DD HH24:MI’), 1)   Query/Verify the inserted entries: Select * from usage_stats   Delete all the entries in the table: DELETE from usage_stats   Delete the table itself () DROP TABLE  usage_stats

How to find the Edition of your Oracle Database: [root@ProdDB01 ~]# su – oracle -bash-3.1$ sqlplus ‘/ as sysdba’ SQL*Plus: Release 8.1.6.0.0 – Production on Tue Mar 25 12:32:46 2014 (c) Copyright 1999 Oracle Corporation.  All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.6.1.0 – Production With the Partitioning option JServer Release 8.1.6.0.0 – Production SQL> select banner from v$version; BANNER —————————————————————- Oracle8i Enterprise Edition Release 8.1.6.1.0 – Production PL/SQL Release 8.1.6.0.0 – Production CORE    8.1.6.0.0       Production TNS for Linux: Version 8.1.6.0.0 – Production NLSRTL Version 3.4.0.0.0 – Production SQL> No. of Users and CPU/Processors: SQL> select * from […]