Posts

Showing posts from July, 2013

Migrate all blogger(blogspot) posts to wordpress.

This video shows how to migrate from blogger to wordpress. There are lots of plugins that can be used for greater blogging experience using wordpress.

Oracle/PLSQL: Execute an SQL script file in SQLPlus

Question: How do I execute an SQL script file in SQLPlus? Answer: To execute a script file in SQLPlus, type @ and then the file name. SQL > @{file} For example, if your file was called script.sql, you'd type the following command at the SQL prompt: SQL > @script.sql The above command assumes that the file is in the current directory. (ie: the current directory is usually the directory that you were located in before you launched SQLPlus.) If you need to execute a script file that is not in the current directory, you would type: SQL > @{path}{file} For example: SQL > @/oracle/scripts/script.sql This command would run a script file called script.sql that was located in the /oracle/scripts directory.

Change Oracle password after installation.

To change a password after installation: Start SQL*Plus: C:\> sqlplus /NOLOG Connect as SYSDBA : SQL> CONNECT / AS SYSDBA   Action SQL Statement Unlock a password ALTER USER username ACCOUNT UNLOCK; Lock a password ALTER USER username ACCOUNT LOCK; Change password of an unlocked account ALTER USER username IDENTIFIED BY password ; Change password of a locked account ALTER USER username IDENTIFIED BY password ACCOUNT UNLOCK;  

Resolving ORACLE ERROR:ORA-20000: the account is locked

From your command prompt, type sqlplus "/ as sysdba" Once logged in as SYSDBA, you need to unlock the hr account SQL> alter user hr account unlock; SQL> grant connect, resource to hr;