Oracle Database Creation Instance

Open Oracle's DBCA

View the Acyx instance you just created in the Windows service

Log on using Pl/sql developer

Pop up the following prompt box

Start Service Oracleoradb11g_home1tnslistener

Try again using Pl/sql Developer login, login successful

Create a new SQL window

Create a temporary table space

Create temporary tablespace acyx_temp tempfile ' D:\oracle\acyx_temp_01_20180502.dbf ' size 100m autoextend on next 50m maxs Ize 200m;

If you need to delete a tablespace use the following code (you cannot delete the specified xx.dbf directly on the disk)

Drop tablespace acyx_temp_01_20180502.dbf including contents and datafiles;

Create a table space

Create tablespace acyx datafile ' D:\oracle\acyx_01_20180502.dbf ' size 200m autoextend on next 100m maxsize 400m;

Create a user and assign rights

Create user CB identified by CB default Tablespace acyx temporary tablespace acyx_temp;

Grant DBA to CB;

Use the above empowering user CB Login