First, create temporary space
Create temporary tablespace user_temp
Tempfile ' E:\APP\SCOTT\ORADATA\ORCL\user_temp.dbf '
Size 50m
Autoextend on
Next 50m maxsize 20480m
Extent management Local; Second, create the data table space
Create Tablespace User_data
Logging
DataFile ' E:\APP\SCOTT\ORADATA\ORCL\user_data.dbf '
Size 50m
Autoextend on
Next 50m maxsize 20480m
Extent management Local; third, create a user and specify a table space
Create User C # #nansw identified by nansw1015
Default Tablespace user_data
Temporary tablespace user_temp;
Initial user name is NANSW, prompt error ORA-65096: Invalid public user name or role name
Online Search data, said that the name prefix must be c##, so the user name has become a C # #nansw authorize to C # #nansw, PS: Set permissions as needed
GRANT CREATE any view,drop any view,connect,resource,create session,dba to C # #nansw;