Some Useful Oracle Tips

Here are some of useful oracle tips that is of common use. Hope you will enjoy this article.

1. You can login to SQL by also typing  scott/tiger together means username/password together need not specify in separate text boxes.

2. Someuseful commands to remind when going to start your oracle engine startup ,shutdown immediate,   shutdown, startup nomount

3. Use command  sqlplus/nolog in anywhere in your command prompt directly to get SQL>

       Like  c:\>sqlplus/nolog you will get SQL>

4. For connected as sys user use command SQL:> conn /as sysdba need not enter semicolon. No error if that is there.

5. For showing the user use show user; command.

6. For creating a new user use command create user user1 identified by password

7. Now connect as  general user use conn as username/password

8. Connect holds create session previleges. So when you log in as a new user it will show error.

9. To remove that give permission of create session to your newly created user.

10. Command is grant create session to username.

11. Now you can login as conn as username/password

12. After connected as general user you have to give resource permission 

13. grant resource to username. That will help to user to create table and other permission

14. Please note down that all the permission can be given as sysdba only so for everytime you have to login as sysdba by using command conn /as sysdba