Debug Report

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.

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.

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;  

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;