Create Database create tablespace create user

1 Create tablespace tablespcename datafile '  C: \ oracle \ oradata \ AXP \ tablespcename. DBF  '  Size 100 m autoextend on next 10 m;  2   3 -- Create the user  4   Create user jhabb  5   Identified by jhabb  6   Default Tablespace tablespcename  7   Temporary tablespace temp;  8     9   10   Grant DBA to jhabb;  11   Grant unlimited tablespace to jhabb;  12   Grant alter any procedure to jhabb;  13   Grant create procedure to jhabb;  14   Grant create session to jhabb; 15   Grant create table to jhabb;  16   Grant create view to jhabb;  17 Grant Select  Any table to jhabb;  18   Grant create any trigger to jhabb;  19   Grant create sequence to jhabb;  20 Grant create type to jhabb;

Usually, you need to make a backup.