Oracle, creating users, databases using the cmd command line

1, Sqlplus Sys/password as SYSDBA admin login

2, create temporary table space

Change the red part into your own path

Create temporary tablespace mytest
Tempfile ' D:\app\Administrator\oradata\orcl\mytest.dbf '
Size 200m
Autoextend on
Next 200m maxsize 20480m
Extent management Local;

3, create the data table space

Change the red part into your own path

Create Tablespace mytestoracle
Logging
DataFile ' D:\app\Administrator\oradata\orcl\mytestoracle.dbf '
Size 200m
Autoextend on
Next 200m maxsize 20480m
Extent management Local;
4. Create user specified table space
Create user testoracleuser identified by Testoracleuser;
Grant CONNECT,RESOURCE,DBA to Testoracleuser;
Sqlplus Testoracleuser/testoracleuser

Complete