Description or the error When you encounter an ORA-00904 error, the following error message will appear: ORA-00904: invalid identifier Cause You tried to execute a SQL statement that included an invalid column name or the column name is missing. This commonly occurs when you reference an invalid alias...

Continue reading

   Rsync is an open source utility that provides fast incremental file transfer. Rsync is typically used to synchronize files and directories between two different systems. Base Syntax: [crayon-59e5d3a6a50b3046642896/] or [crayon-59e5d3a6a50bc485335432/] When on localhost only. Why rsync is so good ? Speed: First time, rsync replicates the whole content between the source...

Continue reading

    Starting up and shutting down of Oracle Database is a basic routine operation. But any other programmer or sysadmin  might end-up doing some basic DBA operations on development database. So, it is important for non DBA to understand some basic database administration activities. So, let...

Continue reading