TIPS of Oracle (Keep updating)

If a error says: insufficient privileges when you are using sysdba:

http://blog.youkuaiyun.com/wanghai__/article/details/5057004

 

If you want to backup or restore DB from a backup:

http://blog.sina.com.cn/s/blog_71a2d86b0100u2nt.html

http://www.2cto.com/database/201305/210262.html

 

If you want to create New User:

create user DEV50JRYRPACK identified by 2458380;
alter user DEV50JRYRPACK account unlock;
grant create session to DEV50JRYRPACK;
grant dba to DEV50JRYRPACK;

 

If you want to create new table space:

http://blog.youkuaiyun.com/jinglingqaz/article/details/6608433

 

If you want to fully delete the oracle from your machine:

http://jingyan.baidu.com/article/0a52e3f41c6c0abf62ed728c.html