Keep it Simple and Smart
I have seen two database designs to store the value in Created by and Updated By columns as: Store the PK of user in Created by and Updated By columns Store the user name in Created by and Updated By columns Now you may have question: What is best practice
» Read moreMany time we faced the performance issue because of Locks on rows and it cause the delay to finishing the other transactions. So with the help of following steps you will able to find the locking objects and can release the object locks in Oracle Database. Let us create the
» Read moreData Pump Export is a utility for unloading data and metadata into dump file. The same exported dump file can be imported only by Data Pump Import utility. With the help of this Data Pump Export we can export the data of one machine and import into another machine. Dump
» Read moreWhile trying to connect to a Database using Toad with TNS, Even the TNS entry is created in tnsnames.ora file under Oracle Home\NETWORK\ADMIN Issue 1: SQLNET Editor and TNS Names Editor Disabled as shown in below snapshot Issue 2: Not able to find the TNS Name in the dropdown as
» Read moreData migration is the process of transferring data between storage types, formats, or computer systems. But here we are specifically talking about database (i.e. Sybase, MySQL, DB2, SQL Server and Oracle) migration. Data migration is usually performed programmatically to achieve an automated migration. Most of the times when we change
» Read moreCreating a tablespace and user is a very common task after creating an oracle database. Before going further must read the post Schema vs. User In this post we will see how to create tablespace and user with example Tablespace Each tablespace in an Oracle database consists of one or
» Read moreInstallation Steps: Extract the OracleClientODBC-32Bit or OracleClientODBC-64Bit zipped folder according to the Machine (32bits or 64bits). Now set 4 environment variables at client machine as System Variable. My Computer Properties >> Advanced >> Environment Variables PATH: Set the path. Put ‘;’ at the end of existing path and give the
» Read moreIn this post we will see how we can transfer the data from CSV to oracle database using SQL Loader. SQL Loader is a bulk loader utility used for moving data from external files into the Oracle database. One can use SQL Loader utility to transfer the data for high
» Read moreHere is a simple SQL script with the help we can find the Table Row count for all tables. Yes we can find the row count using select count(*) for each table. This will be useful if you large number of tables are there in your database. Example Script: —
» Read moreError: ORA-01653: unable to extend table in tablespace Cause: Failed to allocate an extent of the required number of blocks for a table segment in the tablespace indicated. Note: Change the table space name for that you need the information in the below Scripts (Script: 1 & 2) Solution: Script:
» Read moreVarinder Sandhu is using WP-Gravatar