This is one of those obscure errors that has no answer on the Web. I ran into this error trying to migrate an Oracle table to SQL Server (one of many). The issue seemed to be only with certain rows of this table as it migrated majority of the data without issues. Below is the … Continue reading Oracle & .NET: Resolve – Exception calling “Fill” with “1” argument(s): ‘count’ must be non-negative.
Update 2018/11/19: In 12c, you can now do this operation online. Please check out the “ALTER DATABASE MOVE DATAFILE” command which moves the file without you having to copy. Check it out here. I wanted to do a small post on using the DOS command line tool ADRCI to quickly locate problems from the alert log … Continue reading Oracle On Windows – Simple Timeout To Crisis To Moving Data Files to Another Drive
The v$session view If you do not know already, to check who is connected and since when, what their connection status is etc., you would use dynamic view v$session. The view has the following columns: You would kill the required session by issuing Note: The IMMEDIATE option of the above command just returns control … Continue reading Oracle – My KILL’ed Session Continues To Stay On In KILLED Status, Why?
Usually, when you connect to Oracle, you get errors that give you some feedback on what is happening. Today, I ran into an issue where everything just hung. TNSPing, SQLPlus... you name it. The issue had to be connectivity related but what is it? In our case, we use an LDAP server as a directory … Continue reading SQLPlus, TNSPing & everything just hang without errors