Solutions for navicat connection to Oracle reporting ORA-12737 set chs16gbk errors
Http://hi.baidu.com/leejun_2005/item/c4a4832247807f142a0f1c5f
{
Core steps
{
Download instantclient-basic-nt-11.2.0.3.0.zip
Http://download.oracle.com/otn/nt/instantclient/112030/instantclient-basic-nt-11.2.0.3.0.zip
Copy OCI. dll, orannzsbb11.dll, oraocci11.dll, and oraociei11.dll In the zip package to {navicat premium installation directory} \ instantclient_10_2
}
}
The simplest way to create a user in Oracle
{
Sqlplus user name, password, host string (this machine can be left blank, other hosts fill in <IP >:< serviceid>, serviceid such as orcl)
Create User Username identified by password;
Grant DBA to username;
}
Oracle creates tablespaces, creates users, and grants and views Permissions
Http://www.blogjava.net/wolfman09/archive/2009/05/01/268536.html
explain the whole process of creating user permissions in Oracle
http://database.51cto.com/art/200911/160283.htm
{< br> delete user
drop User Username cascade;
}