Create Table Space in Oracle DB

Following are the queries which can be used to create table space in Oracle DB.

CREATE BIGFILE TABLESPACE "TABLESPACENAME" DATAFILE 'C:/oraclexe/app/oracle/oradata/TableSpaceName.dbf' SIZE 500M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

alter TABLESPACE "TABLESPACENAME" AUTOEXTEND ON MAXSIZE unlimited;

CREATE USER USERNAME IDENTIFIED BY PASSWORD DEFAULT TABLESPACE "TABLESPACENAME" TEMPORARY TABLESPACE temp;

ALTER USER USERNAME QUOTA unlimited ON "TABLESPACENAME";

grant all privileges to TABLESPACENAME;

commit;