Category: DataBase

DataBase, Server

FIX: ORA-01653: unable to extend table <tablename>.WEBLOG_TEMP by <Size> in tablespace RAPP ORA-27059: skgfrsz: could not reduce file size Linux Error: 22: Invalid argument

Scenario: You notice below error on a Oracle DB server hosted on a Linux system if, your tablespace Extent DB file (.ddf) is over size of 2 GB on your Linux System you reached max file size of an Extent allowed for your tablespace   Weblog2.addRequest(testlaunch) WelogEntry failed: action=launch remote=95.211.217.68 ref=null agent=Pingdom.com_bot_version_1.4_(http://www.pingdom.com/) java.sql.SQLException: ORA-01653: unable to extend table APPINFRATABLE.WEBLOG_TEMP by 16158 in tablespace RAPP ORA-27059: skgfrsz: could not reduce file size Linux Error: 22: Invalid argument Additional information: 1 ORA-27059: skgfrsz: could not reduce file size Linux Error: 22: Invalid argument Additional information: 1 ORA-27059: skgfrsz: could not reduce file […]

Read more
DataBase

Fix: ORA-01653: unable to extend table by <size> in tablespace

Scenario: You have Oracle Database hosted on Linux systems located apart in two datacenters with replication enabled to synchronize the data.  Assume you have a web based application that reads/writes data from/to the database.  Your application is coded to replicate the data across the Oracle DBs located in datacenters.  All read operations working fine but whenever you attempt to write data you are encountering below error message: Error updating WebSite: Replication Exception: ORA-01653: unable to extend table PROD.DEBUGLOG by 5394 in tablespace MYAPP ORA-06512: at "PROD.REPLIB", line 30 ORA-28579: network error during callback from external procedure agent ORA-06512: at "PROD.REPL", […]

Read more
DataBase

Export Sql Server Data to Excel

When working with large SQL databases, you might need to keep track of certain parameters. In order to organize different specifications of a database, you can use an application that converts this data into an Excel table. These programs can help you with what you’re intending to do: 1 EMS Data Export 2007 for SQL Server Shareware EMS Data Export for SQL Server is a powerful tool to export SQL Server database data quickly to any of 19 available formats, including MS Access, MS Excel, MS Word (RTF), HTML, XML, PDF, TXT, CSV, DBF, ODF and others. The program supports […]

Read more