I used SQL server for a long time and seldom used oracle. When I was using Oracle at that time, I only called it and did not involve operations such as adding databases, creating tablespaces, and creating users.
Follow these steps:
1. Open the Database Configuration assistant and execute it step by step. The graphical interface is relatively simple.
2. -- create a tablespace
Create tablespace rsstest_tbs datafile 'd: \ rsstest_tbs.dbf 'size 500 m
Autoextend on next 1028 K maxsize Unlimited
Extent management local autoallocate
Segment space management auto;
3. -- create a user and assign Permissions
Create user "rsstest" identified by "rsstest" default tablespace "rsstest_tbs ";
-- Temporary tablespace "temporary"
-- Profile default account unlock;
Grant "Connect" to "rsstest ";
Grant "dba" to "rsstest ";
Grant unlimited tablespace to "rsstest ";
Alter user "rsstest" default role all;
Exit;