Oracle Database basic knowledge study notes

Oracle user Creation

Create user xxxxx identified by xxxxx

PROFILE DEFAULT

DEFAULT TABLESPACE USERS

Temporary tablespace TEMPTS01

Account unlock;

Note that you must first check whether there are two tablespaces in your database: USERS and TEMPTS01. If no, create the tablespace USERS and TEMPTS01 before creating the user.

Grant connect, resource to xxx again

Occi reading Oracle Problems

1. occi running on linux system, linux system adopts en_Us.utf-8 encoding mode, Oracle adopts al32utf8 encoding mode. However, the getString method of resultset of occi can be used to read English strings and garbled characters will appear in Chinese.

2. The setDatabuffer of occi does not support strings and new arrays. It is well supported only for Array strings that exist in stacks. However, this issue does not exist for non-string data.

Other problems are being solved. The occi interface is still very fast. Using multiple cycles to import data (affected by the size of the stack space) can reach entries/s on the 3.0g dual-core processor. This speed does not take into account data review and is imported as is.