WIN10 New Oracle Instance

1 administrator identity into the CMD environment, execute the DBCA command, in the boot of the popup window, complete the instance creation

2 if the appropriate character set is not selected during the creation process (preferably with the default character set), as shown, a warning message appears when entering Plsql developer

Need to modify the registry to change the client's encoding, the network says the path is: hkey_local_machine\software\oracle\key_oradb10g_home1

But actually I finally found the path for hkey_local_machine\software\wow6432node\oracle\key_oradb10g_home1

Select Userenv (' language ') from dual; The result is simplified Chinese_china. UTF8

So modify the registry to simplified Chinese_china. UTF8, but this problem is difficult to completely solve, even if the warning message disappears, but the Plsql developer tool error message is still garbled, so it is best to create a DB instance using the default character set

3. Create a table space

CREATE tablespace "DATA" datafile   ' D:\IDE\ORACLE\PRODUCT\10.2.0\ORADATA\MYDEBUG\oradata01.dbf ' SIZE 512M    on NEXT 8M MAXSIZE 1024M   PERMANENT 8192 SPACE MANAGEMENT AUTO   

A little explanation (refer to from http://blog.chinaunix.net/uid-20802110-id-2105656.html):

LOGGING:

• This clause declares the log properties of all user objects on this tablespace (by default, logging).
• Include tables, indexes, partitions, materialized views, indexes on materialized views, partitioning

Online|offline

• Changes the state of the tablespace. Online makes the tablespace effective immediately after it is created. This is the default value.
• Offline invalidates the table space after it is created. This value can be obtained from the dba_tablespace.

Permanent| Temporary

• Indicates whether a tablespace is a permanent tablespace or a temporary table space.
• Permanent table spaces hold permanent objects, and temporary table spaces hold temporary objects that exist during the session life.
• The temporary table space generated by this parameter has been created since the dictionary was managed and cannot be used with the extent management local option.
• If you want to create a local management table space, you must use the Create temporary tablespace
• Note that the block size cannot be declared after this parameter is declared

BLOCKSIZE integer [K]

• This parameter can be used to set the size of a non-standard block. If you want to set this parameter, you must set the Db_block_size,
• At least one db_nk_block_size, and the value of the declared integer must be equal to db_nk_block_size.
• Note: This parameter cannot be set in a temporary tablespace.

4. Create roles, users, assign permissions, build tables

CREATEtablespace "DATA" DataFile'D:\IDE\ORACLE\PRODUCT\10.2.0\ORADATA\blog\oradata01.dbf'SIZE 512M autoextend on NEXT8M MAXSIZE 1024M LOGGING ONLINEPERMANENTBLOCKSIZE8192EXTENT MANAGEMENT LOCAL autoallocate SEGMENTSPACEMANAGEMENT AUTOCreateRole Manager;Grantconnect,resource,unlimited tablespace toManager;
Create user Heben identified by heben default tablespace data;
Grant Manager to Heben

Create Tablearticle (ArticleID Number(Ten) not NULL, ArticleTitlevarchar2( - Char), Authorid Number(Ten) not NULL, Content blob, Datepublish date, Datelastmaint datedefaultSysdate not NULL, Articlecatcdvarchar2(4 Char)  );

May error when building a table

Grant Connect,resource to Heben; Solve the problem

WIN10 New Oracle Instance